I upgraded a user from XP SP3 to Windows 7 Professional. Now, when he runs a report (CR 9) and tries to extract to an Excel spread sheet he gets this error:
Dos error - <report name>
This is the code
Code:Set Report = crxApplication.OpenReport("Z:\DAD\OnHandCustomerBalance.rpt", 1) For Each crxDatabaseTable In Report.Database.Tables crxDatabaseTable.ConnectionProperties("user id") = "sa" crxDatabaseTable.ConnectionProperties("Password") = myPasswordTechniSQL Next crxDatabaseTable Report.ExportOptions.FormatType = crEFTExcel80Tabular Report.ExportOptions.DiskFileName = "C:\CustomerBalance.xls" Report.ExportOptions.DestinationType = crEDTDiskFile Report.Export False




Reply With Quote