BPSAdmin
asked on
Crystal report printing multiple records instead of one.
We are using Crystal Reports 8.5 and SQL Server 2000 and we have a report that pulls data from Sql server and loads the report. The problem is it will only pull one record and display. I need the report to pull all records matching search criteria in the SQL Query. How do I get CR to pull up all records and display one record per page?
I am very new to crystal reports so please be specific.
Thanks
100 points
I am very new to crystal reports so please be specific.
Thanks
100 points
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't suppose the SQL Report is using a cursor to pull the information is it. I had a problem with this, and had to approach the report in a different way. If so you may need to change the SQL Report.
can you please verify if you had got the field in header section , if u had put that field in header section it would show only one recored try putting the required field in detail section.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
What selection formula are you using?
mlmcc