Skip to main content
Question

How to transfer a screen date field as a parameter to an operational report ?

  • March 14, 2025
  • 5 replies
  • 49 views
F
Sidekick (Employee)
Forum|alt.badge.img+8
  • feng
  • Sidekick (Employee)

Hi Team,


We often transfer a screen field value as a parameter to an operational report using Page Designer. Do you know if it is possible to format a date item into a different format, such as Oracle's "to_date","to_char" etc. Thank you.

Although both the view field and report parameter are of date type, when I tried to transfer the screen value as the report's parameter and execute the report, the error shown below occurred.

 

Instead, if a fixed value of '2025/2/1' or '2025-2-1' is set in the Action Parameter, the error disappears. 

Do you have any good ideas to share with me?

 

Best Regards,

Feng

5 replies

PhillBronson
Hero (Customer)
Forum|alt.badge.img+11
  • PhillBronson
  • Hero (Customer)
  • March 14, 2025

What is the query behind the report? What’s the parameter matching against?

https://www.linkedin.com/in/phillip-bronson/
F
Sidekick (Employee)
Forum|alt.badge.img+8
  • feng
  • Author
  • Sidekick (Employee)
  • March 14, 2025

Hi ​@PhillBronson 

 

Thank you. I will check and get back to you.

BR

Feng

Rukmal Fernando
Superhero (Employee)
Forum|alt.badge.img+16
  • Rukmal Fernando
  • Superhero (Employee)
  • March 19, 2025

​@feng I haven’t tried this myself, but I believe you could potentially create a new Custom Field of type expression, use PL\SQL to format it as you like, and then pass the resulting value to your OR. 

https://docs.ifs.com/techdocs/24r2/040_tailoring/225_configuration/400_entity_configurations/020_create_custom_fields/020_add_edit_readonly_attribute/#expression_type

Best regards,

Rukmal

F
Sidekick (Employee)
Forum|alt.badge.img+8
  • feng
  • Author
  • Sidekick (Employee)
  • March 19, 2025

Hi ​@Rukmal Fernando 

 

Good idea. Thank you very much!

In fact, when I transfer the same date field to an IFS standard operational report, it works. So, there may be some issues with the customized report. 

I will update here if there are any new developments.

 

Best regard,

Feng

Rukmal Fernando
F
Sidekick (Employee)
Forum|alt.badge.img+8
  • feng
  • Author
  • Sidekick (Employee)
  • March 21, 2025

Hi ​@PhillBronson 

The query is as below. Do you think there are any issues with it? Thank you.

BR

Feng

Terms & ConditionsCookie settingsAccessibility statement