Home > DeveloperSection > Beginner > SqlExpression Field in Crystal Report

SqlExpression Field in Crystal Report


Crystal Report Crystal Report 
Ratings:
1 Comment(s)
 37058  View(s)
Rate this:

SqlExpression Field in Crystal Report

SQL expressions are like formulas, but they are written in Structured Query Language (SQL). An SQL expression can be used to query the database for specific sets of data. You can sort, group, and select based on SQL expression fields.

Here we have crystal report with some product details (in visual studio 2010).

SqlExpression Field in Crystal Report

SqlExpression Field in Crystal Report

To create an SQL Expression field:

In the Field Explorer, right-click on SQL Expression Fields and click new.

Enter a name in the Name box, and then click OK.

SqlExpression Field in Crystal Report

SqlExpression Field in Crystal Report

The SQL Expression Editor appears. The SQL Expression Editor functions in the same way as the Formula Editor.
Type the expression in the SQL Expression Editor.
Click the Save and close button.

SqlExpression Field in Crystal Report

After adding an expression drag the field from the SqlExpression field and drop it into the details section of the crystal report.

SqlExpression Field in Crystal Report

You can see the output or preview of report from Main Report Preview or run an application.


good article

By aken H on   5 years ago

Hi  Rohit Kesharwani ,

 thanks for your article.


Don't want to miss updates? Please click the below button!

Follow MindStick