Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Reporting Services » Reporting Services » SSRS 2008R2 EXPRESSION
Add to briefcase

SSRS 2008R2 EXPRESSION Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
skgudi2009
Posted Sunday, February 10, 2013 12:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112
I want to add this expression in SSRS 2008R2 For Column Heading

If {Reportname.value} = 'ABC' And {Reportname.value} = 'S' Then
'Amount1'
Else If {Reportname.value} = 'BAC' Then
'Amount2'
ELSE If {Reportname.value} <> 'ABC' AND {Reportname.value} <> 'BAC' Then
'amount3'
Else
'amount3'

i have added like this

=Switch(Fields!Field.Value = "ABC" And Fields!Field.Value = "S" , "Amount1",
Fields!Field.Value = "BAC" ,
"Amount2",
Fields!Field.Value <> "ABC" AND Fields!Field.Value <> "BAC",
"Amount3","amount3")
But error is comming for column heading #error
please help to adds this for column heading
Post #1418084
mister.magoo
Posted Sunday, February 10, 2013 3:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 1,289, Visits: 3,859
skgudi2009 (2/10/2013)
I want to add this expression in SSRS 2008R2 For Column Heading

If {Reportname.value} = 'ABC' And {Reportname.value} = 'S' Then
'Amount1'
Else If {Reportname.value} = 'BAC' Then
'Amount2'
ELSE If {Reportname.value} <> 'ABC' AND {Reportname.value} <> 'BAC' Then
'amount3'
Else
'amount3'

i have added like this

=Switch(Fields!Field.Value = "ABC" And Fields!Field.Value = "S" , "Amount1",
Fields!Field.Value = "BAC" ,
"Amount2",
Fields!Field.Value <> "ABC" AND Fields!Field.Value <> "BAC",
"Amount3","amount3")
But error is comming for column heading #error
please help to adds this for column heading


Well, your Pseudo code doesn't make any logical sense, so why don't you try explaining what you want in natural language?

If {Reportname.value} = 'ABC' And {Reportname.value} = 'S' Then

Reportname.value cannot equal both ABC and S , can it?

MM
Post #1418091
skgudi2009
Posted Sunday, February 10, 2013 10:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112
Actually i want like this

If {Reportname.CategoryCode} = 'DEPOSIT' And {reportname.WithdrawalType} = 'S' Then
'Deposit Amount'
Else If {BReportname.CategoryCode} = 'LOAN' Then
'Loan Amount'
ELSE If {Reportname.CategoryCode} <> 'LOAN' AND {Reportname.CategoryCode} <> 'DEPOSIT' Then
'Closing Balance'
Else
'Closing Balance'

Categorycode and withdrawaltype are fieldnames which is in my table
categorycodes are (LOANS,DEPOSIT,SHARES,SUSPENCE)
Withdrawaltype are (Multiple (M),Single(S)
"Deposit Amount"
"Loan Amount"
"Closing Balance" are Column Headings which i want so i added like this

=Switch(Fields!CategoryCode.Value = "DEPOSIT" And Fields!WithdrawalType.Value = "S" , "Deposit Amount",
Fields!CategoryCode.Value = "LOAN" ,
"Loan Amount",
Fields!CategoryCode.Value <> "LOAN" AND Fields!CategoryCode.Value <> "DEP",
"Closing Balance","Closing Balance")
Post #1418118
mister.magoo
Posted Sunday, February 10, 2013 11:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 1,289, Visits: 3,859
Is this a matrix report? what groups do you have for rows and columns?

MM
Post #1418124
skgudi2009
Posted Sunday, February 10, 2013 8:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112
It is a Tabular Report No groups for Rows and columns for this Report just i want to display the column heading with that expression instead of typing Depositamount/Loanamount/closingbalance In crystal Report it is working fine with if and else condition
Post #1418192
dohnfors
Posted Monday, February 11, 2013 12:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:18 AM
Points: 16, Visits: 59
Try this (from http://blog.hoegaerden.be/2009/09/14/adding-an-else-to-your-switch/):

=Switch(
Fields!CategoryCode.Value = "DEPOSIT" And Fields!WithdrawalType.Value = "S" , "Deposit Amount",
Fields!CategoryCode.Value = "LOAN", "Loan Amount",
Fields!CategoryCode.Value <> "LOAN" AND Fields!CategoryCode.Value <> "DEP", "Closing Balance",
True, "Closing Balance"
)

Your third expression (Fields!CategoryCode.Value <> "LOAN" AND Fields!CategoryCode.Value <> "DEP") seems to be superfluous because the same thing is returned by the "else" expression. The statement can be rewritten to:

=Switch(
Fields!CategoryCode.Value = "DEPOSIT" And Fields!WithdrawalType.Value = "S" , "Deposit Amount",
Fields!CategoryCode.Value = "LOAN", "Loan Amount",
True, "Closing Balance"
)
Post #1418230
skgudi2009
Posted Monday, February 11, 2013 5:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112
Thank u very much it is working
Post #1418333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.