how to add the values in a column

Display The total value of all the orders put together
try sum, ie select sum(OrderValue) from orders
You may have to group the orders though, here from northwind I get a sum for each customer
select customerId,sum(freight) from orders group by customerid
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"qqqqqqqqqqqqqqqqqqqqqqq" wrote:

> Display The total value of all the orders put together
>
>

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 a image from database to page header

Hi,

I am having same issue, but the data is an image stored in database. actually its an company logo which i need to display on every page.

i have a doubt. if i user source as external and an URL in a image property, then my image will not appear if the Reporting Server and Application Server are on two different machines. if both are in one machine as my local machine(development machine) the image appears.

is this an known issue or how to solve this. due to this reason, we thought of putting images in database and pulling out, but it turned out to be an another problem.

You can follow the approach described in Books Online (scroll to "Adding a Databound Image to a Header or Footer"): http://msdn2.microsoft.com/en-us/library/ms159677.aspx

Note: if you are doing this on Reporting Services 2005, you should definitely first install SP1 (http://www.microsoft.com/sql/sp1.mspx) for both, the report server and the machines with BI Development Studio / Report Designer.

-- Robert

How to add a calcualted field in Matrix?

Hello.. I would like to know how this can be done in RS (SQL2000)...

In the dataset I have... sales, company, and year. What I want to display is such...

2005 2006 Growth

companyA $1,000,000 $500,000 100%

companyB $50,000 $100,000 -50%

How do I add a column in a Matrix to calculate the growth based on the sales? Thanks!

-Joseph

you would have to add growth to your dataset as a calculation in of the years. So for MDX you would add a calculated member to the time dimension and calculate growth in that.