I have figured out how to evaluate and set the background color with IIF(Fields!dailyStatus.Value="3", "IndianRed","Lime").
This is great for a single value, but I need to use a type of If Then Else.

I have tried iif else but get error for "...no parameter for false part..."

Arnie Stewart

Here is a way

On the report properties, click on the code tab and
type in the following code:

Public function getColor(theValue as string)
     if theValue = "3" then
    return "blue"
      else
    if theValue = "4" then
      return "red"
        else
       return "yellow"
      end if
      end if
end function

Then, set the background color with =code.getColor(Fields!dailyStatus.Value)

Hi all
I am trying to execute the Oracle package and Sql query within same dataset in SSRS 2005.
Oracle Package sets Environment variables for the sql query to exucute the query

Oracle package and Sql query as below

call eec_sys.eec_pck_logins.login('SDB','ASC','PP')

select id, m_pck_std_custom.id_desc(id, 1) from M_id

How can i execute the Oracle Package and sql query at once in same dataset of SSRS

Don't add an irrelevant post to a FOUR YEAR OLD thread.

Start a NEW THREAD. And give it a *GOOD* title.