Skip to main content

hello,

We have a business reporter with 2 parameters: year and period. We will use the scheduled reports option to schedule this report and enter context variables (e.g. #year#, #last month#).

using function parameters, we need to figure the year period (yyyymm) which will be used to filter on various report columns (e.g. last period, last year current period etc.). 

The issue is that if we enter year:2024 and period:7, how can we get business reporter to convert these 2 parameters to year-period value 202407 instead of 20247. 

Any suggestions? This is in Apps 10 (version 5.0.27). 

 

Found a way… See below.

Convert year to year string (to_char)

Convert period to period string (to_char)

lpad(periodstring, 2, 0)

concatenate year and lpad(periodstring,2,0)

2024 and period 7 will show up as 202407. 

 


Reply