Skip to Content
0
Former Member
Apr 01, 2009 at 01:24 PM

SQL Expression in recordselectionformula

31 Views

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