Enter the following transact-sql as sql expression field

[skiabox]

I want to enter this code as an expression field.
Is this possible?

SELECT SUM(QTY) FROM LABSTORE WHERE ITEM_CODE = 873

 

[Madawc]

I don't think so, records are selected individually and then you can total them. The use of Crystal totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Yes, but the punctuation depends upon your datasource/connectivity:

(
SELECT SUM(`QTY`)
FROM LABSTORE
WHERE LABSTORE.`ITEM_CODE` = 873
)

This would give you a sum for all records that meet your criterion. If you want it per group, the result would be different.

-LB

 

[skiabox]

it doesn't work.I have made it work once but I don't remember the exact way.sql expression fields in crystal are very syntax sensitive and they easily create an error.

 

[lbass]

You need to take a look at database->show SQL query and try to incorporate the same punctuation in your SQL expression. Please show exactly how you tried to implement my solution, and also show your SQL query.

-LB

 

[skiabox]

I've managed to do it.I used double quotes and full database names for the tables.