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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logon prompt when upgrade to crystal 11

Status
Not open for further replies.

ElaineRC

Programmer
Jan 20, 2005
7
GB
After upgrading from Crystal 10 to 11 I found that when I tried to run a report (I'm using Visual Studio .NET) i got a database logon prompt.

Didn't find any help on the web and after a painful 3 days of frustration and hair pulling I finally found the answer. Thought I'd log it here to save anyone else from the same fate.

The reason my reports would not run is because I was feeding the data in via 2 XML schemas. I had created a 'General' Schema which contained a table that was generic to all reports - it contained fields such as report subtitle, logo, and other heading details. Every report was linked to this schema. The actual report data was passed in using another schema - a report-specific schema.

This worked fine in Crystal 10 but not in 11. So I had to copy my 'general' table into all other schemas and delete my 'general' schema. So now I have 1 schema per report.

Hope this makes sense and I hope this helps someone!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top