Page 1 of 1

Report Designer Could not convert

PostPosted: Mon Jan 02, 2017 6:53 pm
by BRobinsonS
When doing a Review in Report Designer, I get the message
Could not convert variant of Type (String) into Type (Double)

Not sure why I am getting this message. Several string fields, some currency, and totals.
My suspect that Report designer is try to do a calculation with string or perhaps formatting is incorrect but I get the correct numbers.

When I run the report under with Neobook, the report works ok but I get a message "Bookmark Invalid" when I close the report.
I think it may be related to the Report and not a database table bookmark.

Your thoughts?

Re: Report Designer Could not convert

PostPosted: Tue Jan 03, 2017 1:54 pm
by BRobinsonS
Found Report Designer field causing the 'could not convert' message.
I deleted the field and re-did the field and message went away in preview in design mode.

But still haven't found the cause of 'Bookmark invalid' when I close the report.

Re: Report Designer Could not convert

PostPosted: Mon Jan 16, 2017 7:27 pm
by Neosoft Support
Make sure your database has at least one Primary Key field. If you don't have one, create an AutoInc field and set it as the Primary key. MS Access databases don't work well when there is no primary key field.

Re: Report Designer Could not convert

PostPosted: Tue Jan 17, 2017 2:39 pm
by BRobinsonS
I know AutoInc Primary has been suggested before.
Most the tables have AutoInc Primary fields in this app.

Should all the tables have them?

Re: Report Designer Could not convert

PostPosted: Wed Jan 25, 2017 7:02 pm
by Neosoft Support
Yes, I recommend that all tables have a primary key field. Not having one is usually the cause of the bookmark error.