Print Page | Close Window

display empty columns in crosstab

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=9848
Printed Date: 20 Apr 2025 at 1:36pm


Topic: display empty columns in crosstab
Posted By: swetha
Subject: display empty columns in crosstab
Date Posted: 28 Apr 2010 at 7:56pm
Hi,
I have created a crystal report which is having 3 groups group1,group2,group3 in group3 i have placed crosstab which displays the details according to startdate and enddate for that i have written a formula in report->section formula->record as {Record.Record Date} in {?StartDate} to {?EndDate}.
Everything is fine except if for some group there is no data in the range of startdate and enddate then it is not showing those dates. I want all the crosstab's to have all the columns from startdate to enddate and if data is not there then 0 should be displayed.
 
 


-------------
swetha


Replies:
Posted By: Annette
Date Posted: 29 Jul 2011 at 2:07am
Hi,

Did you ever get this sorted as I'm having the exact same issue.

Thanks,

Annette

Posted By: CircleD
Date Posted: 29 Jul 2011 at 1:10pm
I'm admittedly not real good with formulas but this should work.

If isNull({Record.Record Date}," ") = 0 then "0"
end If

Posted By: Annette
Date Posted: 01 Aug 2011 at 1:44am
Thanks, I think I got it through a similar formula but I will keep this in case it doesn't work. Thanks very much for your reply

Posted By: Annette
Date Posted: 11 Aug 2011 at 1:53am
Hi,

I did get my formula to work but now the crosstab is printing a blank row for items that are not covered in my formula, would you know how to suppress this. I've tried suppressing empty rows but this isn't working.

Thanks in advance
Annette


Print Page | Close Window