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



I have a crystal report with a linked subreport as well. is there any way not to print the current..

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

I have a crystal report with a linked subreport as well. is there any way not to print the current..

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

I have a crystal report with a linked subreport as well. is there any way not to print the current..

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

Post New Answer

More Crystal Reports Interview Questions

hi...to all i want to generate the two crystal reports one is employee and another is project. now i want to display the two reorts in a single crystal report viewer. i've tried using sub-reports but the page header is not avaliable in a sub reports.. so i want to display two separate crystalreports in a single viewer.. can anybody help me.. plz

1 Answers  


Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?

2 Answers  


One more interview question If I have the data where some columns have multiple values in a given row of data returned from the database. The stored procedure returns data as it is that is blanks values and non blank values. However, I need to suppress the blank values not by showing 0 values but by shifting the cells up. Is there a way using a formula to shift the blank cell one row up based on a selection critieria? In the example below, I want to get rid of the blank values under Exposure column without replacing with 0. example: Company Margin Exposure AB 500 3 10 7 8 ABC 200 4 2 5 10 Thanks Anita

5 Answers   Barclays,


where is the "save data with report" option?

2 Answers  


What are Crystal Reports and Crystal Reports Explorer?

1 Answers  






How many types of reports can be generated in crystal reports?

7 Answers   Finite Infotech, Precision Techconet, VMware, winfoware,


How many sub-reports can report can have?

4 Answers   IBM,


I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?

5 Answers  


how to create crystal reports in .net

2 Answers   CTS,


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?

0 Answers  


Does Crystal Report support all the functions that we have in Oracle?

2 Answers   MPS Techologies, Target,


What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions)?

0 Answers  


Categories