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