Multiple reports from one data source?

[Former Member]

Hi,

Every month we get a data file of 50,000-100,000 calls our customers make, which we then bill.

There are a few hundred customers in the data.

Is there any way to create multiple reports quickly from one data source in Crystal Reports? As doing it manually takes too much time.

I appreciate Crystal Reports might not be able to do this, but just wanted to check.

Thanks,

[Former Member]

Hi John,

If I understand this correctly:- you want to avoid creation of new report(s) for every new sample of data or you want to automate the process of report refresh/running

In that case, If you have the license for Crystal Reports Server(CRS) or Business Objects Enterprise(BOE), then this is achievable.

By using the scheduling feature, the existing reports can be set-up to run at scheduled time.

For a scheduled instance, the output file format can be set and the destination can also be defined.

Prerequisite would be to run a scheduler at the backend so that the RDBMS will read the data from the dump(for e.g excel files) stored at a specific file location. for e.g: Microsoft SQL Server DTS(Data transformation Services) or SQL Server Integrated Services(SSIS)

Once this is done, the latest data will be available in the scheduled instances of the same report(s) that actually showed the old data. No need to create new reports for every new sample of data.

Thanks,

Prathamesh