sql server reporting services: How do I resolve this? Urgent please reply asap ! -- sql server reporting services

How do I resolve this? Urgent please reply asap !

SDRoy
3/10/2006 1:12:26 PM

sql server reporting services:

Hello:
Can someone please tell me how to convert this Crystal report formula to an
expression in SQL reporting ?

@VoidAmt =
if {payment.status} = 'VOID' THEN {paycheck.checkamt} * -1 ELSE 0

In crystal report field I have Sum(@VoidAmt).

How do I convert this as an expression in SQL reporting ? The line item
which contains this field is grouped on a certain field.

--
Thanks,

RE: How do I resolve this? Urgent please reply asap !

Aiwa
3/10/2006 1:36:28 PM

Hi,

Maybe you should be doing this manipulation in your Select statement.

SELECT status
,checkamt
,CASE WHEN status = 'Void' THEN (-1 * checkamt) ELSE 0 END AS
VoidAmt
FROM payment

HTH,
Eric

[quoted text, click to view]

RE: How do I resolve this? Urgent please reply asap !

SDRoy
3/10/2006 4:06:26 PM

Hi Eric:

Thank you very much for your help. All calculations are correct now. Only
that I wanted to output -ve sign for loss amounts but I am seeing those
amounts showing up as (amount) instead of -amount.

Thanks again for your great help !
--
Thanks,
SDRoy

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.