Skip to main content
Question

IFS Business Reporter Parameter and Parameter Values are not showing on Pivot Table sheet When Running the Report

  • February 28, 2025
  • 0 replies
  • 19 views

Forum|alt.badge.img+3
  • Sidekick (Customer)
  • 8 replies

Hello Experts, 

We want to create a report using IFS business reporter which includes a pivot table. For this we have first created a flat table on a sheet and the pivot table on another. (Please note we need to create the flat table using report designer and then create a pivot table using excel functions since it is not integrated to business reporter as it was in IFS Business Analytics)

We have defined a parameter as Site and want to display it on the report when it is run. For that we have dragged and dropped the parameter name and parameter value from the document action pane to the sheet. 

 

We have done the same for other sheet where we want to see the pivot table, but with a different formatting. 

 

The cell formula for these values are as below. 

Formula for ‘Site Name’ on flat table sheet

 

Formula for ‘Site Name’ on Pivot table sheet

 

Formula for ‘Site Value’ on flat table sheet

 

Formula for ‘Site Value’ on pivot table sheet

 

 

However when we run the report, these values are shown correctly only on the flat table sheet. On the pivot table sheet they are not updated but only show the field names as ‘[SITE.Name]’ & ‘[Site]’

Flat table sheet when report is run​​​

 

Pivot table sheet when report is run

 

How can we have these values updated on the pivot table sheet?

 

PS: We have been working with IFS Business Analytics and this has been working without any issue. 

 

Thank You in advance.

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings