meenakshikalera
Programmer
Hi!
First of all one basic question...
for a crystal report(version 8) created in vb6....using the designer...if i have initially created it using MS Access database and then at runtime i want to change it to use the MS SQL Server database...same table name (it could be different too)....is this possible?
i feel it is...i have been trying to do it, but its not working...i have read the pdf file on CR8 from business objects site too... i have used cTable.TestConnectivity...it shows true...but CRViewer displays it still as the original report....to check if i am doing the right thing...i have deleted one column from the corresponding table in SQL server, so that i know now this is beind displayed...
also wanted to let you know that i am using direct table connection for access tables...that is when u start the report creation using the expert in the designer....u choose database tables n then select ur table and so on....similarly for MS SQL Server, i do More data sources and then select MS SQL Server 2000 and enter my server name, use trusted connection (so no username and no passwd) and then select my table... i need to use this direct table connection for access tables because we already have a lot of templates created this way...else i will have to redo all my templates which is not at all feasible...
wht could be the problem?
do u want me to send my piece of code?
thanks,
regards,
meenakshi
First of all one basic question...
for a crystal report(version 8) created in vb6....using the designer...if i have initially created it using MS Access database and then at runtime i want to change it to use the MS SQL Server database...same table name (it could be different too)....is this possible?
i feel it is...i have been trying to do it, but its not working...i have read the pdf file on CR8 from business objects site too... i have used cTable.TestConnectivity...it shows true...but CRViewer displays it still as the original report....to check if i am doing the right thing...i have deleted one column from the corresponding table in SQL server, so that i know now this is beind displayed...
also wanted to let you know that i am using direct table connection for access tables...that is when u start the report creation using the expert in the designer....u choose database tables n then select ur table and so on....similarly for MS SQL Server, i do More data sources and then select MS SQL Server 2000 and enter my server name, use trusted connection (so no username and no passwd) and then select my table... i need to use this direct table connection for access tables because we already have a lot of templates created this way...else i will have to redo all my templates which is not at all feasible...
wht could be the problem?
do u want me to send my piece of code?
thanks,
regards,
meenakshi