Hi,
I have a problem while using MYSQL case Statement In SSRS 2008 R2.
My scenario is:
I am passing hardcoded values in parameter dropdown (County, State).
And i am using another parameter depending on If i select the "county" in by dropdown, I need get all county values in dropdown or if select state i need to get all state values in my dropdown.
What i am writing in my code
select case when parameter.geolevl.value = "County" then "select distinct county_name from county"
when parameter.geolevl.value = "State" then
"select distinct state from county"
is this code will work in SSRS 2008 R2
Please help me with this Issue
Mysql CASE statementSatya May 21, 2012 at 10:24 AM
Hi, I have a problem while using MYSQL case Statement In SSRS 2008 R2. My scenario is: I am passing hardcoded values in parameter dropdown (County, State). And i am using another parameter depending on If i select the "county" in by dropdown, I need get all county values in dropdown or if select state i need to get all state values in my dropdown. What i am writing in my code select case when parameter.geolevl.value = "County" then "select distinct county_name from county" when parameter.geolevl.value = "State" then "select distinct state from county" is this code will work in SSRS 2008 R2 Please help me with this Issue
Post your Comment