TABLIX AT THE BOTTOM OF THE REPORT RDLC

Question

TABLIX AT THE BOTTOM OF THE REPORT RDLC

emilio.perezs

SSC Veteran

Points: 256
More actions
October 16, 2011 at 7:20 am

#258874

Hi,
I would like to know how to show a tablix (a table with a variable number of rows) at the end of report. For example, i have a invoice and i want to show a tablix at the end of the report. I thinks its strange that i am not finding a solution. I can only add a tablix at the body of the report but this is not what i want. Somebody knows if there is a way?
Thanks so much!!

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

CoreI5_xxx SSC Enthusiast Points: 148 More actions · Answer 1

You cannot add tablix in report footer. As work around you can add a tablix in the bottom part of the report body, hide it if not the last page. You can get the last page by matching the built-in fields pagenumber and totalpages.

Hope this helps,

Regards,

Allan

emilio.perezs SSC Veteran Points: 256 More actions · Answer 2

Thanks to reply me.

I can add a table at the body of the report, but how can i set it at the bottom? I mean, i add the table but i can drag the table where i want but there is not bottom property of the body.

And i cant use the global variables of number of pages at the body. I can only use it at the header or at the page footer. Some ideas?

Regards!

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

You want a table at the bottom, what do you want above the table?

emilio.perezs SSC Veteran Points: 256 More actions · Answer 4

The scenarios is this:

body:

table1 (sometimes there are 5 records, sometimes 100 records, etc...)

after this table 1, I add a second table and i want to locate this table at the bottom of the page or at the bottom of the body. Why? Usualli the invoices have a total tables with some records and we have the custom to show this table at the footer of the page.

My problem is that i can add table1 and table2 but table2 show the data after the table1 and i want to show this table more down (at the bottom of the page).

Thanks a lot.

CoreI5_xxx SSC Enthusiast Points: 148 More actions · Answer 5

Is your dataset source from table or SP? If you can add rownumber in your dataset source you can just add a filter in your detail group. select the rownumber and put <= 10 in value. This will display the first 10 records in your dataset then on the second tablix add same filter and put > 10 in value.

emilio.perezs SSC Veteran Points: 256 More actions · Answer 6

Maybe i can change the xml code:

<Body>

...

If I just can set tablix3 at the bottom of the page it would be perfect! Some ideas?

syedathariqbal Hall of Fame Points: 3175 More actions · Answer 7

Have you tried adding a rectangle in the body of the report. Just a blank rectangle to use the space and below which the tablix be added so that it appears at the bottom of the page.

emilio.perezs SSC Veteran Points: 256 More actions · Answer 8

It seems a good idea but it doesn't work or I'm not doing a good work.

The thing is that I have one table at the beginning of the body and one table at the bottom of the body.

I can add a rectangle between two tables but if the first table has 10 records, then the report add the space between the last record of the first table until the first record of the last table. The report use the space between the first table and the last table so if i there are 5 cm between both tables, that's the same distance when i print it.

I think the problem is that the report doesn't know where is the finish of the body and maybe that's why i cant use global variables (to know the number of pages) at the body.

If somebody knows the way...

This is my scenario:

http://www.sorlidiscau.es/img_comun/tablardlc.jpg

thanks.

Emilio.

syedathariqbal Hall of Fame Points: 3175 More actions · Answer 9

I can't think why this can be achieved. There must surely be a way out.

I would have believed that just by placing the tablix at bottom would have solved the issue, however as tablix above it expands with number of rows, it eats up the whitespace probably.

Still I would say, try adding a tablix just above the bottom tablix. Add some random measures and rows in rowgroups and set its visibility to FALSE thereby this tablix would remain there creating some space gap as you need and still won't be visible in the report.

Can you give it a try ?

syedathariqbal Hall of Fame Points: 3175 More actions · Answer 10

Issue is solved now? If yes, kindly let us know the correct solution for the same. Thanks.

emilio.perezs SSC Veteran Points: 256 More actions · Answer 11

The problem is not that the tablix eats up the whitespace. If there are 5 cm between the first tablix and the second tablix, the result is the same. I mean, after print the first table, there are 5 cm and then the report print the second tablix.

How to move the second table at the end of the page?

I didnt understand your last message.