x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 239 subscribers
  • Views 1059 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
PSK

Microsoft SQL Stored Procedure for CM Register Report

Posted By

I am inquiring about the CM Register report.  Running the report for all our cash accounts for only one day can take an hour to generate.  

1.  Has anyone had good success in getting the CM Register report to run faster?  If so, I'd love to know how you did it.

2.  Has anyone taken the time to re-write the report to use Microsoft SQL using a stored procedure?  If so, any change you'd share the rpt file and the stored procedure with me?

As some point, I'll break down and write the stored procedure but wanted to check to see if someone has done it already or not.

Parents Reply
  • 0 in reply to Jesse Gordon

    We currently replicate from Pervasive to Microsoft SQL using Anterra Datacenter.  It works quite well for us.  My real question is, has anyone already built this report in Microsoft SQL instead of me recreating the wheel.  If not, that's fine.  When I finish it, I'll share it.

Children
No Data

*Community Hub is the new name for Sage City