Adding SQL database queries to a Crystal report
Posted on 2008-10-06
I'm working on some maintenance of a Crystal report that was built with a html front end.
I'd like to make my addition by adding a sql query to the report file itself and not have to do any work with the html feed of data into the report file if possible.
Does Crystal have a good way that I can use the ODBC data source the report already uses and add a SQL query that I can store the result in a formula I create within the report or am I simplifying this too much??