Submit Your Suggestions for Vista

Ideaspace topics with the most votes have been moved into the Suggestion Box. If there is a topic missing, please re-enter. Our product team reviews the Suggestion Box items regularly and will provide updates as to status and incorporation into upcoming releases.

• Home /
• PF-I-111 /
• New Suggestion

8 Vote

Support Optional Parameters with Crystal Reports

In newer versions of Crystal Reports you can easily setup Optional Parameters which allows a user to enter a value and if they leave it blank, Crystal ignores it.  There is a workaround in older versions of Crystal, which ViewPoint supports, but it's convoluted.  When you use Optional, Crystal creates the Report Restriction syntax for you.

 

Optional Parameter Syntax which is auto-generated (example):  (not HasValue({?Contract Type}) OR {@Contract Type} = {?Contract Type})

Workaround Syntax:  (if {?Contract Type} <> '' then {?Contract Type} = {@Contract Type} else 1=1) 

 

• Mercedes Green
• Nov 2 2016

Vista Apps / RP - Report Admin

Company	Skygrid
I need it...	3 months

• Comments (0)
• Votes (8)

• Attach files

  Enter a subject

• 
• 
• 
• 
• 
• 
• 
• 

Log in / Sign up

Identify yourself with your email address

Email address

Subscribe

You won't be notified about changes to this idea.

Related Suggestion

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.