Question Status

Suggested Answer
Nag Kothapalli asked a question on 23 Apr 2012 1:55 AM

Hi all,

It seems that in SSRS (SQL 2008) a data bound Tablix(Table) is not allowed on a report footer.

I have a requirement to print dataset with multiple rows on report footer.

Has anyone come across similar situation or have an idea how to achieve this?

Many thanks

Nag K

 

 

 

 

Reply
Suggested Answer
Kent Carstens responded on 23 Apr 2012 5:44 AM

Hi Nag,

I've had this requirement as well.  The solution I used was to hide the data in the detail of the report and then reference these fields in the footer.

Reply
Nag Kothapalli responded on 23 Apr 2012 5:27 PM

Hi Kent,

Thanks for your reply.

I tried that, and textbox in footer shows just one value.

I need to print many rows from the dataset, instead of First or Last.

Is it possible?

Nag

Reply
Suggested Answer
Volker Deuss responded on 23 Apr 2012 11:52 PM

Hi Nag,

do you know how many rows there are? The footer has a fixed size, so it's very difficult to manage this if you don't know the row count. Although the size should be settable by code...

It's possible to write some VB code to keep the data (e.g. ArrayList) you run through in detail and use it in the footer afterwards.

Good luck! :)

Reply
Nag Kothapalli responded on 24 Apr 2012 12:26 AM

Hi Volker,

Thanks for your reply.

There could be upto 15 rows to display in footer.

Could you give me some pointers regarding the VB code you are referring to and sample if you have one.

Nag

Reply
Volker Deuss responded on 24 Apr 2012 12:44 AM

Hi Nag,

I haven't done this before for footers and it doesn't seem to be easy to find something about it online.

blogs.msdn.com/.../using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx

There Robert Bruckner used an ArrayList for caching (well, it's a list, you can add values and get them out again).

What you'd need to check first is which elements are available for footers and if you are able to use tables / tablixes there (don't think so). You might be forced to simulate a table then with textboxes or something...

That's going to be a tough one, you should ask yourself if it's really necessary. I think it's at least very uncommon to show a table with varying row count in report footers.

Regards.

Reply
Nag Kothapalli responded on 13 Jun 2012 12:22 AM

Hi Volker,

I have added a custom function, however i am not able to access that function from an expression.

Do you know what could be the reason for this?

Thank you

Reply
Suggested Answer
Kent Carstens responded on 23 Apr 2012 5:44 AM

Hi Nag,

I've had this requirement as well.  The solution I used was to hide the data in the detail of the report and then reference these fields in the footer.

Reply
Suggested Answer
Volker Deuss responded on 23 Apr 2012 11:52 PM

Hi Nag,

do you know how many rows there are? The footer has a fixed size, so it's very difficult to manage this if you don't know the row count. Although the size should be settable by code...

It's possible to write some VB code to keep the data (e.g. ArrayList) you run through in detail and use it in the footer afterwards.

Good luck! :)

Reply