Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 15th, 2010, 06:57 AM
Registered User
 
Join Date: Mar 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Angry How to use SQL Expression Fields of Crystal Report 11.5 from VB.NET 2008

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored Procedure Not Returning Same Value As Inline Sql VB.Net 2008 slbibs ADO.NET 6 March 11th, 2010 04:16 AM
Crystal Report 2008 using .net 2.0 ankit_cs Crystal Reports 0 April 4th, 2009 02:59 AM
Crystal Reports 11 from VB to VB.net koushik_b2002 Crystal Reports 2 June 1st, 2008 01:58 AM
VB 6 and Crystal report 11 deployed on win 98 shantanu86 VB Components 0 March 16th, 2006 10:11 AM
How add Crystal Report Control (Ver 11) in VB 6 priyakumar Crystal Reports 0 February 2nd, 2006 04:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.