Question

Business Reporter - Adding repeaters for APP9

  • 31 August 2023
  • 2 replies
  • 45 views

Badge +3

Hi,

I created a new Information Source from an IAL view and added  the 45 fields to the Business Reporter. When adding the repeaters, can anyone please explain how can I add the repeaters to the following report? should I have to include each and every field as the repeaters?

 

The fields of the report :

 1            Company

2            State

3            Customer #

4            Customer Name

5            Address 1

6            Address 2

7            City

8            County

9            State

10          Zip

11          Invoice No.

12          Invoice Series   

13          Invoice Type      

14          Status  

15          Correction Invoice #       

16          Correction Reason         

17          RMA #  

18          Pay Reference   

19          Invoice Date

20          Due date

21          Payment Terms

22          Invoice Net Amount

23          Invoice Tax Amount

24          Invoice Gross Amount

25          Sales Part

26          Sales Part Description

27          Sales Group

28          Sales Group Descr.

29          Invoiced Qty.

30          Line Sales Price

31          Line Net Amount

32          Line Tax Amount

33          Line Discount

34          Line Gross Amount

35          Invoice Open Amount

36          Order No.

37          Customers PO. No.

38          Payer

39          Check Amount

40          Payment Amount

41          Payment Date

42          Batch Number

43          RSM

44          Order Type

45          Invoice/Credit

 

The screenshot of the Business reporter is as shown below.

 

 

Thank you.


2 replies

Userlevel 5
Badge +9

@IniVismiM

Unfortunately yes!

I could not find any other way either.

I guess you don't have  to include everything in the repeater (such as amounts). But you have to be careful as each repeater acts as a grouping.

Cheers

Userlevel 3
Badge +9

@IniVismiM First, you need to  decide how the report need to process it out put. let say you need to see all the values accumulated according to company, then you can use only the company as a row repeater. Then the out put will accumulated all the measure items  and show the totals  grouped by based on the companies in the database (you can use filter criteria if  you need to filter any values.)

 

Likewise, you can decide the outcome and depend on it you can decide the repeaters. If you have not created the dimensions when creating the quick information source, then you might have to check the output and sometimes you will remove  some measure item values from quick information source to get the correct values in the output report.

 

Hope this helps.

 

Kind Regards!

Niyomal.

Reply