How to use SQL Expression Fields of Crystal Report 11.5 from VB.NET 2008
Posted
by Tareq
on Stack Overflow
See other posts from Stack Overflow
or by Tareq
Published on 2010-03-15T10:37:47Z
Indexed on
2010/03/15
10:39 UTC
Read the original article
Hit count: 1004
Filed under:
vb.net
|crystal-reports
I have the following SQL Expression Field in my Crystal Report 11.5
{fn CONCAT({fn CONCAT("SPR_PRODUCT"."PRODUCT_ID","SPR_PRODUCT_SUB_ITEM"."P_SUB_ITEM_ID" )},{fn CONCAT("SPR_PRODUCT_ITEM"."P_ITEM_ID","SPR_PRODUCT_GROUP"."P_GROUP_ID" )} )}
It works well in the Preview Mode.
But when I use the report in my VB.NET 2008 Project it says the following:
Error in compiling SQL Expression :
SQL Expressions can not be used in this report..
Error in File <...>.rpt:
SQL Expression error: Error in compiling SQL Expression :
SQL Expressions can not be used in this report...
Please help me by telling how can I use the SQL Expression field in VB.NET ?
Thanks in Advance.
© Stack Overflow or respective owner
