Solved

Selecting conditional subreports in the main report

Posted on 2006-11-02
4
1,095 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 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