Crystal Reports: Report Per Account?

[MiloCold]

Greetings,

Our company is starting to use Crystal Reports in conjunction with SQL. Basically, I have a table with three accounts (x,y,z) and each account is related to bunch of records specific to that account.

I'm trying to create a summary report for each account (like endofthemonth.rpt) in CR, without creating three individual reports (i.e. x.rpt, y.rpt, z.rpt), that will produce/export 3 separate report files for each account in the sql table.

Is this possible in CR10? Thanks in advance

M.Cold

 

[MiloCold]

To elaborate on this a bit...

In the SQL Table I have the following accounts:

-> JRSCH1
-> GRSCH1
-> TMSCH1

Each Account has related records:

-> JRSCH1
o-> Record 1
-> GRSCH1
o-> Record 1
o-> Record 2
-> TMSCH1
o-> Record 1
o-> Record 2
o-> Record 3

I'm trying to set up a ONE report that will create individual .pdf files for each Account. Thus, running this one report in CR would produce JRSCH1.pdf, GRSCH1.pdf, and TMSCH1.pdf.

Thanks,

M. Cold

 

[TPM]

Grouping by the accounts and the drilling down would work.

 

[MiloCold]

Cool, let me go try that. Thanks!

 

[albertkhor]

do you done you project?
can you tell me how to do that?

 

[albertkhor]

Grouping by the accounts and the drilling down would work.

Can you explain more detail?