Link to home
Start Free TrialLog in
Avatar of eviglotti
eviglotti

asked on

How can I generate multiple iterations of one report in Crystal Reports server

Hello,

I have a table of XXX customers and another table with all of the billable hours for all of my customers. So imagine table A will have customer ID and customer name and table B will have customer ID, date and hours spent. I want to create a generic invoice that has all the makings of a standard invoice. However, I add a lot of clients each month and I don't want to have the maintenance of this all, so ideally I would like to create one report in Crystal Reports and once a month at the time of invoicing, I would like to go through the web browser of Crystal Reports Server and click one button, enter the date range or something and then have it dynamically loop through and query the SQL database for all records in table B for the date range and generate a PDF for EACH of the customers that it found records for. The PDFs would then be named with the customer's name so that without me triggering each one separately or scheduling 23 individual jobs, the system would just loop through and create 23 individual PDF files, one for each client. Then next month, let's say there are 27 clients, it would generate 27 individual PDF files, without me having to click off 27 times for each report or setup 27 aliases or whatever they would be called.

Any ideas if this is possible and if so how?

FYI, I'm talking about the Crystal Report Server from SAP that is about $2,500 for 5 named users, so perhaps a product in this price range can't do something like this.

Thanks!
SOLUTION
Avatar of vasto
vasto
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

I don't know if CR server can do publications.

It also would not be too difficult to write an application in VB6 or .Net to do what you want.

mlmcc