x Want to participate? Join the group to interact

Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Reporting and Analytics Conversion INT to VARCHAR (Sage BI Report )

State Not Answered
Replies 1 reply
Subscribers 117 subscribers
Views 704 views
Users 0 members are here

Browse Forums

Announcements

268

260

Databases and Operating Systems

757

Financials Suite

General Discussion

10k

Operational Suite

851

Reporting and Analytics

Reports, Macros, and Customizations

876

Sage CRM for Sage 300

182

410

Conversion INT to VARCHAR (Sage BI Report )

Posted By Pkash over 4 years ago

Hi All,

I have used on the query to Sage 300 BI report, but it is getting an error on conversion.Please see the below and advise me.

GLAMF.ACSEGVAL01 IN (CONVERT(varchar(10), @Segmentcode@))

The Error is "[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','."

Please advise.

Prakash

Parents

0 DaneArxis over 4 years ago

Try:
IN CAST ((@Segmentcode@) AS VARCHAR(10))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 DaneArxis over 4 years ago

Try:
IN CAST ((@Segmentcode@) AS VARCHAR(10))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 300

Conversion INT to VARCHAR (Sage BI Report )

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING