Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Displaying a message for empty data Post Reply Post New Topic
Author Message
cyber-guys
Groupie
Groupie


Joined: 02 May 2008
Online Status: Offline
Posts: 42
Quote cyber-guys Replybullet Topic: Displaying a message for empty data
    Posted: 17 Jul 2014 at 10:22am
I'm creating a report of monthly customer activity and I want to display a message such as "inactive" for each customer that had no activity that month. The main report simply lists customer names and I'm using a subreport that lists that customers activity. Customers that have no activity are left blank. I tried creating a formula using isnull testing the report fields with no luck.

Any help is greatly appreciated.

Thanks in advance,
Cyber-guys
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Jul 2014 at 11:39am

two options i can think of.

1. using a shared variable passed fromo the sub report to the main report and keying off that. It will be a little tricky due to needing to have it under the sub report section
2. I think the easier process is to, in the sub report return the a string where ISNULL(activityfield) then 'inactive' else ''
and conditionally display that in the subreport header and conditinolly suppress all of the rest of the subreport in reverse
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.