Print Page | Close Window

SQL EXPESSION PROBLEM...

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1746
Printed Date: 03 May 2025 at 8:24pm


Topic: SQL EXPESSION PROBLEM...
Posted By: great_mamun
Subject: SQL EXPESSION PROBLEM...
Date Posted: 24 Nov 2007 at 12:06am
Pls anyone help me how to incorporate SQL Expression in Crystal Report properly. I am using Visual Studio.NET 2005

-------------
Best Regards,
Abdullah Al Mamun



Replies:
Posted By: BrianBischof
Date Posted: 24 Nov 2007 at 1:07pm
I need a little more info. What have you tried so far? Basically, a SQL Expression is a formula written in only SQL code. Then you can reference that SQL expression in other formulas. The result is that the database server will process the SQL Expression code for you and make the report run faster.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Posted By: great_mamun
Date Posted: 25 Nov 2007 at 1:01am
Thanks,
Actually I what to know the both,
1. How do I write SQL expression syntax in CR
2. From C# code how do I pass it to CR

If you have any example or syntax then it will be helpful for me.

Thank you.


-------------
Best Regards,
Abdullah Al Mamun



Print Page | Close Window