tags:

views:

34

answers:

1
Q: 

Can we suppress the Main report records, If the Subreport returns No Data in Crystal report?

I am Using Remedy AR ODBC DataSource, where We can not use Joins, as AR ODBC does not support join, So I am Using SubReport in Detail section(Used Proper Link) when I am running the Report:

i.e., Main Report has 3000 Records and Maching Records in SubReport has 1000 records when I am running the Report, It shows all 3000Records and Blank Subreport where Data Does Not match(against 2000 Records),

Is there a way I can get only 1000 Records (Matching Records) in Report. (Need to implement innerjoin)

Any help would be appreciated.

Thanks !

+1  A: 

You can use a shared variable to count the number of records processed in the subreports. On the main report, if that variable is zero you can conditionally suppress that details section from displaying. It certainly won't speed things up, but it will prevent those records from displaying.

Ryan  2010-09-03 18:03:48

related questions

Pagination Problem [PHP]
Algorithm to determine the "usual" cash payment amounts for a given price
Best way to learn First Order Logic
ASP.NET logic / connection pooling and error handing
Boolean Expression
Boolean logic rule evaluator
Why C++ cannot be parsed with a LR(1) parser?
How do I convert a number to two's complement in verilog?
Correct order for control structure logic (true/false, false/true)?
What problems are best solved with Logic Programming?
Struts Logic Problem
Struts logic tag problem
Looking for simple rules-engine library in .NET
Select Poorly Used Start and End Dates From Facility Table
State and time transending logic and program flow?
Awk scripting help - Logic Issue
Why does "abcd".StartsWith("") return true?
Should LOGIC-techniques be blended into Mainstream Programming?
How to logically organize recurring tasks?
What would be the best algorithm to find an ID that is not used from a table that has the capacity to hold a million rows.
Testing ladder logic
Efficient synthesis of a 4-to-1 function in Verilog
Teaching someone to program
Most succinct way to determine if a variable equals a value from a 'list' of values
C# logic order and compiler behavior