Date box missing in a report creation form

Question

Hi there,

In our company we are using Sage 300 premium (Version 2022). Users are connecting on Sage on a TS via Remote apps (RDP).
Users running Windows 11 25h2

One of our users is experiencing strange behavior that some of you may have already encountered. When she tries to generate a report,
the "cutoff" portion of the FROM - TO parameters only contains the FROM field. Consequently, an error message appears when she runs
the query since there is no limit date. Note that this problem only occurs in her session (her colleagues do not have this issue).

Do you have any idea what could be causing this?

Thank you in advance

Jim Love · Answer

Change the properties of the parameter used for cut off date. It appears that "Allow range values" is set to True; it should be False. Discrete value should be set to True. 
 After opening the report in the Crystal Designer, open the Field Explorer, then under Parameter Fields locate the parameter in use for that field. It is probably something like CUTOFFBY. Double click on that parameter to edit it. In the Value Options section, you will see the properties for that parameter. The discrete and range value options should be drop-down True or False. Click on that word to select the other option. Click OK, then Save the report. That should do it. 
 Below is a typical example.

Shane Romaine · Answer

Since this works for other users, I would guess this issue is being caused by screen resolution or use on a second monitor. Either way, I would suggest increasing the width of the vb form you are using.

Sage 300

Date box missing in a report creation form

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING