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 |
Why do we use crystal reports when we have reporting tools in bo itself?
If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?
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
How to conditionally suppress a field based on whether a page number is odd or even?
hi... i've two crystal reports one is in D: drive name employee.rpt with 5 textobject and another report is in E: drive name employee.rpt with 15 textobject... now i want to write a program to overwrite the D drives report with E drives reports i.e i want to replace the 5 textobject with 15 textobject.. overwriting the reports while it is executing .. is there any code for it please help me.. its urgent..
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?
How many types of reports can be generated in crystal reports?
7 Answers Finite Infotech, Precision Techconet, VMware, winfoware,
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
How do we connect to the database?
How do you add a subreport to a report in Crystal Reports?
how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema
Is there a way to export a report definition without writing code?
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)