Line Numbers within Multiple Reports

Al_22614

​​Hello All:

I currently load several standard reports into a Monarch project and using a single Model to Trap data across the reports.  My question is:
How can I define a Field which captures the Line Numbers on each report.  For Each report, I want see, for example Rept1, lines 1,2,3, etc.;
Rept2, line 1,2,3, etc....  Thanks

Many Thanks
Al

------------------------------
Al Rice
Owner - President- CEO
Trends In Data, LLC
West Bloomfield MI
(248) 761-5238
------------------------------

CPorthouse

There is a built in function called "Line()" that you can use.  This will return the line number on the page where the detail record is found.  You might want to also include another formula "Page()" which will give the corresponding page number as well.


------------------------------
Chris Porthouse
Project Manager
Datawatch Corporation
Chelmsford MA
(978) 275-8381
------------------------------
-------------------------------------------
Original Message:
Sent: 02-28-2019 04:10 PM
From: Al Rice
Subject: Line Numbers within Multiple Reports

Hello All:

I currently load several standard reports into a Monarch project and using a single Model to Trap data across the reports.  My question is:
How can I define a Field which captures the Line Numbers on each report.  For Each report, I want see, for example Rept1, lines 1,2,3, etc.;
Rept2, line 1,2,3, etc....  Thanks

Many Thanks
Al

------------------------------
Al Rice
Owner - President- CEO
Trends In Data, LLC
West Bloomfield MI
(248) 761-5238
------------------------------
"

Mahmoud

Hi Al,
The line function (line()) returns the line on the report page of the last detail line for a record, which is not what you want.
You can create the following formula fields:
Id number field (assigns a unique number to each report loaded in Monarch): id()
Record number field: recno()
Row Number field: rowno
Create a filter by id number field for each report: for example id=1, or id=2, etc
When you filter by Id number field the record number displays values sequentially for the first report, for example for the first report, the record number will be 1 to n (where n is the last record number for the report1, for the second report, the record number will be n+1 to n+1+total number of records for the second report.
The Row number field displays record 1 to n for the first report, or second report , etc.  The row number field values will be the same for all reports when you select a filter by Id, but the record number field values change when you select a filter by Id.

Regards
Mo

------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 02-28-2019 04:10 PM
From: Al Rice
Subject: Line Numbers within Multiple Reports

Hello All:

I currently load several standard reports into a Monarch project and using a single Model to Trap data across the reports.  My question is:
How can I define a Field which captures the Line Numbers on each report.  For Each report, I want see, for example Rept1, lines 1,2,3, etc.;
Rept2, line 1,2,3, etc....  Thanks

Many Thanks
Al

------------------------------
Al Rice
Owner - President- CEO
Trends In Data, LLC
West Bloomfield MI
(248) 761-5238
------------------------------
"