I have designed the reports using one SQL Server. Now when i call this report from my VB application it works fine. when i set the Logonserver property of the database for a different SQLserver it still displays the data from the old server on which i had designed the report. Can anuy body tell me how do i get data to get displayed on this report from any SQL server from a VB application. I have designed the reports using p2ssql.dll. And i also don't want to use the DSN.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to use reports on different servers..
- Thread starter asimasm
- Start date
asimasm: You'll stand a better chance of getting a response to this question in the Integrate/Distribute forum David C. Monks
david.monks@chase-international.com
Accredited Crystal Decisions Enterprise Partner
david.monks@chase-international.com
Accredited Crystal Decisions Enterprise Partner
- Thread starter
- #4
Yes I had used a different technique for this dsn kind of problem. I changed my report driver to ADO/DAO/RDS type. Now i pass recordset instead of selection formula from my vb application to the report. So now i m only using Crystal Reports to Display the data sent from my application instead od it to first process and then display. Bcz i have abut a million records in the database and this method is the fastest one that i have seen.
Asim
Asim
- Status
Similar threads
- Locked
- Question
- Locked
- Question