Friday, March 9, 2012

How to add formatting lines and outlines in SRSS tables

I have a table set up in an SRSS report to display my data with subtotals. The data displays perfectly. What I can't seem to make happen, though, is simple display features (under lines above a subtotal, outlines of a group of boxes). If I try to use the line tool it tells me that it can't be placed in this part of the table, but from experiment I gather it can't be placed in ANY part of the table. Also, when I select a three column two row area (in my design) and attempt to apply a border style (hoping to put a border around the cells), the border applies internally as well.

Can SRSS provide this kind of formatting inside of a table?

Jim

Just curious -- is it at all possible to add lines and other formatting items within a table in a SRSS report?

Have you tried setting the border properties for those cells?

>L<

|||

Yes, unfortunately, the border properties hit each and every cell border. I would like to outline three cells (much as I could in Excel) -- but instead, each individual cell is outlined, which is overkill.

Also, I tried using the "overline" property subtotal cells -- hoping to get a subtotal line between the subtotal and the data it is totals, and find that overline doesn't do anything. Underline, strikethrough -- both work -- not overline.

|||

>> hit each and every cell border

Horizontally (if you want to put in a horizontal line, or group a set of boxes horizontally) you should be able to set the individual border elements (top, left, bottom, right) to handle this perfectly. Just don't define the "inner" lefts and rights the same way as the other border elements.

And FWIW that's exactly how Excel does what you are talking about <s>.

If you want to outline a group of cells vertically, you can do this with column borders, it's a little more difficult.

Now that I think about it, perhaps there are some border column formats that are getting in the way of your doing what you want. You might want to check that...

Otherwise... maybe I'm misunderstanding your question?

>L<

|||

yes -- thank you. For some reason I missed the existence of the expansion check to get to the directions.

Sorry for the bother.

No comments:

Post a Comment