How do you specify a range for a report

Asked By tadelesh 0 points N/A Posted on - 01/10/2012

How do you specify a range for a report from SQL Server Report Services to be exported to MS Excel? The range should have a name and refers to some cells with certain columns for the rows that are rendered for table control.

• Status: Open
• Question Views: 775
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Mathew Stone 0 points N/A #83590

How do you specify a range for a report

The reports will be processed in the order that is given below:

• query execution
• report of processes
• rendering of reports.

In order to reduce overall time that is required for processing, there are some things that you will need to decide, and those pertains to which data you will need to retrieve from the data source, and also which calculations you will need to be included in the report.

What the reporting Services does is that it offers support to  a wide range of data sources, and some of the include the:

• plain file systems
• the advanced database servers
• and also the powerful data warehousing systems.

What the functions of the data sources are and also the structure that has been used for the report will be the one to determine the operations that will be done in the query, as opposed to the operations that will be done inside of the report.

-Mathew Stone

 

About Mathew Stone

Questions
0

Answers
99

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 01/10/2012
• Question Category: MS SQL Server