Print each row of database on crystal report. !!

[jeshra279]

Dear All, I have a SQL database with 3 columns A, B, C. Under these 3 columns, there are 100 entries. I want each row to be printed on each page of crystal report, so that i get a separate page for each row entries of the database. Can someone suggest me how to implement this? Regards R.S.

[Paramu1973]

You can check with crystal reports, from report field explorer, there is a field called Group Fields, there if you give your field as a group field, then your reports will be seperated by the same manner.:thumbsup: For Details, suppose your report like S.No..Name...............Category 1.....Mr.Dave Kresoik....MVP 2.....You................Learner 3.....Me.................Learner Now I added a Group By Field as Category, then PAGE-1 S.No..Name...............Category 1.....Mr.Dave Kresoik....MVP And PAGE-2 S.No..Name...............Category 1.....You................Learner 2.....Me.................Learner