Skip to Content
0
Former Member
Dec 07, 2009 at 07:47 AM

Convert table linked report into a Command version - Howto?

35 Views

How can I convert hundreds of reports from table linked into a Command version?

One way to do is to take the SQL syntax off the report, add a Command with that Syntax and manually replace the database fields by the Command fields.

I can not believe that is the right way to this. Is there no hidden (re-)mapping fields button or another undocumented feature?

If this is the way to do it... when will there be a one-button-click solution. The underlaying data keeps the same, could not be that hard to build..?

Without that basic functionality Crystal Reports is not option for us anymore.

Backgroud: We do have hundreds of reports that are created by an ODBC (RDO) database (SQL Anywhere database), created by linking the tables and select the fields we like to use in the report. This works fine at least as we used the RDC method in our application. Because we are moving to .NET we could not use RDC anymore and have to use the .NET methods. However the .NET SDK is very limited. The only way to add more complex WHERE statements is to use the Command functionality of Crystal Reports.