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)
 Switch or IIF
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bukworm
Starting Member

United Arab Emirates
10 Posts

Posted - 06/21/2011 :  00:15:26  Show Profile  Reply with Quote
Hi,

I have about 35 diffrent numerical codes for a Shipment Status. I want to display in the report according to the status number...

like 0 - New, 10 - Arrived,....

I used Switch, I think there is a limitation on the no. of statements inside it, If any1 know how many is the limit and any ther way around, so i can use it to loop throuh all 35 statuses. I cannot put this into a table.

Thanks,

raghuveer125
Constraint Violating Yak Guru

India
283 Posts

Posted - 06/21/2011 :  05:36:09  Show Profile  Reply with Quote
May be this link help you

http://www.bigresource.com/Tracker/Track-ms_sql-aK0hxwVb/

In Love... With Me!
Go to Top of Page

bukworm
Starting Member

United Arab Emirates
10 Posts

Posted - 06/21/2011 :  08:53:47  Show Profile  Reply with Quote
I think i was not clear, the status number comes from DB, I want to put a layman understandable words instead of that number. so i put tat in as expression and used switch inside it. In crystal this is possible. I dont know the way in SSRS.

thanks
Go to Top of Page

bukworm
Starting Member

United Arab Emirates
10 Posts

Posted - 06/29/2011 :  01:02:40  Show Profile  Reply with Quote
I got it, I made a function vb code in the report and call it in the expression by code.{function name}

thanks
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.06 seconds. Powered By: Snitz Forums 2000