Joined: 09 May 2014
Online Status: Offline
Posts: 209
Topic: Incude Groups where data is null Posted: 01 Oct 2014 at 6:33am
Hello all,
I am currently trying to create a report that shows two types of data ('Type A' and 'Type B') and then have some dynamic text that says "There were no records of Type A in the reporting period" or "There were no records of Type B in the reporting period" in the respective 'grouping' section.
The issue arises because there aren't always records in Type A or Type B. Is there a way to ensure that Crystal Reports creates a group for them both regardless of whether there is data available or not?
I do not currently have the ability to create views on the Database.
Joined: 09 May 2014
Online Status: Offline
Posts: 209
Posted: 01 Oct 2014 at 9:44pm
Hi DBlank - it's a MySQL Database with about 7 tables so using a command won't be an easy thing to do.
Hi Z9962 - I did try having one manual section in the page header (type a) and one manual section in the page footer (type b) in case there are months that there is no data at all (which is possible) but they are spaced too far apart...
Joined: 09 May 2014
Online Status: Offline
Posts: 209
Posted: 01 Oct 2014 at 9:57pm
I did try and it didn't work but I will try again :-).
I've also had another thought of adding in additional detail sections with the custom manual information and adding conditional suppression's - fingers crossed!
Joined: 09 May 2014
Online Status: Offline
Posts: 209
Posted: 01 Oct 2014 at 10:59pm
Ok I got the below formula working BUT only when there is two groups (which obviously there isn't if the data doesn't exist) which puts me right back to square one..... Any suggestions??
Joined: 09 May 2014
Online Status: Offline
Posts: 209
Posted: 01 Oct 2014 at 11:35pm
Update.....
I've got it working using the original suggestion (Report Headers and Report Footers) - I putting them in the Page Header and Page Footer which is why it wasn't working as I expected :-)
The challenge now comes for my next report which has more than two 'types' ......
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