SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 add in parameter selected		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

peace
Constraint Violating Yak Guru

283 Posts
Posted - 02/04/2013 :  08:58:24  Show Profile  Reply with Quote
=Fields!GrossFare.Value

How to add in the expression base on the parameter selected in report?

Example:

Parameter selected for CURRENCY: USD

GrossFare
GrossFare_USD

If parameter selected for CURRENCY: AUS

GrossFare
GrossFare_AUS

James K
Flowing Fount of Yak Knowledge

1730 Posts
Posted - 02/04/2013 :  09:06:17  Show Profile  Reply with Quote
Did you mean you want to append the currency code? 
=CStr(Fields!GrossFare.Value) & "_" & Parameters!Currency.Value
Go to Top of Page

peace
Constraint Violating Yak Guru

283 Posts
Posted - 02/04/2013 :  10:09:45  Show Profile  Reply with Quote
Yup but i get #error.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48032 Posts
Posted - 02/04/2013 :  12:25:30  Show Profile  Reply with Quote
sounds like this to me as I guess you're trying to set a dynamic column header

="GrossFare_" & CSTR(Parameters!Currency.Value)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

peace
Constraint Violating Yak Guru

283 Posts
Posted - 02/04/2013 :  21:11:04  Show Profile  Reply with Quote
But this will return GrossFare_USD

My grossFare is something like this 200.99_USD

Is it possible?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48032 Posts
Posted - 02/04/2013 :  23:07:47  Show Profile  Reply with Quote
quote:
Originally posted by peace

But this will return GrossFare_USD

My grossFare is something like this 200.99_USD

Is it possible?


then it should be what James suggested

=CStr(Fields!GrossFare.Value) & "_" & Cstr(Parameters!Currency.Value)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000