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 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?
Can we add any database field once we have chosen ?Close? button?
How to present data from Crystal Reports on to form?
What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?
How many Sub Reports added in One MainReport?
4 Answers Amadeus, Aviva, CTS, Patni, Welkin,
Where is the image located, after youve placed it on the report?
How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)
Is there a way to export the report formulas, like totals to excel?
hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing parameter also... please help....
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)?
where is the "save data with report" option?
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
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)