Link to home
Create AccountLog in
Avatar of Venkat15
Venkat15

asked on

Subreport link to show in the Group section of the main report

Since Crystal reports 2008 does not allow creating tabs like excel or Webi, I've created subreports that would show as links in main report. But now I am trying to move the subreports that are placed in the detail section of the main report to the Grouping section of the main report.
I am not able to create groups just with the subreports links.
Is it possible to create groups based on the subreport links...
Please clarify
Avatar of Mike McCracken
Mike McCracken

I don't know what you mean by groups based on the subreport links

You can create groups from any database field or any formula that evaluates in the BeforeReadingRecords or WhileReadingRecords pass.

Subreports are evaluated in the last pass through the report after the grouping is done so if you are trying to group on a value returned from the subreport it won't work.

If you are linking the subreport to the main report on one or more fields, you should be able to create groups on the fields that make up the linking.

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Venkat15

ASKER

Yes, you are right?? the 5 subreports in main report should be displayed either in tabs or as groups but not one below the other in the main report. So each subreport should act as a database field in mainreport and I should be able to group them, that way when I run the report,eventhough it may now show as tabs but it can show in the Groups section and the users will be able to select the reports from there.

I am not sure of the 3rd party tools. Please let me know if I can trick the crystal report to see each subreport as database field, so the reports can be seen the groups section in the preview. The report portal we are using is Infoview.
Now I understand.  Easy solution is to create a simple MS Access or Excel table with 5 records. Use that as the data source for your report, Group so each record becomes a group, and conditionally show only one of the 5 subreports in each group.
Can this be achieved in formula
Thanks for understanding....
I see this as a solution, but Please explain....Not sure how to acheive this.

As I said the report portal is infoview..

Thanks a lot
and infoview is pointing to SQL Server 2008
Then create the simple 5-row table in SQL Server.

Or create all 5 subreports as On-Demand subreports and let the user click on the subreport labels to launch them.