Source language: Translate to:

Report Designer Could not convert

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Report Designer Could not convert

Postby BRobinsonS » Mon Jan 02, 2017 6:53 pm

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?
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Re: Report Designer Could not convert

Postby BRobinsonS » Tue Jan 03, 2017 1:54 pm

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.
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Re: Report Designer Could not convert

Postby Neosoft Support » Mon Jan 16, 2017 7:27 pm

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.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Report Designer Could not convert

Postby BRobinsonS » Tue Jan 17, 2017 2:39 pm

I know AutoInc Primary has been suggested before.
Most the tables have AutoInc Primary fields in this app.

Should all the tables have them?
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Re: Report Designer Could not convert

Postby Neosoft Support » Wed Jan 25, 2017 7:02 pm

Yes, I recommend that all tables have a primary key field. Not having one is usually the cause of the bookmark error.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests