i am getting the first table from a flat file using fTP of ssis

second table from webservice using webservice task

finally i need to retrieve certain columns only from both...

i would like to know how to use if or case statement in SSRS dataset.

if the user selects application name alone then

i need select * from table where applname =...

region will also be a parameter

in crystal report we have number format Negatives as -123.

if a number is negative i want to show them as negative in ssrs. how do i achieve it?

Thanks

But ToNumber is not present in SSRS and i get the same error #error

Thanks Arunkumar

i tried it but in case of field2 being null 0 is substitued and when field1 is divided by 0 (field2) it gives # error.

I believe Tonumber in crystal...

i am trying to do in the SSRS field expression. i am not doing a sort with the date.

how do i use configuration in sendmail?

Thanks for the reply

i have page width as 11in and page height as 8.5in in my report.

i dont have extra space anywhere in the report.

I am not clear what...

i tried both ways. storing inside the package as well as config file.

Will the password show up in the config file? i see the userid in the config file but...

Since it is not windows authentication i got to pass the userid and pwd inside the package.

i tried to use save password option also.

When i try to create a...

thanks again

i tried thru calculated field (dataset) and since certain rows contain null value and when i try to do the average on the calculated field AVG(calculated field) i am...

Thanks that worked. i used "" in case of -1 as i have a column called # of days which actually has this express of datediff

i have one more problem,...

it is not a delimted file. it is fixed width flat file.

TYPE PFORM TNAME ...