-
CR Chart not displayed
I have a legacy application that I originally wrote for Windows 95 and have migrated many times as my client has changed operating systems. I have always been able to deal with the nuances of each upgrade, however a new one has come up in Windows XP.
The application is a VB 6.0 application using the Crytal REports 8.5 REprot Designer Component and an Access database. When I run the program on the development machine, everything runs fine, however, when I try to run on the client machine (CR not installed and package created with Package and Deployment wizard) I get an error message "Physical Database not Found". In researching this I noticed that my actual reports were using the DAO driver. I cahnged this to ODBC and got the same error. I then changed to ADO and the reports now show data on the client machine.
PROBLEM SOLVED, SO I THOUGHT!!!
I have several charts as footers in the reports. These again show up fine when I run the application on the development machine, but do not show up at all on the client machine, even though the report tabular and columnar data shows up.
My code in the CRViewer control looks like the following:
CRViewer1.ReportSource = LeadReport
LeadReport.FormulaFields(3).Text = m_strFromDate
LeadReport.FormulaFields(4).Text = m_strToDate
LeadReport.FormulaFields(5).Text = m_strReportParam
LeadReport.FormulaFields(6).Text = m_strSubParam
LeadReport.RecordSelectionFormula = m_strRecordSelection
LeadReport.EnableParameterPrompting = False
Where LeadReport is a report object created by the designer within VB. Again, the data part of the reports works fine, it is just the cahrt pages that are completeley blank. I also get the magnifying glass to drill down when I hover over where the report should be, it is just that there is no visible data.
Can anyone help with this problem???