kismetgerald
New member
- Joined
- Jan 13, 2013
- Messages
- 4
- Programming Experience
- Beginner
Good-day All,
After watching numerous online tutorials and reading the documentation, I decided to get hands on with the Crystal Reports for Visual Studio runtime. It is my understanding that the SAP Crystal Reports runtime doesn't natively support connections to a MySQL DB so I believe I've done everything correctly to pull the DB records into a Dataset object. I can see the records in the Dataset and they match what's in the Database. Unfortunately, when I run a preview of the report everything is "gibberish" except for the Date fields. Also, at run-time the report is blank.
I'm stumped and don't know what to do now, any assistance would be greatly appreciated. Screenshots below show the records from the Dataset as well as the Report preview.
By the way, the Collation on the server and table are both set to "Latin1 - Default Collation" - not sure if that makes any difference.
Thanks.
//Kismet
After watching numerous online tutorials and reading the documentation, I decided to get hands on with the Crystal Reports for Visual Studio runtime. It is my understanding that the SAP Crystal Reports runtime doesn't natively support connections to a MySQL DB so I believe I've done everything correctly to pull the DB records into a Dataset object. I can see the records in the Dataset and they match what's in the Database. Unfortunately, when I run a preview of the report everything is "gibberish" except for the Date fields. Also, at run-time the report is blank.
I'm stumped and don't know what to do now, any assistance would be greatly appreciated. Screenshots below show the records from the Dataset as well as the Report preview.
- Screenshot #1: VIEW OF DATASET RECORDS
- Screenshot #2: DESIGN VIEW OF REPORT
- Screenshot #3: PREVIEW OF REPORT
By the way, the Collation on the server and table are both set to "Latin1 - Default Collation" - not sure if that makes any difference.
Thanks.
//Kismet