Hi,
i have a 1 page report with shows users information via ssn.I built a parameter for user names and surnames its gives the report of this user via ssn value of the parameter.I want to ask that when i give this param multiple value property true and give the report filter IN operator when i select two users it does not shows 2 different users in 2 different pages and report runs very slowly.Sometimes gives not responding error.
i have a 1 page report with shows users information via ssn.I built a parameter for user names and surnames its gives the report of this user via ssn value of the parameter.I want to ask that when i give this param multiple value property true and give the report filter IN operator when i select two users it does not shows 2 different users in 2 different pages and report runs very slowly.Sometimes gives not responding error.
1 Answer, 1 is accepted
0
Hi Teoman,
If the datasource used for the report contains large number of rows (i.e. > 1000), a slowdown for rendering the report would be observed as the Report Parameters and Filters work with the whole data. If you want to fetch only a subset of the data you would have to filter on database level directly as shown in the Design Time Support for Parameterized Queries video.
As for showing each results on a new page - this is not expected by design, on the contrary records are shown one after the other. To show them on separate page, you should apply a PageBreak after a certain section or group (this depends on your exact layout and scenario).
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
If the datasource used for the report contains large number of rows (i.e. > 1000), a slowdown for rendering the report would be observed as the Report Parameters and Filters work with the whole data. If you want to fetch only a subset of the data you would have to filter on database level directly as shown in the Design Time Support for Parameterized Queries video.
As for showing each results on a new page - this is not expected by design, on the contrary records are shown one after the other. To show them on separate page, you should apply a PageBreak after a certain section or group (this depends on your exact layout and scenario).
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.