Friday, March 9, 2012

Repeat grid header on each page

Hi,

If a grid header has the RepeatOnNewPage property set to True, how can I figure out when the header is continuing on next pages, so I can add the text '... continue' on every page except the first one?

Thank you.

Radu.

You can try using the RowNumber() function to determine if it's the first record (first page) or not.|||

Thank you for your answer...

... but it doesn't work. My report displays more tables, not only one, and each table displays rows grouped by a field XYZ. The RowNumber(Nothing) function gives the current row index in the entire context. It might be helpful to have a variable which is reset to 1 for each table.

I've tried to pass the group name parameter to the RowNumber function (RowNumber("XYZ_group"), where "XYZ_group" is the name of the group by XYZ field), but it gives the total number of records available in one group.

If you have some more ideas, please feel free to suggest them... I'm trying more and I'll post here the answer if I manage to find it.

|||

Hi Alexa,

greetings!

a suggestion.. if you please

why dont you write an IIF on pagenumber globals on the visibility condition of the textbox which displays continue

=IIF(Global!PageNo.value = 1,True,False)

hope i am not missing a point in ur question, correct me if i am.

|||

You're not allowed to use the PageNumber in the report body... you may use it only in the report header and footer.

I would have liked to be able to use it... because I have another issue: I want to leave a blank page after a sub-report if the sub-report finishes at an odd page. Imagine you're printing something on both sides and a new chapter you want to start at a odd page (it's more readable than starting the new chapter from the even page).

It seems the guys from Microsoft couldn't allow PageNumber to be accessed from the Body (definitely they had a good reason, but what is that reason?).

No comments:

Post a Comment