Crystal Reports

[Vij]

Hi All,
I am looking for pointers, for what looks to be a reasonable requirement.
Currently we have few predefined reports that can be invoked from the application. However, the new requirement is that the admin should be able to add new reports and they should be recognized and displayed on invoking from the client.

Whats the best way of doing it ?

Our app is a 3 tier architecture, the client talks to db thru middle tier(sitting on the server). So the DSN resides just on the server. Database connectivity from Client directly is not desireable.

We have all the preconfigured reports in the reports folder on the client, which on invoking is populated from the client (app) which calls a SP and then binds the data to the report.
(Report format just has the Field definition, they are not bound to database directly)

Thanks,
Vijay

[faatimah]

hi Vijay
I don't know about your question but I'd really appreciate if u can help me with mine since i see u are working on crystal reports...my problem is i am trying to print an invoice which has the parts and services a customer used at a repair shop...now when i print it out it goes through the tables and finds the parts and services well but if there are more parts then services then it repeats the services to the same number of records as the parts in the details section...i tried group by but it doesn't work or maybe i am not doing it right! if you have any suggestions i'd appreciate.

thank u in advance,
fatima