Trouble with view for a Crystal report

[ascheper]

I am trying to make a view for a Crystal report that places a check beside products a customer ordered. When I create the view, I get an entire customer recordset for each product ordered, which creates a separate set of reports for each product. Is there a way to access all the products ordered but only have one recordset per customer?

 

[SQLBill]

I think you will have better luck if you post in the proper forum. Go to 'Forum List', scroll down to 'Reporting Solutions' and find the forums for 'Crystal Decisions'.

-SQLBill

 

[ascheper]

The problem is not with the Crystal report, it is with getting the view to return only one recordset per order, not a recordset for each product.

 

[tlbroadbent]

Post your view, sample data and expected output so we can analyze it. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.