Displaying Report Header (when no data)
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16823
Printed Date: 16 Apr 2025 at 7:13pm
Topic: Displaying Report Header (when no data)
Posted By: sontin
Subject: Displaying Report Header (when no data)
Date Posted: 21 Jun 2012 at 7:59am
Hi,
I am fairly new to Crystal, and am using CR 2008 version. I have a report which needs to be modified. My report is designed in following way:
1. Report details - fetches & displays data from db (say x) based on dates from db (say y)
2. Report header - fetches & displays header which includes dates from db y
My problem is: for a query which returns no data from db x (based on the dates from db y), my header report gets suppressed automatically. I have valid dates from db y, however the header do not display them since the detail section is blank. (maybe this is because of the inner-join on db x & y).
My header say "Report for the range: (from) & (to)". So even when there is no data to be displayed, I still want the header to show the date range. Any suggestions on how I can handle this situation?
Thanks and cheers!
|
Replies:
Posted By: hilfy
Date Posted: 22 Jun 2012 at 3:55am
|
I would make sure you're linking from y to x and make the join a Left Outer Join (right click on the join and select Link Options.) This will get you data from y even if there is no corresponding data in x. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: sontin
Date Posted: 22 Jun 2012 at 9:21am
Technically I do not have a direct join. Both my tables are not linked with each other. I have added table y, without any links.
So I retrieve dates from table y and use them to fetch data from table x.
|
Posted By: hilfy
Date Posted: 22 Jun 2012 at 9:34am
What is the Selection formula for your report?-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|