sql server reporting services: Calculated column in a table -- sql server reporting services

You're in the

sql server reporting services

group:

Calculated column in a table

Re: Calculated column in a table

Bruce L-C [MVP]
6/3/2005 10:19:09 AM

sql server reporting services: The best way to do this is to created a calculated field. On the field list,
do a right mouse click, add, click on calculated field. After that it is
treated like any other field.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Calculated column in a table

Eric
6/3/2005 4:46:58 PM

Hi,

I have a table with a calculated column.
There is also a footer which calculates the sum in a column.
How I can calculate the sum from a caculated column?

Ex: 2 10
5 25 <- calculated column
---------------
7 35 <- calculated sum of column

(SRS 2000 SP2)

Thanks
Eric

Re: Calculated column in a table

Eric
6/8/2005 9:48:12 AM

Thanks for answering.

But now there's another problem.

I can't use an aggreate function in the column. The column calculates the
percentage of the first column to the Total.

Any idea jow I can do that in the report?

Thanks
Eric

"Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> schrieb im Newsbeitrag
news:eyqGY%23EaFHA.3712@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

Re: Calculated column in a table

v-mingqc NO[at]SPAM online.microsoft.com
6/9/2005 6:47:47 AM

Hi Eric,

What aggreate function? You may refer sample report Company Sales.rdl for
more information about how to sum the columns.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Calculated column in a table

Eric
6/10/2005 11:13:31 AM

Thanks for answering.

this is an too easy sample.

I have a column with values (DataBound). A second column should show the
percentage of first column to the sum.

Example:
20 20%
80 80%
---- ----
100 100%

For calcualating the Second column I need to know the sum of the first
column.

How I do that?
If the second column is a 'calculated field', I can't use aggreate function
like 'Sum(column1)'.

thanks
Eric

"Michael Cheng [MSFT]" <v-mingqc@online.microsoft.com> schrieb im
Newsbeitrag news:MDOIi7LbFHA.2476@TK2MSFTNGXA01.phx.gbl...
[quoted text, click to view]

Re: Calculated column in a table

v-mingqc NO[at]SPAM online.microsoft.com
6/14/2005 1:39:31 AM

Hi Eric,

Thanks for your patience.

For now, aggregates of aggregates are not currently supported in Reporting
Services so you will find other way to accomplish this. For example, you
could generate this data in the DataSet.\

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn