x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 5 replies
  • Subscribers 76 subscribers
  • Views 4184 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Claude Brulotte

Could not convert variant of type (OleStr) into type (Double)

Posted By

Hello,

I crated a new View in the Customer entity where I needed to extract Sales information from Sage300.

The view is created in CRM and a "Select * from" that view executes without errors in SSMS (SQL Management Studio).

When trying to execute a new report based on that view in CRM, I get the following message:

"Could not convert variant of type (OleStr) into type (Double)"

I can't find any details on that error in the CRM logs and Tomcat logs.

System info: Sage CRM 2019 R2

 

Any help would be appreciated.

Thanks.

Parents
  • 0

    Hi Claude,

    Perhaps try the stepped troubleshooting approach to this.
    Remove the field that you think is causing the issue from the view and recreate the report. Check if that works. If it does then you know that field needs to be converted to something else. Try and cast to a varchar perhaps?

    If removing that field makes no difference, then perhaps remove more until you have found the troublesome field and then try and fix that field only. I would suggest perhaps casting to varchar just to see if that is indeed the issue.

  • 0 in reply to Conrad Roux

    Thanks for the followup, Conrad,

    That's what I ended up doing.

    The strange thing is that a Date Field was causing the issue. 

    So I had to keep the date field in Date format for the "Filter" section, and add the date field cast as varchar (formatted YYYY-MM-DD) in the Report View for display in the actual information in the report columns. 

Reply
  • 0 in reply to Conrad Roux

    Thanks for the followup, Conrad,

    That's what I ended up doing.

    The strange thing is that a Date Field was causing the issue. 

    So I had to keep the date field in Date format for the "Filter" section, and add the date field cast as varchar (formatted YYYY-MM-DD) in the Report View for display in the actual information in the report columns. 

Children
No Data

*Community Hub is the new name for Sage City