I’m writing hoping that this is not the only option,
or another option may be offered in a future release.
For example, let’s say we wanted to generate an employee
payment history report where the Excel export had each employee on a different
worksheet. I am by no means an expert on
Telerik Reporting, so please correct me if I’m wrong, but if my understanding is
correct, that would mean multiple (and unnecessary) hits to the DB.
The first DB hit would return the employees to report on. If there are 100 employees, it would mean 100
Payment History InstanceReportSources would be added to a Report Book. Then, when the Report Book is generated, each
of the 100 Payment History reports would hit the DB with its given employee ID.
Is this the way it’s supposed to work?
Why couldn’t the Payment History report be configured to
create a new Excel sheet based on a grouping of the employee ID? That would require only 1 hit to the DB.
Again, if I’m missing something or if there’s a
better way, please educate me.