Hi there

I agree with you, I later used the following query:

(ISNULL(sum(case datepart(yy,t.orderdate) when 2008 then 1. else 0. end) * 1.0 /

NULLIF (sum(case datepart(yy,t.orderdate) when 2007 then 1. else 0....

Finally found the answer, one will need to use the following in the as the format code:

##0.##,"%"

Finally found the answer, one will need to use the following in the as the format code:

##0.##,"%"

Any answer to this question?

I may sound a bit rude but is it spanish you are writing with?

Do you know how i can get the % symbol on my report without the figure changing?

When I run it in both SMS and the Query designer in BIDS, i get the right result set, but when i deply it, it appears in a different format.

Hello

Here is the RDL of the report...hope it helps

Hello

How can i send you the report definition, for you to check?

Thanks Guys, but i figured it out with the following query:

'SUM(CASE datepart(yy,t.orderdate) WHEN 2008 THEN t.ordertotal ELSE 0 END) AS '£ Orders in 2008'',

Can you guys show how to create this dashboard?

Hello Jack

the year and week together (multiply year by 100 to make room for the week number and add it on) We include the year so that if the result...

Hello Jack

Got the following error msg:

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value '*-43' to data type int.

sorry guys but my own syntax worked perfect for me, tried yours but got incorrect results....

had a mismatch when trying to create a temp table and the data were not cor-related.....