Format multiple fields in sql reporting services

I have a report that has to output multiple fields and then I need to format a summary at the end.  I am using a table control and that works well for the body of the data (I am using just 1 field in the body and letting the field expand as needed for the data).  The problem is I need multiple fields for the footer.  I have included what it should look like in the code portion (since this is hard to visualize)
Header Information
Line 1 data that can expand and go on and on for     $300
many lines.

Line 2 data that can also go on and on for many      $100
lines

This is the footer
Premium   Member   Spouse   Child   Family
Monthly   27.50     30.25   28.80  35.00
Weekly     7.50      9.25    8.20  10.50

Open in new window

fredstovAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tim HumphriesDirectorCommented:
Hi,

One approach would be to define a separate table, reference the same data set but group the data differently to match the aggregates you require, rather than trying to shoehorn this into a report footer. You then have full control of the format of the summary area.

Tim

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ValentinoVBI ConsultantCommented:
Another approach would be to put a table inside the footer cell of your current table.  This would be called "nested tables", in case you'd like to look up more info regarding that.
fredstovAuthor Commented:
Both solutions are viable and I will try both.  Thank you both
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.