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 |
How to create “dependant” parameter “make, model, year”
What is data set in report?
What are the drawbacks of reporting in ssrs?
How to backup SQL Server Reporting Services ?
can you implement data mining in SSRS?
How to fine-tune reports?
what are the different types of SSRS reports?
Explain how you can deploy an SSRS report?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How to change parameter value inside the report?
What is the web service used for reporting services?
What is the rdl file?