How to display multiple records grouped into single page/report?

[Former Member]

Hello;

Is it possible to list multiple records, linked by common id onto a single report. The data file is not relatational but just a flat table. (the table can contain multiple records).

My question is: Can you group or combine these records and listed the multiple/matching ones, based on the matching id onto single report, which should represent a report containing all matching instances per ID?

Thank you in advance!

Nikolay

[JWiseman · Accepted solution]

hi Nikolay,

if you've already connected to the flat table, assuming you're using the microsoft text driver or the text driver installed with crystal and have defined the field types, then this should be no problem.

you can either create a new report via the Report Creation Wizard or just a new blank report without using the wizard.

you may wish to use the Report Creation Wizard as it will walk you through adding fields from your flat table and then in later step will have you add a Group where you will use your ID field. this will partition the data by ID as you want.

i hope this helps,

jaime

[Former Member]

This was the solution!

Thank you very much!

Nikolay

[Former Member]

Hi,

As per my understanding, you would like to get matching records of flat file from the database.

if my upstanding is correct, You provide the link with the flat file to the existing report and specify the join depend on your requirement.

To provide the link, you need to create a second connection for the existing report and Goto "Data base" menu --> select "database expert" --> Select 'link' tab and you can provide the link there.

other please elaborate your requirement with sample data...

Regards,

Naga.