Hi PSB

Imho you should add format expression, please check in this way:

=Switch(Fields!Code.Value="GBP", Format(Fields!YourDecimalValues.Value, "'£'#,0.00;('£';('£'#,0.00))"),

Fields!Code.Value="USD", Format(Fields!YourDecimalValues.Value, "'$'#,0.00;('$'#,0.00)"),

Fields!Code.Value="AUD", Format(Fields!YourDecimalValues.Value, "'$'#,0.00;('$'#,0.00)"),

Fields!Code.Value="CAD", Format(Fields!YourDecimalValues.Value, "'$'#,0.00;('$'#,0.00)"),

Fields!Code.Value="EURO", Format(Fields!YourDecimalValues.Value, "'€'#,0.00;('€'#,0.00)"),

Fields!Code.Value="NOK", Format(Fields!YourDecimalValues.Value, "'kr'#,0.00;('kr'#,0.00)"),

Fields!Code.Value="RUB", Format(Fields!YourDecimalValues.Value, "'py6'#,0.00;('py6'#,0.00)"),

Fields!Code.Value="COP", Format(Fields!YourDecimalValues.Value, "'COL$'#,0.00;('COL$'#,0.00)")

)

Thanks

Mike

Ps. Or...

Hi

It's generaly limited by available memory. However, there are a few things you can do to ease up on performance.

Please convert it from varchar to char before, remove unused...

Hi Karmi

Could you show as CREATE TABLE statement for both source & dest. tables.

I'm afraid you are unable to insert data due to nonnulable column deifinition (inc_status) in DWH.DBO.incident.

The...

Hi Keith

One of my packages also process some tasks on a list of tables, it works fine.

I have declared 3 variables:

TblList as object

TblId as Int16

TblName as string

Query statement select row_number()...

Hi Mario

Incorrect margin in the exported Excel is well known issue in Reporting Services 2008, as I remember

it has been fixed in SSRS 2k8 SP2 but I didn't upgrade so...

Hi Onlo

I try delete garbage from Temoprary Internet Files and Temp folders maually or run disk cleaner,

despite the launch built-in IE cleaner, it leaves a lot of temp files untouched.

Br.

Mike

Please add Data Conversion Task between Source and Destination.

Br.

Mike

Hi Tim

I know that my previous advice was very trivial but the simplest solution is the best when you have a deadline to do sth.

Please take a look for that...

Hi Onlo

Please delete all files from Temoprary Internet Files and Temp folders on her local profile.

Regards

Mike

Hi,

Please try to change data type to Unicode string [DT_WSTR]

in source connection.

Br.

Mike

Hi

Try this:

=DateAdd(DateInterval.Hour,7,DateAdd(DateInterval.Day,-1,today()))

Br.

Mike

Hi Tim

Imho you could convert it to char directly in SP.

Br.

Mike

I'm afraid I'm not genius, I simply meet that problem in the past and I lost some

time to resolve it. Problem is related with Runtime.InteropServices.

Br.

Mike

Hi

Please create C:\Windows\SysWOW64\config\systemprofile\Desktop and

try axecute execute again.

Br.

Mike

Hi,

I prefer local processing mode for apps to avoid that problem.

Did you try to change

this.ReportViewer1.ServerReport.Timeout = 600000;

Br.

Mike