Hi Frank,

Does the Stored Procedure return rows from both the Receipt and ReceiptDetail tables? It appears you are trying to return and Entity or Entity list from the Receipt business object. How can a Entity object have a row from one table and multiple rows from another? Can you post your Stored Procedure here? Is the data un-normalized for the report then? Can you pass a parent record to the report as well as a child table?

If you can use a dataset in the report with two tables that may be a good choice. Then your business object can retrieve the parent receipt row as a dataset and add to the dataset the table for the child rows that are related.
Tim

>Hi Tim,
>
>that's what I did to verify there were no nulls in the data.
>
>What should I look for in my Business Object that could be causing it?
>
>Here's where I think I am doing something wrong:
>
>I have a Receipt BO and a Receipt Detail BO. When I save the entire receipt I want to print the receipt so I call a method on the receipt BO which brings back the fields from the Receipt Detail and Receipt tables, which I then pass to my Reporting code.
>
>>Hi Frank,
>>
>>I would suggest if you havn't already done this is go into SQL Server Management studio and right click that stored procedure and choose execute stored procedure. Paste in the parameter value for a receipt that has two detail lines and verify that stored procedure runs OK and if so inspect the data. This way you can confirm if there is a problem with the data returned or if there is a problem in your business objects that would be causing it.
>>Tim
>>