asked on

total text column in ssrs

I Have a table that has text fields and I want to Total only those records that don't contain the "2009-02" format in them. Is it possible in SSRS?

I tried this but it doesn't work.

=IIF(Fields!Month4.Value <"2009",Fields!Month4.Value,Sum(cint(Fields!Month4.Value))
=IIF(Fields!Month4.Value <"2009",Fields!Month4.Value,Sum(cast(Fields!Month4.Value as int))

Howard Cantrell

where is this field coming from? "2009-02" Is this a string field?
do you want a total at the bottom?
Please explain again.

epicazo

ASKER

field is called MONTH1,MONTH2,MONTH3, etc... and these are NVARCHAR fields

Howard Cantrell

do you want a total at the bottom of each column?

epicazo

ASKER

I want to summarize each column except for the row that contains 2009-02, 2009.03, etc..

Howard Cantrell

your example does not show me what you are wanting to do. You have 2011 in the example and no real way of showing the layout of want you are doing. If you are trying to not read a 2009-2 then the best way would be in your query and then just have the report print out the results.

epicazo

ASKER

I hope I am able to explain myself on this...

I am in reporting services and the columns I am trying to get a SUM on MONTH1--MONTH24 and as depicted in the image above my data output is in text because I am running a crosstab SP to get the results for a 24 month period to include the HEADER (The header is the row of data that contains YYYY-MM) it is written then way becuse every month the header will be different.

I want a summary on everything, except those that contain YYYY-MM

I tried this syntax but it doesn't work for me:
=IIF(Fields!Month4.Value ="2009-03",Fields!Month4.Value,Sum(cint(Fields!Month4.Value))

Thanks...

ASKER CERTIFIED SOLUTION

epicazo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

epicazo

ASKER

Questions could be deleted.