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.