Crystal Reports 8, SQLite VB6 ODBC error

kalbarriman
kalbarriman used Ask the Experts™
on
VB6 project, previously using Access97 and Crystal Reports 8.0.1.0 all good for past ten years. Decided to upgrade DB to SQLite, all good too until changes to Crystal Reports. Created ODBC DSN and used reliable (??) SQLite ODBC driver. Set Location to new Tables in Crystal Report (.rpt) file. All good until I use 'Add Database field" and select a field from a table that is not in the 'Group By' option (but HAS been added to the report and is shown in Visual Linking Expert). Soon as I run report get the two error messages shown. Have tried different SQlite3 ODBC drivers, same result. Can 'hack' around most of it by consolidating most of my data into a single table but can't do that for some reports. Anyone prepared to do remote desktop to my machine and show me a fix is most welcome  (Not sure if that's allowed on this site but....) Error message 1 Error message 2
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
As you suspect your offer is not allowed in EE.

You can look in experts profiles to see if any of them offer support as you suggest.

I have seen the error and I forget what the fix is.  It has to do with how you have the tables linked.

mlmcc

Author

Commented:
Thanks mimcc. Offer withdrawn. I didn't know there were different ways to link tables. Drag and drop worked before when using Access db. Tables all appear to be linked correctly now.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
We had this issue several years ago and it reappeared on the report several times.  The solution had to do with how we linked a table or it may have been we couldn't use a table.  I don't recall and don't recall the report.

We were usiing XML files as the data source.

mlmcc

Author

Commented:
Thinking about linking got me on the right path. The solution was in fact to create a SUB-REPORT within the first report and then Link the Sub Report to the relevant field in the original table. This PDF I found helped explain how...(it was pretty simple actually)
http://forums11.itrc.hp.com/service/forums/getattachment.do?attachmentId=290107&ext=.pdf

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial