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,

I'll take a try at this one.

I think you want each customer to have their own bill,

yet you want to run the report just one time.

I'm going to assume that you can move the data

file to Excel (or another source file that Crystal can read)

Hook up the report to the source file.

Group the report on the Customer ID and/or Name.

Place the fields that you want in the Detail section.

When you're done, go to the last section that you want to display,

right click on the left margin, go to Section Expert and choose

"New Page After".

Hope this helps,

Jim

[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

[Former Member]

Hi John

I'm afraid I'm not much clear with your requirement!

But logically thinking,you can create a crystal report which will fetch all calls into it and then apply a group on the Person's ID.This will group the calls created by each person into sections,after which you can do top-level manipulations on it

Regards

RR