GROUP SUMMARY TOTAL MISSING

[BHAT100]

Hi Everyone,

crystal report 9.0
server: SQL

I don't know I was thinking it would have been easy but i am not able figure this out

In the group summary total, where ever there is no data for month column it is not displaying group total '0' and YTD data under YTD Column.

Thanks for help

-b

 

[Cretin]

Do you have the field supressed if Zero. You do that by going into format field then clicking the customize button at least thats how its done on 8.5. Also check to see if you supress blank section in the format section area.

Cretin

 

[BHAT100]

Thanks for your reply;

I have checked I didn't suppress any field and suppressed blank section.

I am pulling month and ytd figure by formula and summing them up.

Month formula:
if {SOP30200.GLPOSTDT} >= {?Sale - Biggining Date } and {SOP30200.GLPOSTDT} <= {?Sale -Ending Date}
and {SOP30200.SOPTYPE} = 3
then {SOP30300.XTNDPRCE}
else 0.00

YTD Formula:

if {SOP30200.GLPOSTDT} >= CDateTime(2004,11,01,00,00,00) and {SOP30200.GLPOSTDT} <= {?Sale -Ending Date}
and {SOP30200.SOPTYPE} = 3
then {SOP30300.XTNDPRCE}
else 0.00

 

[dgillz]

BHAT,

Please re-read the question asked by cretin. He never asked you if you suppressed a field. He asked if you had "supress if zero" turned on.

Do you at least see the subtotal field from the design window? If so right click it and select format object. Go to the number tab, hit the customize button and make sure that "suppress if zero" is not checked.

If you do not see the object in the design tab, then reinsert the summary operation.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[BHAT100]

Thanks for your reply, I have checked it 'suppress if zero' is not checked

-bhat

 

[dgillz]

OK, do you see white space where the group subtotal should be?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[BHAT100]

Thanks for your reply.
No, it is not showing blank white space for the group where group subtotal should be
what is happening if month balance is zero it is not even printing text field(i.e. customer total)

once again thanks for your help

-bhat

 

[dgillz]

Month Balance is zero? Is this because the records add up to zero, or there are no records for that month?

Crystal does not report on non-existent data.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[BHAT100]

There is no transaction (item sales) for month but there is balance for ytd column.but the issue is whereever there is no transaction for month it is not printing YTD value for that group, not even text field.

My report is as below:

GR1 - Location
GR2 - Salesperson
GR3 - Customer
GR4 - Item

Detail - sales by item detail pulled by formula for month and YTD

Month formula

if {SOP30200.GLPOSTDT} >= {?Sale - Biggining Date } and {SOP30200.GLPOSTDT} <= {?Sale -Ending Date}
and {SOP30200.SOPTYPE} = 3
then {SOP30300.XTNDPRCE}
else if {SOP30200.GLPOSTDT} >= {?Sale - Biggining Date } and {SOP30200.GLPOSTDT} <= {?Sale -Ending Date}
and {SOP30200.SOPTYPE} = 4
then {SOP30300.XTNDPRCE}*-1
else if {@Sales_ytd} > 0 then 0
else 0.00


YTD formula:

if {SOP30200.GLPOSTDT} >= CDateTime(2004,11,01,00,00,00) and {SOP30200.GLPOSTDT} <= {?Sale -Ending Date}
and {SOP30200.SOPTYPE} = 3
then {SOP30300.XTNDPRCE}
else if {SOP30200.GLPOSTDT} >= CDateTime(2004,11,01,00,00,00) and {SOP30200.GLPOSTDT} <= {?Sale -Ending Date}
and {SOP30200.SOPTYPE} = 4
then {SOP30300.XTNDPRCE}*-1
else 0.00

I have parameters;'

(?Location)
{?Sale - Biggining Date }
and {?Sale -Ending Date}

Any idea on above will be great help?

Thanks Again

-bhat

 

[dgillz]

Please answer my question from my last post.

Is the group in question a zero because the records add up to zero, or because there is no data for that group.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[BHAT100]

there is no data for that group for month column but there is data for ytd column

Thanks

-bhat