Hi There,
I'm currently building a Report showing user data by calling a LINQ Function through a .dll and setting my Datasource accordingly for the Report. Everything works fine in the Details area of the report, but it's the Report Header area I am having some problems with.
My function is pulling Employee Information from the Database and displaying the info for the "selected" employee. This displays all of the information on the selected employee in the Details area of the report. But since the Report doesn't know that it's Datasource is only selecting for ONE employee, it copies the data to each page of the report.
For instance; If the selected employee has 12 records in the database, those 12 records are displayed, and then displayed again on every page for another 12 pages. Making my report 12 pages longer than it should be.
Is there a built in Function that I am missing in the Report to tell a Textbox to only display one record?
Best Regards,
Landon
I'm currently building a Report showing user data by calling a LINQ Function through a .dll and setting my Datasource accordingly for the Report. Everything works fine in the Details area of the report, but it's the Report Header area I am having some problems with.
My function is pulling Employee Information from the Database and displaying the info for the "selected" employee. This displays all of the information on the selected employee in the Details area of the report. But since the Report doesn't know that it's Datasource is only selecting for ONE employee, it copies the data to each page of the report.
For instance; If the selected employee has 12 records in the database, those 12 records are displayed, and then displayed again on every page for another 12 pages. Making my report 12 pages longer than it should be.
Is there a built in Function that I am missing in the Report to tell a Textbox to only display one record?
Best Regards,
Landon
2 Answers, 1 is accepted
0
Accepted
Hi Landon,
Peter
the Telerik team
We are not sure we understand your inquiry. Generally Telerik Reporting is a data driven reporting solution, thus you have to prepare your data accordingly. For example you can use the DISTINCT keyword to limit the number of rows to the unique ones.
All the best,Peter
the Telerik team
0
Landon
Top achievements
Rank 2
Rank 2
answered on 19 Nov 2010, 06:11 PM
Thank you for the quick reply!
I actually ended up solving my problem by creating separate Functions and using the "FindItem" Method to set some of my Report Items. My apologies for being vague in my initial post.
Thanks again,
Landon
I actually ended up solving my problem by creating separate Functions and using the "FindItem" Method to set some of my Report Items. My apologies for being vague in my initial post.
Thanks again,
Landon