I have a crystal report with a linked subreport as well. is
there any way not to print the current record on the main
report if no records are returned from the subreport?
thanks you
email - stanlte@yahoo.com
Answers were Sorted based on User's Feedback
Answer / sukhveer rai
yes, we can achieve that using shared variables as
mentioned already. however, should also make sure that the
subreport values should come to the primary report before
the section you have records on..
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sajal kumar
Rather using Shared Variable to Suppress subreport, we can use
"Suppress Blank Subreport" Option from Subreport Format Editor.
Perform following step
1. Right-Click on Subreport and Select the Format Subreport Option.
2. On the Subreport Tab, Mark the "Suppress Blank Subreport Option" checkbox.
3. now on the main report, click on the section expert of the section where Subreport is placed and mark 'Suppress Blank Section Option"
Here you done with you requirement..
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / jo mathew
YOU HAVE TO USE SHARED VARIABE AND PASS THAT VARIABLE TO
YOUR PRIMARY REPORT, THERE YOU HAVE TO USE THE CONDITION.
| Is This Answer Correct ? | 3 Yes | 1 No |
How do we format field?
Suppose I have a crystal report with a linked subreport as well. Is there any way not to print the current record on the main report if no records are returned from the subreport?
Can we use our own SQL for creating a report?
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?
Can we call or add subreport within subreport?
Explain the various components in crystal reports?
How to Filter the Crystal reports?
12 Answers CCIL, Mammut Building Systems,
what is the "refresh" button suppose to do on the crystal report viewer?
Where can we find the log file generated when we run a crystal report?
Is there a size limit to creating a Crystal Report? If I run a statement report for all customers it will crash if there are too many customers. I can print all the statements if I select them in batches, but if trying to print all at once Crystal will crash after a few minutes.
Why do we use crystal reports when we have reporting tools in bo itself?
How to open subreport in new ie window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)