Member Avatar for ukfreak

Hi,

I got a crystal report with:-

main report
subreport(Item_A)
subreport(Item_B)

There is a limit for the subreport to show only 5 record, if there is more then 5 records it should go to a new page. I have been trying to do this for 1 week, i tried so many codes and tried changing the new page but the the records dont seem to go to the new page. I got 10 records, when i print it's only printing the first 5 records, the balance 5 it doesnt show... and it doesnt show any new page. The SQL is locked to TOP 5 records? Any idea?

  • 3 Contributors
  • 6 Replies
  • 253 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by ukfreak
Member Avatar for ukfreak

Hi anyone? i still couldnt solve this.. please help... i need it today..

Member Avatar for mono_jit23

in your sub reports did you put the field in other than details section.....
i feel it should have in Details section..

Member Avatar for ukfreak

sorry i dont get u?

Member Avatar for mono_jit23

in your crystal report (ie .rpt file) you have multiple sections like header, details, footer section.. if you put your field value in other than details section it doesn't expand according to increment of data. when you have multi row data you must put it in details section.

Member Avatar for aspproject

there are no limitation in crystal report, you may check number of your records in database

Member Avatar for ukfreak

The subreport are placed in the details section...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.