Solved

JUST ONE RECORD ROW BUSINESS REPORT

  • 19 November 2021
  • 5 replies
  • 52 views

Userlevel 5
Badge +12

Hi all.

I have a simle QIS without security filter and as I run the report in excel it fetches just one row.

Even running with the owner.

How please could I fix this?

Tks

 

 

 

icon

Best answer by Thiwanka Sandaruwan 19 November 2021, 17:48

View original

This topic has been closed for comments

5 replies

Userlevel 4
Badge +9

Hi @lopespetro ,

 

Please create a row repeater by using Group Id. Please refer below example to get a clear idea.

 

Best Regards,

Thiwanka

Userlevel 4
Badge +9

Hi @lopespetro ,

 

If that row repeater creation is not clear for you Please follow the below steps.

 

  1. Select entire 2nd row in your report design.
  2. Then click the highlighted icon from document action. (please refer the attached screenshot)

 

It will automatically add the row repeater for Group Id.

 

Then run the report. 

 

Best Regards,

Thiwanka

Userlevel 5
Badge +12

Hi @lopespetro ,

 

Please create a row repeater by using Group Id. Please refer below example to get a clear idea.

 

Best Regards,

Thiwanka

Hi @Thiwanka Sandaruwan , As I try to create I get this error?

What may it could be?

Tks

 

Userlevel 4
Badge +9

Hi @lopespetro ,

 

If that row repeater creation is not clear for you Please follow the below steps.

 

  1. Select entire 2nd row in your report design.
  2. Then click the highlighted icon from document action. (please refer the attached screenshot)

 

It will automatically add the row repeater for Group Id.

 

Then run the report. 

 

Best Regards,

Thiwanka

Hi @lopespetro ,

 

I hope you are trying to follow the above suggestion. Could you please reopen the business reporter and try to design the report again?

 

And please let me know your business reporter client version.

 

Best Regards,

Thiwanka

Userlevel 5
Badge +12

Hi @lopespetro ,

 

If that row repeater creation is not clear for you Please follow the below steps.

 

  1. Select entire 2nd row in your report design.
  2. Then click the highlighted icon from document action. (please refer the attached screenshot)

 

It will automatically add the row repeater for Group Id.

 

Then run the report. 

 

Best Regards,

Thiwanka

Hi @lopespetro ,

 

I hope you are trying to follow the above suggestion. Could you please reopen the business reporter and try to design the report again?

 

And please let me know your business reporter client version.

 

Best Regards,

Thiwanka

Hi @Thiwanka Sandaruwan , Now I’ve got it.

I selected before the row bellow the title before.

I see that I need to select the named row.

Tks a bunch.