SubReports without Parameters?

[JenB]

I am trying to embed a subreport, which is based on exactly the same tables as my main report. The problem is that I don't want any parameters to appear to my users, I want the report to do that for me. I have looked in the online help at Crystal & all I can find is something that says I have to reference the parameter field in the main report. I have tried to put it in the record select, but it doesn't recognise the parameter field name (or the subreport name).

I was just wondering if anyone could help me with this little (but infuriating) dilemma?

Ta!

Jen

 

[synapsevampire]

I'm a bit lost as to what you intend.

"The problem is that I don't want any parameters to appear to my users, I want the report to do that for me."

Implies no parameters involved, yet:

"something that says I have to reference the parameter field in the main report. I have tried to put it in the record select"

Implies that you are using parameters.

OK, I inferred...

If you want a subreport linked to a main report, you must define the link(s).

Right click the subreport and select change subreport links, and define it.

If you don't want parameters, don't use any in either the main or subreport.

If you want a main report parameter used as a link in the subreport, the above is how you would do that.

If I haven't adequately resolved this, please describe if you ARE using parameters, and how the subreports are to be linked.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

there are parameters involved with the subreport but that doesn't necessarily mean they are USER entered.

When a subreport links to a field in the main report....that main report field connects to a automatically generated parameter in the subreport.

The simple act of linking the subreport creates this...but unless this is a main report parameter...the user will not have to enter anything to generate the subreport...the data will be fed from the data collected in the main report.

Hope this makes sence. Jim Broadbent

 

[JenB]

Thanks for your responses, I think I succeeded in confusing everyone (including myself), so I'll try again in more detail......

I am creating an invoice highlighting additions to contracts. The front page of the invoice (my main report) details total figures (stored in the invoice table). My subreport contains a product list added to the contract against the main report (which is in the invoice lines table).
Both reports reference exactly the same tables, with exactly the same joins etc specified & the same record selections......

We run an invoice run which will obviously produce many invoices, what I want to appear is the main report & then a corresponding page detailing all the additions to contract.

I can run them both seperately & get all the info, but I have tried to embed the subreport into the main report with no success. When you go to the links bit, it seems to create a parameter against the invoice number (the field I am linking on) in the record select on the subreport.
When I run the 2 combined, I only get the main report & no subreport, yet I know the information is there.

Hope this helps explain things a little clearer.....

Ta!

Jen

 

[Ngolem]

your problem is a lot different then what you first described. There can be many reasons why data is missing from a subreport....perhaps the record select in the subreport is bringing back null data because you have not forulated it properly....when it processes this bad data the subreport then crashes and returns a null.

show us the Record select formula for the Main report and the corresponding one for the Subreport...post the actual formulas and we shall try to diagnoze from there Jim Broadbent