Crystal Report in Access

[TheShabz]

Hi all,



I've been given a Crystal Report to run as part of a monthly workflow. I'd like to integrate it into Access. Both are linked to SQL Server via ODBC. Is there a way to either link to the Crystal Report or at least extract the SQL and put it into Access?

Me no likey Crystal

[June7]

Does this help http://publib.boulder.ibm.com/infoce...tabases11.html

Do you have the Crystal Reports software?

[TheShabz]

That doesn't really help. I do have Crystal Reports installed on my machine. I just find it insanely convoluted for practical purposes. I can see the "database expert" and the tables and joins. However, I have no idea how the actual SQL functions. I can't find. This thing has to have a SQL view. I just cant find it. If not, I'd like to be able to essentially import the crystal report into access (though I doubt this is possible).

[June7]

So you can not find the SQL viewer on the Crystal Reports menu as suggested by that link?

Google: Access import crystal reports

Here is one for you to check out http://import.software.informer.com/...ort-to-access/