zwieback89
Programmer
Hi,
Whenever we develop the reports, we need to set the database location by specifying the database server and the table or view which we want to refer to.
I have come to a stage where there are a large number of reports - reports and sub-reports. Last two times, when I shipped to a server in UK, a person over there had to manually change the database server all over again (set Location method) because it pointed to a different server based in our office even though it had the same database. Similarly, when we send these reports to the customers where they have a local database server, the same thing has to be done then as well.
It really takes a lot of time to change the database server location in each and every report.
What I wanted to ask in this perpective was is there a way where we can eliminate this way of changing the database location and mention only the table name in the report. The server and the table name is provided in one place and then it is provided to the CR (not just one report but all the reports). Tables or views are the same.
I do not know how to approach this issue, but I do definitely want to get rid of changing the database server everytime we send it to some client site for demonstration coz' it really takes an awfully long time.
I use CR 8.0, and all the reports are viewed from the web. I click on a link, pass a person ID, and then the report opens in the browser window showing information for that Person ID.
Please do give some way of doing this.
Regards,
Padmaja.
Whenever we develop the reports, we need to set the database location by specifying the database server and the table or view which we want to refer to.
I have come to a stage where there are a large number of reports - reports and sub-reports. Last two times, when I shipped to a server in UK, a person over there had to manually change the database server all over again (set Location method) because it pointed to a different server based in our office even though it had the same database. Similarly, when we send these reports to the customers where they have a local database server, the same thing has to be done then as well.
It really takes a lot of time to change the database server location in each and every report.
What I wanted to ask in this perpective was is there a way where we can eliminate this way of changing the database location and mention only the table name in the report. The server and the table name is provided in one place and then it is provided to the CR (not just one report but all the reports). Tables or views are the same.
I do not know how to approach this issue, but I do definitely want to get rid of changing the database server everytime we send it to some client site for demonstration coz' it really takes an awfully long time.
I use CR 8.0, and all the reports are viewed from the web. I click on a link, pass a person ID, and then the report opens in the browser window showing information for that Person ID.
Please do give some way of doing this.
Regards,
Padmaja.