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 convert the below statement into SSRS expression Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 10:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:06 PM
Points: 55, Visits: 109
Hello,
I have an active report code where

this.txtHdFiscalYear.Text=reportDataSet.Tables[1].Rows[0]["FiscalYear"].ToString();

this.lblJulCount.Text= Convert.ToString(Convert.ToInt32(this.txtHdFiscalYear.Text) -3) + " Meal Count";

this.lblSepCount.Text= Convert.ToString(Convert.ToInt32(this.txtHdFiscalYear.Text) -2) + " Meal Count";

I am converting this into SSRS

How can I write the above expression into SSRS ;I am trying to write in header field

=Fields!FiscalYear.Value - 3 + " Meal Count"

How to convert this.
Post #1567599
Posted Monday, May 5, 2014 11:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
Something like this should work:

=CSTR(CINT(Fields!FiscalYear.Value) - 3) + " Meal Count"





Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1567636
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse