Explain how would you store your query in an SSRS report or a Database server?
Answer / Pushkar Srivastava
You can store your queries in an SSRS report as Report Data Sources or Datasets. In the report designer, you define a connection to your data source and create a SQL query or use a Stored Procedure. Alternatively, you can directly execute SQL queries on the database server, bypassing SSRS, but this approach may not provide the full functionality of SSRS.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is subreport?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Mention what are the different types of ssrs reports?
What are drillthrough reports?
What is query parameter in ssrs?
Mention what are the core components of ssrs?
what method you can use to reduce the overhead of Reporting Services data sources?
What is the report model project?
User wants only to display only pdf as export option in report manager. How to achieve this?
What are advantages of ssrs or why we should use ssrs?
What are the new features of sql server 2008 r2 reporting service?
How does the report manager work in SSRS?