You may to try a derived column task and cast that column to DT_I4.

if this also doesnt work and you need to create function thats do it for you...

thanks a lot Bruce .

definitely this will get me going.

Thanks for the reply.act I as trying some ways myself think this is the easiest .

thats what i am not able to get.how to check the file wheather its loaded or not.

i am not getting the condition.

would be mind giving details abt it

thanks derek,

i will definetly look in that 3rd party software.

but as now we have a urgent requirement and i want to just finish my package generically and after this...

Hi Ray M,

thats exactly what i have in my mind.but i am not able to implement it.

as i mention before as well we have a table where we keep the...

Dan,

i really appreciate your help and suggestion.

Looks like its some innate problem with the way we are refrencing our cubes.

But you have given a good deal of information...

thanks a lot

ashish

i am sorry about that.may be i gave so many different pieces of information togather.

actually those are two different parameters in two different report.

the screen shot i gave.if you can...

Just hit this.

if instead of using label.i use value.it shows the selected value,but in a form of a query like.

here it showed [procedure].[procedure code] &[9242].

whereas i just wanted 9242.

is their...

i just tried this.

=IIF(IsNothing(Parameters!LocationState.Value), "All" ,"State:" & Fields!LocationState.Value)

doesnt give a blank for a change.but gives error.:P

Hey Dan,

Thanks for all the help.

As you have shown ,i have exactly the same setup.

i attached the screenshot for the designer page.

i have some parameteres out of which most are...

Also,

i read somewhere that when we use some parameter as field!locationstate.value and we give the same as label.then it comes blank.

do you have any idea about it.

i am trying to...

I have a parameter called LocationState . from the dimension location.the label for that is State.i gave this value for the textbox in the layout.It came as blank.

=JOIN(Parameters!LocationState.Label,", ")

Thats what i m trying ,but it doesnt seem to work.I can provide more information about the report i have.

I start with two parameters.out of which only one is for...

Hi Dan,

Thanks for the reply.But i did tried that as well.i used Join and did took care of the cases.actually just to check i just tried what all you...