Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summary group totals not showing up

Status
Not open for further replies.

BHAT100

Programmer
Dec 5, 2002
115
CA
Crytal report -8.0
server: SQL server 2000

I have a report which have month data column and YTD data column.

My Question: when there is no sales for month but despite having YTD sales.Customer grp total does not displayed for that customer even if that customer does have YTD sales data


and it has following layout


Thanks

-bhat

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;'

{?Sale - Biggining Date }
and {?Sale -Ending Date}


Any idea on the above would be great help



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top