Skip to Content
author's profile photo Former Member
Former Member

example using SQL expression fields?

Hi all,

What is the use of SQL expression fields in crystal reports 2008? Is it similar to writing SQL queries in oracle? explain me with an example using SQL expression fields in crystal reports 2008... thanks,

--regards,

Durai.S

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2010 at 09:18 AM

    Jason,

    Thanks for your reply. And the statement given by you was understandable and I need to concern on this a lot. So,

    Could be please suggest me a document in which I can get the relevant details of SQL Expression fields with an example?

    --regards,

    Durai.S

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2010 at 01:36 PM

    Durai,

    Actually the Add Command function is more akin to "writing SQL queries in oracle". The SQL Expression fields are used to insert a new field into the select list of the SQL statement generated by CR. It's useful if you want to, for example, create a calculated field using database specific functions.

    A good example... A field in the database is a text type but the data being stored in it is all dates... and you want to cast or convert the field to date field before bringing it into CR.

    CAST (TextField AS DateTime) AS NewFieldName
    

    I don't know Oracle but I'm sure there are plenty of Oracle specific functions that you wish CR had. SQL Expressions give you the opportunity to use those (as long as you're actually connected to an Oracle database of course).

    HTH,

    Jason

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.