Bruce Bacher
Top achievements
Rank 1
Rank 1
Bruce Bacher
asked on 18 May 2010, 03:00 PM
I have a question about what happens "behind the scenes" with a report filter.
Scenario: I have a web app with a report that uses a SQLServer view as its data source. The view contains data for all clients. For sake of an example, let's say there are 10,000 clients. The report has 1 ReportParameter, the ClientID, and that parameter is used to Filter the results shown on the report.
What happens behind the scenes to pull data onto the report? I can imagine two possibilities:
1) The report viewer opens the view, and 10,000 rows of data are passed from the SQLServer to the WebServer. The report viewer filters the data down to 1 row by ClientID and displays the report to the end user.
OR
2) The report viewer reads the ReportParameter and passes a query string to the SQLServer like "Select * from View WHERE ClientID = 'XYZ'". Then, the SQLServer passes just 1 row of data to the Webserver, and the report viewer displays the report.
I expect the answer is #1, but I hope for #2. Clearly, #2 results in a LOT less network traffic.
Scenario: I have a web app with a report that uses a SQLServer view as its data source. The view contains data for all clients. For sake of an example, let's say there are 10,000 clients. The report has 1 ReportParameter, the ClientID, and that parameter is used to Filter the results shown on the report.
What happens behind the scenes to pull data onto the report? I can imagine two possibilities:
1) The report viewer opens the view, and 10,000 rows of data are passed from the SQLServer to the WebServer. The report viewer filters the data down to 1 row by ClientID and displays the report to the end user.
OR
2) The report viewer reads the ReportParameter and passes a query string to the SQLServer like "Select * from View WHERE ClientID = 'XYZ'". Then, the SQLServer passes just 1 row of data to the Webserver, and the report viewer displays the report.
I expect the answer is #1, but I hope for #2. Clearly, #2 results in a LOT less network traffic.
4 Answers, 1 is accepted
0
Bruce Bacher
Top achievements
Rank 1
Rank 1
answered on 21 May 2010, 08:32 PM
Wow, I really expected an answer from the Telerik folks...
I guess there are a few explanations for the lack of response:
1) I've stumped the panel.
2) The question is so stupid it isn't worth answering.
3) Nobody who knows the answer has seen it.
4) Something else?
So, which is it? Give it to me straight - I can take it.
I guess there are a few explanations for the lack of response:
1) I've stumped the panel.
2) The question is so stupid it isn't worth answering.
3) Nobody who knows the answer has seen it.
4) Something else?
So, which is it? Give it to me straight - I can take it.
0
Hello Bruce,
First note that we do not guarantee a reply in the forums, although we do try to answer all inquiries.
Second, we're still awaiting your reply in the "Picture Box & ScaleProportional" ticket. Once we clear this out, we would answer any subsequent inquiries you have.
Thank you for the understanding.
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
First note that we do not guarantee a reply in the forums, although we do try to answer all inquiries.
Second, we're still awaiting your reply in the "Picture Box & ScaleProportional" ticket. Once we clear this out, we would answer any subsequent inquiries you have.
Thank you for the understanding.
Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Bruce Bacher
Top achievements
Rank 1
Rank 1
answered on 24 May 2010, 05:46 PM
Sorry - I wasn't even aware of that support ticket. After you mentioned it I went looking for it and found it. I have now responded and closed it.
0
Hi Bruce Bacher,
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Both of the approaches are feasible with Telerik Reporting. Report parameters typically are used to filter report data that is retrieved from a data source. Filtering data at the data source can improve performance for processing and viewing a report. For the times when you cannot filter data at the source, you can use parameters to filter report data after it is retrieved.
Check out the following help articles:
Filtering Data
Using Parameters with the SqlDataSource component
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.