Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to add a total in a column on a table ??? Expand / Collapse
Author
Message
Posted Wednesday, July 31, 2013 10:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 10:23 AM
Points: 63, Visits: 258
+-------------+-----------+-------------+--------+
|Supplier | Agent | Amount | Total |
+------------ +------- -- +--------------+-------+
| | A10051 | 237.2 | |
|S2005068 +-----------+------------- + |
| |A10052 | 23.8 | |
+-------------+------- ----+-------------+--------|


Hi experts

How are U??

I need to display Total rows of "Supplier" in the right columns

I tried the "add total" but SSRS create me the column near the right or the left of the "Supplier column"

Do U have any idea ??

Thank U
Post #1479582
Posted Thursday, August 01, 2013 2:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 10:23 AM
Points: 63, Visits: 258
Nothing ???
Post #1479832
Posted Thursday, August 01, 2013 9:34 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:21 PM
Points: 35,951, Visits: 30,235
I can't help in SSRS but, as a sort of "bump" for you, what kind of total are you looking for?

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1480239
Posted Friday, August 02, 2013 1:23 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 28, 2014 8:15 AM
Points: 41, Visits: 71
Can you clarify your question a little more. Are you looking for a running total, the total for the row, or the column total. You did say supplier total, are you wanting to count number of supplier or the amount? If I can picture your example correctly, I see four columns but cannot picture what right or left supplier column are you talking about? Do you simply want to insert a new column? Please provide specifics, and I am sure lot of us here can provide assistance.

Thank you !!


§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§

always Happy, always Prasanna
Post #1480584
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse