Question

Column Grouping IFS Business Reporter

  • 5 July 2023
  • 5 replies
  • 46 views
T
Rank
Userlevel 2
Badge +6

Hi,

 

I have added a grouping for repeated column (D Column) in business reporter. It works in design mode but when running the report, it is not working. See the below images for reference.

Any idea about how to collapse repeated columns in BR?

 

Before running

After Runing

 

5 replies

T
Rank
Userlevel 2
Badge +6

Any suggestion ?

SandT
Rank
Userlevel 3
Badge +6

Hi @TopDeepaW,

 

Were you able to get the collapse option when you order the report from the Business Reporter client? or didn’t it give that option from both Business reporter client and your IFS client?

 

Best regards,

SandT

 

Best Regards, SandT
T
Rank
Userlevel 2
Badge +6

Hi,

It doesn’t work both Business reporter client and IFS client.

EntNadeeL
Rank
Userlevel 5
Badge +9

Hi @TopDeepaW 

Can you share a screen shot of Repeater for the column D in design mode? 

You need to remove the company from repeater to avoid repeating

Nadeesha Liyanage - https://www.linkedin.com/in/nadeeshaliyanage/
SandT
Rank
Userlevel 3
Badge +6

Hi @TopDeepaW,

 

It works in both clients for me. I have attached a sample report for your review. I followed the following steps when developing that report.

  1. Put column repeater to company.
  2. Select the entire column.
  3. Enable Group functionality.

 

Please check the attached report. If it also does not work for you please let me know your BR version. I did it on a cloud version 22.1.4.

 

Hi @EntNadeeL ,

 

I think that the requirement of @TopDeepaW  was to collapse the columns of the GL balances of all companies. As per my knowledge the company repeater should be there to repeat the balances within all the companies against GL accounts. Please correct me if I’m wrong.

 

Best regards,

SandT

1 Attachment
Best Regards, SandT

Reply


Terms & ConditionsCookie settings