I have a VB application that I am developing. This app has a test, stage and production environment. Each of which is in it's own directory. Is there a way that I can set the location of the database for the Crystal Reports in VB? Is there a location property that I can set to CurrentDirPath?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Setting the database location of a Crystal Report in VB
- Thread starter jjjjjjj
- Start date
jjjjjjj,
We use Microsoft SQL for our DataBases and if you are generating a report that just uses SQL statements we will change the SQLQuery and the Connection property for the Crystal control. When we are generating a report that uses a stored procedure we will change the DataFiles and Connection properties. The connection property will point to the correct server and the SQLQuery or DataFiles will point to the correct database. Hope this helps.
We use Microsoft SQL for our DataBases and if you are generating a report that just uses SQL statements we will change the SQLQuery and the Connection property for the Crystal control. When we are generating a report that uses a stored procedure we will change the DataFiles and Connection properties. The connection property will point to the correct server and the SQLQuery or DataFiles will point to the correct database. Hope this helps.
- Status
Similar threads
