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.