SQL reporting Service Prob

[arnoldpinto84]

Hi, Can any1 pls tell me if it is possible to place a textbox on the body of a report so that it appears on evry page of the report when a page break occurs, i am not supposed to use the page footer part to accomplish this & also there are no groups. i require the textbox to be in the body section itself. Please also let me know how to detect when a pg. break is going to occur in the rdl file(if it is possible) Thanks

[pmarfleet]

You can just place your textbox at the top of the body section of your report. When the report renders, the textbox will be displayed at the top of each page. Why do you need to know when a page break occurs? If you need to explicitly force a page break somewhere in the report, you can do this. Otherwise, page break positions are going to be dependent on local user settings and you won't have any control over where they occur. Regards Paul

[arnoldpinto84]

Hi, actually the requirement is that i am required to display the page total for every page without using the header or the footer section. Placing a textbox at the top of the body of the report doesnt display it on all the pages, futhermore the repeat item with dataregion on each page option doesnt work. i have read that this problem goes away when we publish the reports onto a report server. but we are not going to publish them onto a server they are going to be local reports. i wanted to know how the page break occurs to figure out if there is a way to insert the required value before it happens Thanks.

[pmarfleet]

What does your report do? Does it contain a table object that displays a set of tabular data? In that case, add a footer section to your table object, put your textbox in the table footer and set the footer to repeat on every page via the table properties. Paul

[arnoldpinto84]

i am looking for a general solution, the report may contain a table object or a list to display the data thats not a prob. Adding textbox on the footer to display the sum and making it repeat on every page will not solve the problem, bcos the final total will be displayed on each page and not the individual page total. i'm not really sure if its possible to achieve this without using the page footer....i hope there is a change in the requirement :)