Solved

Selecting conditional subreports in the main report

Posted on 2006-11-02
4
1,092 Views
Last Modified: 2008-01-16

I am using Crystal reports 10 and crystal enterprise 10 .
Can anyone help me out in suggesting "How to select the conditional subreports in the main report ?".
I want to import subreports by using IF-THEN-ELSE condition in the main report.

Any help is appreciated.
Thanks in advance.

regards,
0
Comment
Question by:ashishanand
4 Comments
 
LVL 6

Accepted Solution

by:
Ken Turner earned 120 total points
ID: 17857450
Have you thought of putting each subreport in a section on its own, and then conditionally suppressing these sections?
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 17858240
There are only two-types of subreport:

1)  Linked - the subreports are linked to data in your main report and always run regardless of whether they are conditionally suppressed or not (* see workaround below)
2)  On Demand - the subreports don't run until an end-user clicks on them

*  A linked subreport is basically treated like a correlated subquery.  A subreport is a query in it's own right, but you pass in filters from the primary report to the subreport so that the data in the subreport is related to the data in the main report.  If you are using a SQL-based database (Oracle, SQL Server, etc...) then you might be able to use SQL Expression fields to stop reports from running in the first place (the only way I know of that allows you to prevent unwanted subreports from ever running Vs. running all subreports and just suppressing them[very inefficient]).

What type of if-then-else criteria do you actually want to use?

~Kurt
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17859075
I don't believe Crystal can do what you want except by adding the reports at design time then as suggested above suppressing the ones you don't want.

It probably is possible through a custom application but not through Crystal coding.

mlmcc
0
 

Author Comment

by:ashishanand
ID: 17863841
Thanks for your help !!

As I understand that we cannot  conditionally include subreports into main report, i would probabely use section as an alternate to subreports to meet our requirement.


Regards,
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question