WOW!

Works great!

Thanks body!

Regards

Thanks

It gives me an error: Argument data type ntext is invalid for argument 1 of len function

Solutions?

Regards

Thanks Body's

Works fine now.

Regards

Thanks!

YES! Its the same, but besides None, Low, I also got Strong and Extreme.

And basically what I want is for each PROJ, to appeaar by this order:

None;Low;Strong and Extreme.

Thanks

Regards

Here it goes

SELECT PROJ, CARAC

FROM X

WHERE CARAC<>''

ORDER BY CASE WHEN CARAC= 'None' THEN CARAC ELSE CARAC END DESC

This is what I got at the moment.

Thanks

Regards!

Yes, I omitted the rest.

I got this:

...

ORDER BY CASE WHEN CARAC= 'None' THEN CARAC ELSE CARAC END DESC

The problem is for each PROJ I get 2 times the same CARAC.

Before...

Thanks

Im using:

SELECT PROJ, CARAC

FROM X

ORDER BY CASE WHEN MSP_LOOKUP_TABLE_VALUES.LT_VALUE_TEXT = 'None' THEN MSP_LOOKUP_TABLE_VALUES.LT_VALUE_TEXT END DESC

But it gives me repetitive results. Like 2 CARAC...

Thanks Body!

Thanks!

I deal with it to here in Portugal.

Regards

Thanks Qui-Gon Jinn!

Anyway, it gives me the same error.

Thanks!

Hi I'm getting a warning error while rendering my report, it says that 'Input string was not in a correct format.'

=SWITCH(

ReportItems!Textbox70.Value="2.2.PA" and IsNothing(Lookup(Fields!ProjectGUID.Value, Fields!ProjectUID.Value, Fields!PBSD.Value, "DataSet3")),1,

ReportItems!Textbox70.Value="2.2.PA" and Lookup(Fields!ProjectGUID.Value, FIelds!ProjectUID.Value, Fields!PBSD.Value,...

Thanks

=DateAdd("d", 15, Today)

Works also

Regards

Thanks!

And If I want to add 15 days to todays date?

Regrdas

This might help.

http://blogs.msdn.com/b/deanka/archive/2009/01/13/diagnosing-and-troubleshooting-subscriptions.aspx%5D%5B/url%5D

Or you monitor with PowerShell:

http://www.youdidwhatwithtsql.com/monitoring-ssrs-subscriptions-powershell/1392