SQL Expressions/Functions

[bdander]

Can't I use native SQL functions from my RDMS in a report? I am trying to do this using the SQL Expression editor and keep getting errors, they are not recognized as valid functions. This works easily in Infomaker.

I can even do this in Access using a pass-through query.

 

[IdoMillet]

The SQL Expression Editor shows (in the function tree)
the available functions for your specific DBMS and driver setup.

Can you see the function you are using in the
function tree?

Cheers,
- Ido



ixm7@psu.edu

 

[bdander]

I have since discovered a Crystal Decisions technical paper on this topic.

It says you can only use the functions they have chosen to hard code into CR (as long as those functions are also available in the database vendor's ODBC driver).

As it is, it is a very limited list. Nearly half of the functions I have available in the RDMS and ODBC driver are not available. Infomaker lets me use whatever functions are in the ODBC driver, not just the ones they have chosen to hard code into the application.

 

[IdoMillet]

One option is to create a VIEW in your database
and use that as the data source for your report.

Another option is to use Crystal SQL Designer to
create a direct query and use it as the data source for your report.

Cheers,
- Ido

ixm7@psu.edu

 

[kenhamady]

Bdandeer,

I have never seen that white paper. You don't have a link to it or a file name, do you?

Another options is to use the Crystal SQL designer and run the report off of the QRY file. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com