Link to home
Start Free TrialLog in
Avatar of BPSAdmin
BPSAdminFlag for United States of America

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
Avatar of Mike McCracken
Mike McCracken

What is your report format?  WHere did you put the data?

What selection formula are you using?

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of frodoman
frodoman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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