Crystal Reports Cross-tab trouble.. displaying empty rows

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Cross-tab trouble.. displaying empty rows

<< Prev Page of 2

Author	Message
kostya1122 Senior Member Joined: 13 Jun 2011 Online Status: Offline Posts: 475	Posted: 03 Feb 2012 at 4:56am
	yes i had the same problem i solved it by not using a cross tab and creating the whole report manually using text boxes and formulas it was a solution for me only because i didnt have too many fields in my report so i just created a formula for each of them and placed them next to appropriate text box (with column/row name) Edited by kostya1122 - 03 Feb 2012 at 4:56am
	IP Logged


lowester Newbie Joined: 30 Sep 2011 Online Status: Offline Posts: 23	Posted: 03 Feb 2012 at 5:08am
	should be able to use a formula.. could assign a variable... then use isnull function.. if the function is set to true then assign the variable 0.00
	IP Logged

kostya1122 Senior Member Joined: 13 Jun 2011 Online Status: Offline Posts: 475	Posted: 03 Feb 2012 at 5:20am
	if there was a null value there wouldn't be a problem crystal reports cant alter the database therefor you cant assign the variable to something that is not there.
	IP Logged

lowester Newbie Joined: 30 Sep 2011 Online Status: Offline Posts: 23	Posted: 03 Feb 2012 at 5:24am
	*Originally posted by kostya1122* if there was a null value there wouldn't be a problem crystal reports cant alter the database therefor you cant assign the variable to something that is not there. hmm.. i have a few reports i created that had the fields were blank for some records and doing what i suggested allowed me to print 0.00 for those blank records.. maybe im reading something wrong here..
	IP Logged

lowester Newbie Joined: 30 Sep 2011 Online Status: Offline Posts: 23	Posted: 03 Feb 2012 at 5:26am
	*Originally posted by lowester* *Originally posted by kostya1122* if there was a null value there wouldn't be a problem crystal reports cant alter the database therefor you cant assign the variable to something that is not there. hmm.. i have a few reports i created that had the fields were blank for some records and doing what i suggested allowed me to print 0.00 for those blank records.. maybe im reading something wrong here.. nevermind.. i understand now after reading this a few times..
	IP Logged

SheliaKWood Newbie Joined: 02 Feb 2012 Location: United States Online Status: Offline Posts: 4	Posted: 06 Feb 2012 at 9:42pm
	*Originally posted by lowester* *Originally posted by kostya1122* if there was a null value there wouldn't be a problem crystal reports cant alter the database therefor you cant assign the variable to something that is not there. hmm.. i have a few reports i created that had the fields were blank for some records and doing what i suggested allowed me to print 0.00 for those blank records.. maybe im reading something wrong here.. Well if this is the case: 01-Jan 02-Jan 03-Jan A 0.00 1.00 0.00 B 2.00 0.00 3.00 where 0.00 are blank values in your record, it is actually showing since there are other values on different date and description (A, B). Did you tested it on a specific date that has blank values? Edited by SheliaKWood - 06 Feb 2012 at 9:43pm
	IP Logged

SheliaKWood Newbie Joined: 02 Feb 2012 Location: United States Online Status: Offline Posts: 4	Posted: 07 Feb 2012 at 12:23am
	I was able to do a simple solution on the column part (date): 1. Insert a column. 2. Right click on Cross-Tab and select Advanced Calculations > Calculated Member. 3. Select the last Calculated Member. 4. Edit Header Formula with the following code (Crystal Syntax): ToText(DateAdd("d", CurrentColumnIndex, {?StartDate}), "dd MMM yyyy") 5. Edit Insertion Formula with the following code (Crystal Syntax): DateAdd("d", CurrentColumnIndex, {?StartDate}) <> GridLabelAt("Table.Date", CurrentColumnIndex) 6. Make sure that any column Calculated Member is above all other row Calculated Member in the Calculated Member list box. 7. Click OK button. But there are still problems with this solution: 1. It can only display up to the last date that has value. Example: Your date range is 01-Jan to 31-Jan and you only have data up to 15-Jan, only data for 01-Jan to 15-Jan will be displayed. 2. It can only display one missing column. Example: Your date range is 01-Jan to 05-Jan and: a. you don't have data on 03-Jan, the data will be displayed normal: 01-Jan 02-Jan 03-Jan 04-Jan 05-Jan 1.00 2.00 0.00 4.00 5.00 b. you don't have data on 02-Jan and 03-Jan, the data will be displayed as follows: 01-Jan 02-Jan 04-Jan 04-Jan 05-Jan 1.00 0.00 4.00 0.00 5.00 Help, anybody? Edited by SheliaKWood - 07 Feb 2012 at 12:57am
	IP Logged

assafse Newbie Joined: 03 Jun 2012 Online Status: Offline Posts: 8	Posted: 03 Jun 2012 at 4:42am
	Hello, thank you for the detailed response, my problem is that the function GridLabelAt requires grid group name (for example "Table.Date") but when I try to provide the group name it doesn't recognize it, how can I know for sure what's the group name? the group in my grid is year view on document date (2010,2011,2012).. Thanks, Assaf
	IP Logged

<< Prev Page of 2

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