ICR - Moved to Microsoft SQL

[ultrav]

Progression 7.6.3 just converted from Pervasive to Microsoft SQL - Clients are XP

Getting an error when trying to print the ICR reports(MacCROut.Execute - 2147206396). I redirected the reports so that they are pulling the SQL Data - the driver is the ODBC driver. Am I missing anything?

The crystal reports I have written myself and redirected are working fine.

Celeste

 

[dgillz]

There is no need to redirect the ICRs if you have upgraded to MS SQL. Why did you take this course of action? Also what version of Macola are you on including service pack?

The ODBC DSN should be _data_XX_MSSQL where XX is the company number. Is this the DSN you are using?



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[NEmacGuy]

Did you install crystal after installing macola ?
If so then re-install Macola client.
If that doesn't work, which version of crystal 7 or 8 ?
You probably only have to register the correct dll for the crystal viewer .

 

[ultrav]

I should have clarified I was trying to reinstate ICRs that had been modified by me. Turns out it was an issues with subreports for terms and ship via's - the tables were not mapping correctly. Also had to reset the SQL query.


Thanks
Celeste