x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 3 replies
  • Subscribers 120 subscribers
  • Views 2328 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
963
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
lpratte

Crystal Reports Dynamic Parameters

Posted By

I have written a report in Crystal utilizing dynamic parameters.  When I run the report outside of Sage, it works fine and all of the parameters work as they should.  If I add the report to Sage 100, the parameters no longer function properly.  There is nothing to select from in the drop down lists.  I have adjusted the LOV values on my pc as well as on our server, but it did not seem to help.  I ran the report, within Sage 100, from our server and it worked properly.  I would appreciate any ideas.  

  • 0
    I am having the same problem on Sage Premium 5.1. Parameters do not work from within Sage menu when users are logged in. Parameters are not dynamic. 1 Parameter has a list of values loaded in (values do not display) & another is a Date Parameter. (Date calendar icon is shaded out.) Report only shows parameters correctly when run directly on server from within Sage.
  • 0

    What version of Crystal are you using? What Sage 100 version? Did you uncheck "Save Data with Report" under the File menu in CR?

  • 0 in reply to BShockley
    This is Sage version 5.1 Premium (SQL) version. Crystal is 2011 version. "Save Data with Report" is unchecked. If we run reports from within Sage directly on server, parameter screen is accessible and selection values display (either with Dynamic Parameter or Static Parameter w/values loaded in). When users run report, parameter screen pops up but selection values are blank and date parameter calendar icon is shaded out. I consulted a SQL programmer at one of our other clients & he said he could never get reports with parameters to run from within the Sage menu on Sage Premium. He thought the report request screen could not connect to the database. Yet I have another Sage SQL client who has at least 50 Crystal Reports with parameters running off the Sage menu with no issues at all. Very strange...

*Community Hub is the new name for Sage City