By using this website, you agree to our Terms of Use (click here)
Hi Everyone
The true is i want my first page is same as second page ( in the details section). the different is in the value, if in the page 1 i got 10 number and in the page 2 is only 1 number so in the page 2 must had 10 number but the 9 number is null value and 1 number is got a value. This is my reports
for now i add new section in the Details section for the 9 number but the size and location is kind a mess because if i got 5 number in the first page and the second page had 2 number, the result is in the second page will got 11 number so that's not working then.
i want exactly same as first page, that will be awesome if the first page is same as second page but the formula must flexible not static.
Page 1
Page 2
Thanks
Hi Iskandar,
Can you clarify if you're struggling with the page number or is it something else in the report?
The point is page control. I wanna make a page control but I really struggle in the growing things, I mean I counting a words and make a standard for every growing in the Desc Field. Something like that.
My goals is I wanna every page is similar ( on the document details ).
You have 11 detail rows listed in your screenshots above. Do you want 6 lines to appear on the first page and 5 lines to appear on the second page? Something like that?
that's depends on the limit of the first page. i mean i got 11 details rows and the limit in the first page is 10 rows so in the second page only appear 1 rows right.
i counting the rows in the first page and make a variable ( RowsInFirstPage) so does the second page, And i make a formula RowsInFirstPage-RowsInSecondPage and the result is for the blank rows in the second page.
So the first page have 10 rows and the second page had 1 rows + the result from formula ( the blank rows ).
the problem is how can I make it work? So i try counting a word from Desc Field ( because this is the reason the rows is growing ) and make a standard for the limit in every page. that's work for now but i just worry someday my formula is doesn't work at all.
i'll give u example of my report.
Sorry Iskandar, I'm still not understanding what you are trying to achieve.
Can you highlight where in your screenshots there is something incorrect and also point out what the correct value should be?
this's a screenshots before i make the formulas.
And this's screenshots after i make the formulas.
before i make the formulas the report is pretty mess up, so i'll try to fix it and that's the results. I mean i'm still struggle in Counting a Word from Descr Field so i'll figure it out.
So i make a standard for every page :
- the limit from document details is 28 line. etc : rows 1 had Descr Field ( Total 5 line ), row 2 had Descr Field ( Total 3 line ) and sumRows ( every rows from descr Field ) the limit is 28 line. if sumRows had more than 28 line, the page break is active and make second page.
- if in the second page have 5 rows so the rest of the page got 5 rows to.
I'm sorry, my English is bad so this's the best i got.
Thanks Tim.
It's ok, I guarantee you that my Indonesian is much worse than your English.
1. Is there anything wrong with your first screenshots before you make the formulas?
2. When you make the formulas (which you highlighted in red), is the problem with the formula results or with the number of lines that are displayed?