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.

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.

How to Add ASPNET account to your database

This is the error message "Login failed for user 'SUSHMA\ASPNET'. "

I am Building a Data Form that displays data from a single table- the Customers table in the Northwind sample Database.

I have Visual Studio.Net 1.0 and SQL Server 2000.

So I feel that I need to add an ASPNET account to my database.

Please could someone tell me if this could solve the problem, if so

please could you tell me how to Add an ASPNET account to my database?

Thank you

This thread has instructions on how to grant database access to a user account.
http://forums.asp.net/875897/ShowPost.aspx
|||

Hi,

Use Enterprise Manager (in SQL Server) to look at the users and groups for the database in question. If you don't see ASPNET there, you can add it, if it is there, it may be that it doesn't have sufficient permissions to do what you are asking it to do. The other thing to check applies if you are using IIS 6 (Win2k3 Server). In this case, ASP.NET uses NETWORK SERVICE, rather than ASPNET as the default worker process.

Hope it helps.