x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 241 subscribers
  • Views 1328 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
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Curtis Morrow

Non Sage DB Report within Sage 300 CRE

Posted By

I have created a data warehouse database within the Sage 300 CRE SQL replicated databases to merge some of the data from both Timberline and Timberscan for reporting.  I have been able to write the Crystal Report and have it work when previewing from with Crystal Reports but I receive an error when running from within Timberline.  I was curious if this is even a possibility to have a non-Sage DB report run from within their product or if I need to look into a Crystal Report Viewer tool or possibly go the SSRS route.

Parents
  • 0

    HI Curtis,

    All Crystal reports written with a SQL data source must have the integration formula called tsReportType in order to generate it in 300 CRE.  The formula is 'sql'; create the formula in the design and there's no need to add it to the canvas. All the integration formulas are listed in the 300 CRE Users Guide. Please see if this will fix your issue.

    As a note, Sage only tests and supports reports written with Sage replicated SQL data, not with non-Sage DB.

Reply
  • 0

    HI Curtis,

    All Crystal reports written with a SQL data source must have the integration formula called tsReportType in order to generate it in 300 CRE.  The formula is 'sql'; create the formula in the design and there's no need to add it to the canvas. All the integration formulas are listed in the 300 CRE Users Guide. Please see if this will fix your issue.

    As a note, Sage only tests and supports reports written with Sage replicated SQL data, not with non-Sage DB.

Children
No Data

*Community Hub is the new name for Sage City