I am still trying to grasp the idea, but from what I understand, the data is being pulled from different tables in the same database.

I am using Business Objects...

SELECT

dbo.SAP_SoldToPartner.HC_CustomerAccountNumber,

dbo.SAP_SoldToPartner.HC_Name1,

dbo.Invoice_date_month.year_key,

sum(dbo.SAP_InvoiceLine_M.stick_quantity)

FROM

dbo.SAP_InvoiceLine_M,

dbo.SAP_ShipToPartner,

dbo.SAP_SoldToPartner,

dbo.Invoice_date_month

WHERE

( dbo.SAP_SoldToPartner.SoldTo_wid=dbo.SAP_ShipToPartner.SoldTo_wid )

AND ( dbo.SAP_InvoiceLine_M.ShipTo_wid=dbo.SAP_ShipToPartner.ShipTo_wid )

AND ( dbo.SAP_InvoiceLine_M.Month_Key=dbo.Invoice_date_month.month_key )

AND (

( dbo.Invoice_date_month.year_key = datepart(YYYY,getdate())-1 )

)

GROUP BY

dbo.SAP_SoldToPartner.HC_CustomerAccountNumber,

dbo.SAP_SoldToPartner.HC_Name1,

dbo.Invoice_date_month.year_key

I do have blank stick_quantiy. There is also 0 stick_quantity in the database. However...

Supriya,

Thanks for your help. The code worked and the report ran without any errors. However, it didn't accomplish baht I wanted it to. I have a report with 12 columns,...

I get the following error when I tried what you suggested.

stick_quantity is data type decimal in the database.

Exception: DBD, [Microsoft OLE DB Provider for SQL Server] : Error...