Hope you guys can help me.

 

I'm trying to create a crystal report in which i need to create 3 subreports.  When running it, the document number comes up 3 times and generates the data separately.  I would like it to have 1 document number and all 3 subreports to generate the data simultaneously.

 

is it possible in crystal?

Let me know

Thank you.

Vithi

 

If this is what you mean, then, no the report will not retrieve the data all at once, (reiterating) it will gather the data for the main report and as it comes across each subreport it will apply the links and gather the data for the subreport...and so on.

 

Since I pass into the report an XML dataset, multiple hits aren't a concern as they no longer hit the database, as the XML file has all the data, but I haven't had call of late to use subreports.  It took a bit a work to get everything set, but afterwards it is cut and paste to call the report and the hits to the database are ALWAYS 1.

 

Hope this helps

 

How are you passing the document number from Main report to Subreports Also how are you linking the document number to subreports.

 

Go to Subreports Right Click Select Change Subreport Links in Field(s) to link to select the documentnumber from main report a prameter will be created on left had side Subreport Parameter Field to be used.

 

Go to Record Selection formula of 3 subreport individually

 and check for

 

{Table.DocumentNumber}={?Pm-Table.DocumentNumber}

 

Cheers

Rahul