So I have a bunch of reports created on a dev machine using ODBC DSNs that point to a dev environment. In order to migrate them over to our production Crystal server, I created a ODBC DSN with the exact same name on this server as the dev DSN on the dev machine. The DSN on the prod Crys server...
Hi Geoff,
Did you figure out how to do this finally. I am in a somewhat similar situation though a little bit different. I created a report using an ODBC connection that connects to a dev database and I now want to change it around to point to a production database.
Any help would be much...
Brian,
I am using ODBC. I guess I'm not explaining this right . Let me try this again.
So I created a report in Crystal 9 using the "Command" feature that lets u enter complex SQLs for report generation. I created this report to run against a development database. So I created a ODBC DSN for...
thanks for the post Gary. How do you get it to point to a different database. When one uses tables, we use the Set Datasource Location to change the database that the report accesses. How do u do the same thing for a command ?
thanks mikalm, I am not using VisualBasic or any other program to interface with Crystal. I am directly using Crystal reports. I'm guessing the solution u have provided works for a programming language interface with Crystal. Thanks anyways for the input
Hi All,
So I created a report in Crystal 9 using the "Command" feature that lets u enter complex SQLs for report generation. I created this using a development database. Now, its time to migrate it over to the production database. So i try using "Set Datasource Location" but it doesn't seem to...
Hi All,
How do I pass a total value from a subreport to the main report. The idea is to take the totals from the subreports and total it up in the main report. If there's a better way of doing this other than what I'm thinking please let me know,
thanks,
-- Tony
All,
When we develop in Crystal reports, we use a development database as a data source. When its time for cutover is there a fast way to change the data source to be the production database. Right now, the only thing I could think of is going into each report and changing the data source to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.