Only One Record Displayed

[fox12]

I created a view which retrieved 121 records. However, when I created a Crystal Report by using the following sql command:
SELECT * FROM BillingStatements
It only returns me one record. What may be wrong?
Thanks.

 

[lupins46]

I would say that you might have either set up Record Selection rules in CR or you have not used the correct View from your database.

 

[fox12]

I modified my view and fixed the problem now. However, the original problem is weird that I could retrieve all data from OEM console, but not from Crystal Reports.

Thanks.