Skip to main content
Question

Business Reporter for IFS Cloud issue referencing different sheets

  • 5 July 2024
  • 1 reply
  • 20 views

Hi,

We are upgrading to IFS Cloud 23R2 and have an issue with Business Reporter reports that were written in IFS Apps 10.

We have tested in the BR client versions 23.2.0, 23.2.1 and 23.2.2 – the issue is present in all of them.

Our report developers have used multiple sheets and use many formulas referring to data on other sheets like this example:

In the Design view you can see the reference to a sheet within the workbook.

 

When the report is run you can see the sheet names have been stripped out so excel is now referring to cells on the current sheet:

 

 

We need this resolving ASAP as our go live approaches.

We have raised a ticket but nothing has been done yet.

 

Thanks
Paul

1 reply

Userlevel 2
Badge +6

It looks like my images got stripped out.

In the Design view you can see the reference to a sheet within the workbook.

 


When the report is run you can see the sheet names have been stripped out so excel is now referring to cells on the current sheet:

 

 

Reply