Hello, I wonder if it's possible

[crisedefoie]

Hello,

I wonder if it's possible to pass the selection formula of a main report to its subreports.

By exemple I want to print a list of invoices which have a subreport showing products costs and quantities summaries.

The users of this report may choose custumers, products, dates or whatever they want as criterias, so the selection formula may vary at every printing.

My subreport have to show the summary of the products shown in the main report only.

Actually, the main report shows only selected records but the subreport shows all the records summary.

I have to solve this problem for both Crystal Report 8.5 and 9(.NET)

I hope I have been clear!

Thank you!

 

[Madawc]

You can pass the parameter values from the main report to the subreport, using Subreport Links under Edit. Does that fix it?

Madawc Williams
East Anglia, Great Britain

 

[crisedefoie]

Thank for answering.

I forgot to say that I send the selection formula by VB code
like :
myreport.selectionformula = .... SQL query ....

So when I want to link my subreport to my main report I can't link directly selection formulas (If I could, I don't know how).

CriseDeFoie

 

[Madawc]

Better re-post, making it clear that it's a VB question (not an area I know)

Madawc Williams
East Anglia, Great Britain

 

[IdoMillet]

Use VB to set parameter values in the main report.
Then, follow the advice above.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com