Need to adapt to this:

(substring(Value,charindex('.',Value)+1,LEN(Value)))

in order o get what's before the 'dot'.

Thnaks

Exactly!

Thanks buddy!

Doesn't seem to be a permission error, we already deployed reports before and everything works fine.

No errors, thats why its weird.

I'm recreating the stored procedure, along with the report itself.

I...

U right man!

Thanks

baby steps, baby steps

Show Offfff... 🙂

I get the idea but it gives me:

ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator

U right

->

INSERT INTO #mytable

(ID, Value)

SELECT '4','First' UNION ALL

SELECT '37','Second'UNION ALL

SELECT '44','Second' UNION ALL

SELECT '54','Third' UNION ALL

SELECT '55','NULL'...

Not working buddy

Was able to do

###"."##0 €

Giving me 123.321 €

But when we have for exemple the numb 600 it show: .600 €

Any suggestion?

🙂

\m/ O_o \m/

Thnaks!

SELECT

ID,

CASE WHEN (SUM([VALPAYREAL]) IS NULL) THEN 0 ELSE SUM([VALPAYREAL]) END AS PAYREAL,

CASE WHEN (SUM([VALPAYPLAN]) IS NULL) THEN 0 ELSE SUM([VALPAYPLAN]) END AS PAYPLAN,

(SELECT SUM([VALPAYPLAN])

FROM ABC

WHERE DATE...

There an issue:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as...

Ray M (3/27/2013)

---

Place a rectangle at the bottom of your report template.

on the rectangle properties dialog Select the "Add Page Break Before" checkbox. (Or set the PageBreak Breaklocation Property to...

O_o !? SHOW...

Lowell (3/27/2013)

---

everyplace you have the column represented by @C must be replaced with a convert(nvarchar,@c); so if it's occurring 4 times in your expression, change all four...i think...

Lowell (3/27/2013)

---

convert the column to nvarchar(max) instead.

SELECT SUBSTRING(

CONVERT(NVARCHAR(max),YourColumn),

CHARINDEX('>', @C) + 1,

LEN(@c) - CHARINDEX('>', ...