Crystal Report – Sub-Reports

[krazykasper]

This is a tough one! Really need expert help.

I have two Crystal reports, each one accessing a different set of tables. Each report is grouped by CustomerId. I can link the two sets of tables using the CustomerId field.

Using sub-reports, I can have one report print following the first report by placing it in the Report Footer section of the Main report. However, I need to have the data in the sub-report fall within the groupings of the main report.

Can this be done in Crystal Reports?

I have tried placing the sub-report in a group section (of its’ own) but that only repeats the entire report for each group in the main report.

I have also tried using a second detail line and including the fields from what would have been the sub-report but that causes numerous repetitions of data in the report.

Any and all help is appreciated.

Krazy Kasper

 

[Kempes]

You need to link the sub report to the main report, otherwise it will show everything.

The best thing to do is run through the Sub report wizard which gives you on option to link by a common field in both reports.

The sub report will need placing somewhere in the details section.

Hope this helps.

Kempes

 

[krazykasper]

Thanks!

Thanks Kemp. You got me 90% there.

The only problem I am running into now is when a specific ShipToId doesn't exist in the main report but it exists in the sub-report data, it doesn't appear in the sub-report. I suspect this has something to do with the table joins. I tried using a full outer join on the two tables but it is "grayed out". Is it possible that Crystal reports X doesn't support Full Outer Joins? Do I need to upgrade to XI?

As a separate test I also tried doing a full outer join on two tables in an Access database; same problem.

OK, I did some more research and found that not all join types are supported for all database types. I'm guessing this is the cause of my most recent problem (i.e., needing a Full Outer Join). According to Business Objects web site, there may be a workaround (something about "...activating ANSI 92 support for joins in the universe...", but that is way beyond my skill set.

Thanks,

Krazy

 

[yogesh1984]

using subreports

Hi
How to integerate sub report in report.?

 

[krazykasper]

Not sure what you're trying to tell me. The links are not very friendly or (in my case) helpful.

Krazy

 

[yogesh1984]

Cryatal Reports

Hi
How to pass parameters dynamically in crytal reports?