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.

Financials Suite Sage Online Crystal reports and SQL query

State Not Answered
Replies 2 replies
Subscribers 116 subscribers
Views 1328 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

Sage Online Crystal reports and SQL query

Posted By ValerieH over 6 years ago

Can anyone advise me if you can run custom crystal reports against data that is on the Sage Online hosted offering. Also is there any way to query the SQL data through tools like SQL enterprise manager.

0 Jim Love over 6 years ago

Custom reports, yes. Query the SQL data, no, unless you take a copy and load it locally on your own system.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 49153 over 6 years ago

You can query the SQL data in a VBA macro using the CS0120 view.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Sage Online Crystal reports and SQL query

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING