Solved

Selecting conditional subreports in the main report

Posted on 2006-11-02
4
1,096 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 101

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

695 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