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