x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 6 replies
  • Subscribers 67 subscribers
  • Views 4513 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
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
17
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Ned L

Crystal reports conversion from Pervasive to SQL

Posted By

Does anyone have a lead on someone who could convert custom crystal reports that work with the pervasive database versions of estimating, to reports that will work with SQL?  It would seem the reports have to be rebuilt once you upgrade to SQL.  Quite frustrating!  Seems like SAGE would have created a tool to re-map/or otherwise convert existing custom reports.  If one is not familiar with crystal reports and database structures it is quite a daunting task to create them.  Upgrading estimating breaks these reports that have been serving me well for maybe 7 or 8 years!?

Thanks,

Ned

Parents
  • 0

    Actually, converting any crystal report from P-SQL to SQL is a very easy process.  less then 15-30 on the 1st report then it gets quicker once you know how.  Be glad to show you as time permits.

  • 0 in reply to Bill Kormoski

    Thanks Bill, I have spent the morning building a new report by comparing the old with the new.  The field names appear to be somewhat similar although its mostly trial and error for me.  Some of the fixed text can just be copy/paste.  Somewhat clumsy for me as I have to learn the programs as I go, but it is slowly getting there!  Any tips you have would be appreciated.  Time, our most valuable asset, the crux of the biscuit!  Heading out to the field for now.  Have a good day.

Reply
  • 0 in reply to Bill Kormoski

    Thanks Bill, I have spent the morning building a new report by comparing the old with the new.  The field names appear to be somewhat similar although its mostly trial and error for me.  Some of the fixed text can just be copy/paste.  Somewhat clumsy for me as I have to learn the programs as I go, but it is slowly getting there!  Any tips you have would be appreciated.  Time, our most valuable asset, the crux of the biscuit!  Heading out to the field for now.  Have a good day.

Children

*Community Hub is the new name for Sage City