x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 8 replies
  • Subscribers 119 subscribers
  • Views 1444 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
770
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
854
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
878
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
Muhammad Hidayat

Sage 300 always prompt SQL login database when Custom Report from Crystal Report is printed

SOLVED
Posted By

Hello, I want to ask about a custom report that I made using crystal report.
So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300. when I wanted to print the custom report, a SQL login prompt appeared and I was asked to enter the SQL server password. while the report will be used by several users. it is not possible if I give SQL password to many users.

Please note that I'm new to this field of SQL and Sage 300 so I'm asking for guidance and giving me suggestions to solve this problem. Thank You.

Parents Reply
  • 0 in reply to Muhammad Hidayat

    It works because the Sage Crystal runtime engine needs to pass in the SQL credentials that it has in Database Setup.  But, if there are no Sage tables that is recognizes, like views or store procedures, it doesn't know what credentials to pass.  Adding CSCOM gives it something familiar.  When you don't join CSCOM to anything, the Crystal editor complains that unlinked tables are bad, but just ignore that warning.

Children
No Data

*Community Hub is the new name for Sage City