This is an interesting point that I would like to discuss with other users of version 9 of Crystal...
I am trying to remove the explicit tablenames from version 9 in the following manner.
DATABASENAME.OBJECTOWNER.OBJECTNAME to
OBJECTNAME
This was a standard feature of version 8.5 of Crystal Reports. By removing this you could then specify the databasename you wished to connect to in code and even the DSN by changing the DSN to a variable set at logon time for your application.
Example. Multiple applications/databases using the same set of reports for different clients. All reports are stored on a central webserver and by changing the DSN at report request time I can cut down on maintenance and report design time by releasing the same reports to all clients.
Now. In version 9 you cannot modify the explicit table names. When I asked Crystal Decisions about this I got the following email:
Dear John,
CR9 will use explicit table names. This is by design.
The option to specify the table name only as opposed to the full explicit table name is not supported
Best Regards
Fine. No problem. It's been removed . End of Story.
No. If you take a report created in version 8.5, and with the explicit table names removed to make the report generic the report will not have the explicit names in version 9 when upgraded/modified.
Very odd. And more than a little distressing as Crystal claims that this function is no longer supported in version 9. Even more of an issue is that you can end up with reports with explicit table names and table names only if you take a report converted from version 8.5 and add tables to the report in version 9. Even performing verify database will not add the explicit table names to the converted report.
Does anybody have an opinion on this, or come across this particular problem previously?
I have sent my sample reports to Crystal and will post any feedback I get on this thread.
I'm located in the UK and am speaking to the Uk support people. If anyone knows differently from another source, please tell.
John Owen
I am trying to remove the explicit tablenames from version 9 in the following manner.
DATABASENAME.OBJECTOWNER.OBJECTNAME to
OBJECTNAME
This was a standard feature of version 8.5 of Crystal Reports. By removing this you could then specify the databasename you wished to connect to in code and even the DSN by changing the DSN to a variable set at logon time for your application.
Example. Multiple applications/databases using the same set of reports for different clients. All reports are stored on a central webserver and by changing the DSN at report request time I can cut down on maintenance and report design time by releasing the same reports to all clients.
Now. In version 9 you cannot modify the explicit table names. When I asked Crystal Decisions about this I got the following email:
Dear John,
CR9 will use explicit table names. This is by design.
The option to specify the table name only as opposed to the full explicit table name is not supported
Best Regards
Fine. No problem. It's been removed . End of Story.
No. If you take a report created in version 8.5, and with the explicit table names removed to make the report generic the report will not have the explicit names in version 9 when upgraded/modified.
Very odd. And more than a little distressing as Crystal claims that this function is no longer supported in version 9. Even more of an issue is that you can end up with reports with explicit table names and table names only if you take a report converted from version 8.5 and add tables to the report in version 9. Even performing verify database will not add the explicit table names to the converted report.
Does anybody have an opinion on this, or come across this particular problem previously?
I have sent my sample reports to Crystal and will post any feedback I get on this thread.
I'm located in the UK and am speaking to the Uk support people. If anyone knows differently from another source, please tell.
John Owen