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