Hi all,
i use a sqlexpression in the recordselectionformula. But when i load the report by my Assembly the sqlexpression is not replaced and the report does not load any data. the recordselectionformula looks like:
{%differenz2} <> 0.00 <---
the sqlexpression (differenz2) contains the following value:
( f_evverbr_id_menge (EV_VERBRINGUNG.EV_VERBRINGUNG) ) + ev_verbringung.menge
f_evverbr_id_menge is a stored procedure that calculates a value.
If i load the report in Crystal reports 2008 the sqlexpressionfield in the recordselectionformula is replaced with the contents of the sqlexpressionfield and the report loads the data. The sql query looks like
SELECT ...
FROM ...
WHERE ...
AND ( f_evverbr_id_menge (EV_VERBRINGUNG.EV_VERBRINGUNG) ) + ev_verbringung.menge<>0
Does anyone have an idea why the sqlexpression is not replaced when i load the report with by my assembly ?
Thanks for your help!
Ralf