Sunday, December 20, 2020

How to add blank record after the last detail on the last page(which less than 6 records)?



I have solved the problem.

I am doing something stupid but it's work :)

In the crystal report. I created lot of the report footer from A-S

I create the blank row in each report footer incrementally method.

Eg: Report Footer a - with 1 row

Report Footer b - with 2 rows

"

"

Continuosly till you want how many blank row in the last detail(data).

Lastly each of the report footer add the crystal syntax.

Every report footer set as Suppress No Drill Down & checked mark it. Set the crystal syntax X-2 in Suppress No drill down in every report footer as


In the first blank row

if PageNumber*6-recordnumber=1 then false else true


In the second blank row

if PageNumber*6-recordnumber=2 then false else true

With this kind of repeating method. It successfully create 6 row in each pages included the data.

Eg : Last Page, i have 1 data(row) in the last pages. But, I need set as 60 rows.

Therefore I have to create 14 report footer. each report footer create 1 blank row in first report footer, 2 blank row in second report footer, 3 blank row in the third report footer..till 5 blank row in the last report footer.



https://forums.asp.net/p/1889197/5349771.aspx?Re+How+to+add+blank+record+after+the+last+detail+on+the+last+page+which+less+than+20+records+

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...