Print Page | Close Window

Display Report Header even no rows in Detail Secti

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18089
Printed Date: 02 May 2025 at 12:28pm


Topic: Display Report Header even no rows in Detail Secti
Posted By: Bhanu Prakash T
Subject: Display Report Header even no rows in Detail Secti
Date Posted: 28 Nov 2012 at 12:16am
How to display values in Report Header even when there are no rows in Detail Section.

I have two different tables and they are not linked to each other. First table has few columns defined and used to display rows in Detail section and second table has only one column and one row and used to display the details of the Search Criteria in Report Header section. But when there are no rows returned from the database for the search parameters selected by the user, "Search Criteria" is also not displayed. I have verified that there are no rows being returned in the first table for the details section, but there is always a row returned in the second table for the Report Header section.


Can you help how to display the Search Criteria when there are no records to display in the details section ?


Replies:
Posted By: hilfy
Date Posted: 28 Nov 2012 at 4:00am

What is your selection criteria (formula from the Select Expert)?  I would do something like the following:

 
(
<existing select formula>
)
or IsNull({FirstTable.SomeKeyField})
 
Note where I put the parentheses - this is important or else it won't work correctly.  Basically when you use a key field that always has data in the first table, by looking for it to be null, you should get the data from the second table even when nothing matches the regular selection criteria for the 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

Posted By: Bhanu Prakash T
Date Posted: 28 Nov 2012 at 4:13am
The user selected search parameters are passed to a stored procedure and then the stored procedure returns two tables, first table data is directly attached to "Details" section and second table data (one column and one row) is also directly attached to SearchCriteria field in Report Header section. No other selection formula exist. Can you please explain now ?

Posted By: hilfy
Date Posted: 28 Nov 2012 at 6:04am
I didn't realize that you were using a stored procedure - things work a little differently there.  I would update the stored procedure so that it will return a table with a single blank row when there is no data.  I suspect that the fact that the table it returns is empty (or possibly null) is what is causing your issue.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window