April 21, 2014 at 4:27 am
In my report i am using one tablix and one text box. Text box always bottom of the last page, like signature. Here i am not using footer concept. Now i want to display signature at bottom of the last page. incase my table contain 5 records it should display first page bottom, in case of data going on multiple pages report should display last page of the report. How can i solve this?
April 21, 2014 at 6:13 am
Add the text box you want, but make its visibility dependent on the page number being the last page number.
April 21, 2014 at 6:22 am
But How can i do that logic.. can you send the custom code.
in this code in case of table having only 5 rows then where the text box is displayed, is it bottom of the page or below the tablix?
April 21, 2014 at 7:48 am
Hidden =IIf(Globals!PageNumber = Globals!TotalPages, False, True)
April 21, 2014 at 8:01 am
but that logic works only report having footer(can you see my post once). but text box located in report body. then how can i do?
April 21, 2014 at 8:29 am
Two options:
1. Use a footer with conditional visibiltiy
2. Just put the textbox after your tablix. It should print at the end of the report.
Gerald Britton, Pluralsight courses
April 22, 2014 at 12:27 am
1.But i am not using footer. because it is sub report.
2. In case text but kept after tablix, once tablix having 5 records then that text box appear 6th line of the report but not bottom of the report
April 22, 2014 at 2:27 am
I don't understand the issue with not being able to use a footer. It should not matter that your data is in a sub-report. If the signature data you need is not dependant on the sub-report you should be able to add a footer to the main report and use the conditional visibility like the others have mentioned.
Joie Andrew
"Since 1982"
April 22, 2014 at 2:33 am
i have a main report contains 4 sub report. what i am asking question related to 3rd sub report. then how can i count the page number in main report. i don't known how many pages data is displayed in main report. then how can i calculate page number for particular sub report and how can i solve signature ?
April 22, 2014 at 10:40 am
Why not put a footer in your 3rd subreport and toggle the visibility as described above? Alternatively, set the body size of the 3rd subreport to a specific size and put the signature textbox at the bottom.
April 22, 2014 at 11:58 pm
1. when i putting footer in 3rd sub report it wont display footer in my main page because my main page contains footer
2. In case of 3rd report size is fixed to specific size and kept the signature at bottom of the page having some problem like the space b/w table and signature always taking that much of space when table data increase.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply