CODEWITHSUNDEEP
crystal-reports
sujith s
sujith s

Reputation: 41

Display same row but different column value on a single page

My report currently looks like: 

id name semester loanAmt
2  Ajay  1       2500
2  Ajay  2       3000
3  raj   1       1000

Instead, I want these records to appear on page 1:

id name semester loanAmt
2  Ajay  1       2500
         2       3000

...and these on page 2:

id name semester loanAmt
3  raj   1       1000

How can I achieve this?

Upvotes: 4

Views: 210

Answers (1)

4444
4444

Reputation: 3680

So just to be clear, you want each set of values for a particular "Name" or "ID" to get their own page?

If you want that to happen every time, Group your data by "Name" or "ID" (whichever you prefer) and in the Section Expert if it isn't already. Then select the Paging tab and check "New Page After". You may also want to check "Keep Together" for completeness.

Additionally, you can format your ID and Name fields to suppress if "ID" = PREVIOUS("ID") and "Name" = PREVIOUS("Name") respectively. This will suppress duplicate names as seen here:

id name semester loanAmt
2  Ajay  1       2500
         2       3000

Upvotes: 1

Related Questions