Skip to Content
1
Former Member
Nov 30, 2009 at 10:55 AM

How to: Convert a 'table linked' report into a 'command' report

38 Views

We are moving from RDC to .NET. Our reports are created with a SQL Anywhere database (ODBC RDO).

Our biggest problem is that we cannot modify the sqlquerystring. SelectionFormula's are not an option because we can not pass parameters into a SQL expression. The only solution left is to user Command reports.

But how do we convert our reports that were created by linking tables into a command version. We can do it manually by:

- adding a Command 'table'

- paste the query into the command field

- replace all the existing report field by the 'command' field versions.

Problem is that this is a lot of work.

Is there a tool or other procedure to convert 'table linked' reports into a command version ?

Tia

Hans