Using part of a report

[Richard Corby]

I only care about getting data from one part of my report. Is there a way to tell Monarch to only trap and gather data from that section? I have been editing the Text file, but that is cumbersome.

[Phil]

new to forum and the way it works but have been using monarch v5 for ages - the only way I could help you is if you send me an example of the report or type example of what you have and what you want in your reply

[Darren]

Richard, yes please post a sample of the data within the report that you would like to trap. Once we see the data and the problem, I'm sure there will be someone here who can help you out!
smile.gif


Originally posted by Richard Corby:
I only care about getting data from one part of my report. Is there a way to tell Monarch to only trap and gather data from that section? I have been editing the Text file, but that is cumbersome.

[Grant Perkins]

Richard,

To echo Phil and Darren, an example (full format but disguise the data if necessary) would help to explain the particular problem and knowing which version of Monarch you have access to may also be useful for suggesting possible solutions.

I assume you cannot easily separate the data you want from the data you don't want when you create a trap and templates - or at least can't see a way to do it.

In which case have you looked for a way to filter the records after they have been selected? If so, and if that does not seem possible either, how do you currently decide which bits of the report to keep and which to discard during your edit?

Looks like a lot of people interestind in this one!

Grant



Originally posted by Richard Corby:
I only care about getting data from one part of my report. Is there a way to tell Monarch to only trap and gather data from that section? I have been editing the Text file, but that is cumbersome.

[Richard Corby]

The report is quite large. Each customer is assigned an employee. The report contains detail by customer, and then at the very end, a summary by employee.

I have one Model which pulls all of the detail (although it is missing some and I need to figure out somehow how the trap is missing the data). I then want another model which traps the summaries at the bottom.

I could not figure out how to just trap the summaries at the bottom, so I figured there must be a way to tell Monarch "ignore the first 3000 pages of this report and just trap on the last 2". That is my main question. Absent of being able to do that, I guess I need to figure out how to just trap the summary data without getting the detail.

Here is a sample:




ABC CO., INC.

AGE DES COMPTES A RECEVOIR (DATE PERIODE : 03/09/18) SAB-21021 PRODUIT LE 03/09/17 A 21:30:40 PAGE 3957

AGENT CREDIT : ELISABETH BATISTA

FACTURES DESIREES : 0 jours et plus.
CD ST AGE 0-10 11-20 21-30 31-60 61-90 91 et + %
------------------------------------------------------------------------------------------------------------------------------------
SABT01549 SMITH MANAGEMENT SERVICES, INC. SOLDE : 1,408.00
57989 AUBURN (WA), Fax: 206 555-2042 EN COURS: 0.00 1
BILLY GWIN, 206 555-8729 0.00 0.00 0.00 LIMITE : 100,000.00
0.00 0.00 1,408.00 TERMES : jr
Derniere remise: 1,358.00 le 03/08/19 Corp : 776
Paiement moy: 20 jrs,
BN5500 3-724033 3-724033 03/05/02 1 139 1,408.00
------------------------------------------------------------------------------------------------------------------------------------
SABF01015 XYZ FREIGHT SERVICES (FINANCE) SFO SOLDE : 615.09
46485 SAN FRANCISCO, CA 94105, Fax: 713 555-6850 EN COURS: 0.00 0
ESTER'S TEL: 1(415)555-0396, 415 555-8360 0.00 0.00 310.88 LIMITE : 100,000.00
0.00 0.00 304.21 TERMES : 999 jr
Derniere remise: 61,947.81 le 03/01/14 Corp : 776
Paiement moy: 41 jrs, "25K"
DE6724 3-856763 VAI36357 03/06/10 1 100 153.41
DF3033 3-908611 VAI36397 03/06/11 1 99 150.80
DL6401 3-983389 3-983389 03/06/26 1 84 152.25
DL6402 3-983297 VAI36413 03/06/26 1 84 158.63
------------------------------------------------------------------------------------------------------------------------------------
SABF00399 ATX FREIGHT SERVICES - (ABCD) SFO SOLDE : 6,845.12
29777 SAN FRANCISCO, CA 94105, Fax: 415 555-9370 EN COURS: 0.00 6
Yolanda Downs (415) 555-9334, 415 555-8200 0.00 0.00 0.00 LIMITE : 100,000.00
3,430.91 3,414.21 0.00 TERMES : 999 jr
Derniere remise: 3,506.13 le 03/08/14 Corp : 776
Paiement moy: 44 jrs, "25K"
ED5944 3-128300 3-128300 03/08/08 1 41 3,414.21 Usd
EM5659 3-128300 3-128300 03/09/03 1 15 3,430.91 Usd
------------------------------------------------------------------------------------------------------------------------------------
SABF01539 OXY FREIGHT SERVICES, INC. ( ORD ) SOLDE : 5,378.12
60301 BENSENVILLE, IL 60106, Fax: 603 555-0146 EN COURS: 0.00 0
0.00 0.00 1,689.67 LIMITE : 0.00
254.00 2,355.01 1,079.44 TERMES : 1 jr
Derniere remise: 95.00 le 03/01/31 Corp : 776
Paiement moy: 39 jrs, "COD" C.O.D.
652442 3-237071 03/01/31 3 230 -95.00 Usd
BB0530 3-504218 VAE02082 03/04/04 1 167 476.00 Usd
DH0791 3-736471 VAE02146 03/06/16 1 94 281.78 Usd
DH2982 3-787681 VAE02169 03/06/16 1 94 416.66 Usd
DS9840 3-865116 VAE02197 03/07/14 1 66 604.27
DT0167 3-864856 VAE02197 03/07/14 1 66 1,085.40
EB4981 3.189273 3.189273 03/08/06 1 43 844.55 Usd
ED7129 3-988668 VAE02224 03/08/10 1 39 1,510.46 Usd
EL4933 3.144411 VAE02302 03/08/29 1 20 254.00 Usd
------------------------------------------------------------------------------------------------------------------------------------
TOTAL AGENT 4 CLIENTS : 0.00 0.00 2,000.55 SOLDE : 1424633
3,684.91 5,769.22 2,791.65 EN COURS : 0
ABC CO., INC.

AGE DES COMPTES A RECEVOIR (DATE PERIODE : 03/09/18) SAB-21021 PRODUIT LE 03/09/17 A 21:30:40 PAGE 3958

SOMMAIRE PAR AGENT

FACTURES DESIREES : 0 jours et plus.
CD ST AGE 0-10 11-20 21-30 31-60 61-90 91 et + %
------------------------------------------------------------------------------------------------------------------------------------
JEAN HAYES 4,254.75 2,535.88 -1,929.00 SOLDE : 10766750
6 CLIENTS 3,094.34 2,026.07 97,685.46 EN COURS : 795575
------------------------------------------------------------------------------------------------------------------------------------
WERNER KESSLER (cass) 10,927.23 167.99 -175.63 SOLDE : 1157671
10 CLIENTS 76.76 449.24 131.12 EN COURS : 4000
------------------------------------------------------------------------------------------------------------------------------------
AVOCAT MONTREAL 0.00 -458.11 0.00 SOLDE : 2670439
6 CLIENTS 190.48 -86.27 27,058.29 EN COURS : 0
------------------------------------------------------------------------------------------------------------------------------------
AVOCAT TORONTO 0.00 0.00 0.00 SOLDE : 131329
1 CLIENTS 0.00 0.00 1,313.29 EN COURS : 0
------------------------------------------------------------------------------------------------------------------------------------
BIBI RICKETTS 6,250,479.30 1,579,072.02 60,748.45 SOLDE : 1034286514
271 CLIENTS 1,685,554.51 631,816.90 135,193.96 EN COURS : 376320992
------------------------------------------------------------------------------------------------------------------------------------
RICK FLINT 4,511,997.56 3,211,645.82 98,902.40 SOLDE : 1150398887
270 CLIENTS 3,003,847.65 570,969.63 106,625.81 EN COURS : 244254698
------------------------------------------------------------------------------------------------------------------------------------
TIMUR TUNCKOL 1,946,047.47 1,027,564.70 47,828.98 SOLDE : 430854744
309 CLIENTS 920,363.82 308,830.41 57,912.06 EN COURS : 153210121
------------------------------------------------------------------------------------------------------------------------------------
WAIKI CHAN 7,644,966.69 2,467,582.92 128,424.65 SOLDE : 1492338692
71 CLIENTS 4,385,176.41 298,530.28 -1,294.03 EN COURS : 409204069
------------------------------------------------------------------------------------------------------------------------------------
ENO GLIOZHENI 3,382,683.46 1,523,422.04 188,766.88 SOLDE : 793723786
283 CLIENTS 1,809,470.05 964,223.27 68,672.16 EN COURS : 309213184
------------------------------------------------------------------------------------------------------------------------------------



[ September 24, 2003, 01:12 PM: Message edited by: Mike Urbonas ]

[Data Kruncher]

Richard,

I think you're better off creating a new model to capture your summary data only.

To capture the summary data only, start by highlighting the first two rows of data in the summary section (in your example these are the lines for JEAN HAYES). Create a new detail template. Put an alpha trap in column 1, and SOLDE starting at column 109.

Because the word "CLIENT" floats on the line as counter increases, you may need to trap the whole phrase, then use a calculated field to strip out the actual value. Let us know if you need help with this.

Sandy

[Grant Perkins]

Richard,

Don't worry too much about where the data are in the report - even if it is right at the end if that is the only place it exists then go for it there. Nothing much to be lost except a larger than necessary file on a disk somewhere.

What are the options? Can you get a summary only version of the report to use as a source?

Alternatively copy the last few lines of the report to notepad or wordpad and save as a text file, then use Monarch on that.

The template traps look like a bit of a challenge if you leave everything a 3000+ page report as there is some similarity of format with detail type lines above. I do see a few odd inconsistencies but can't be sure they are 'real' after the paste into the forum.

What sort of problems are you getting with the missing detail fields? Do you need to fix that? Your original post seemed to suggest that you only wanted to get to the summary section - hence the problem with the trap.

I will have a look at the sample and see if it offers a trap for the summary section exclusively.

Grant

Edit:

I have just seen Sandy's post. I agree, except that it looks possible that some of the lines in the detail section can be selected sometimes.

However if you also make one or more of the decimal point columns, that appear in ther first of the two lines you want, part of the trap you should get only the summary rows at the end of the report.

The suggestion about the CLIENTS count is good observation from Sandy. Easy to miss that!



Originally posted by Richard Corby:
The report is quite large. Each customer is assigned an employee. The report contains detail by customer, and then at the very end, a summary by employee.

I have one Model which pulls all of the detail (although it is missing some and I need to figure out somehow how the trap is missing the data). I then want another model which traps the summaries at the bottom.

I could not figure out how to just trap the summaries at the bottom, so I figured there must be a way to tell Monarch "ignore the first 3000 pages of this report and just trap on the last 2". That is my main question. Absent of being able to do that, I guess I need to figure out how to just trap the summary data without getting the detail.

<snip sample report >



[ September 18, 2003, 01:05 PM: Message edited by: Grant Perkins ]

[Richard Corby]

I think I found a new favorite forum...lot's of good and fast responses...thanks.

I will settle for two models, one for detail and one for summary. Was able to trap both successfully and particularly liked the idea about using a calculated field to get number of clients!

Thanks again.

[Grant Perkins]

Richard,

If you do want detail and summary in one selection that looks possible. The Summary pages at the bottom of the report look like they are simply repeats of the summaries by Agent in the body of the report. (2 rows for each Agent starting at " Total Agent").

I can't be absolutely sure of that as the Agent for the detail records does not appear in the summary as posted.

But if I guessed right and you would like to extract everything in one pass let us know and we can look at that some more. I was working on your original statement that you only wanted the summary stuff at the end of the report.

Grant


Originally posted by Richard Corby:
I think I found a new favorite forum...lot's of good and fast responses...thanks.

I will settle for two models, one for detail and one for summary. Was able to trap both successfully and particularly liked the idea about using a calculated field to get number of clients!

Thanks again.

[ September 22, 2003, 06:18 PM: Message edited by: Grant Perkins ]

[Mike Urbonas]

Hello all,

I think the key to producing a single model is to capture the words "SOMMAIRE PAR AGENT" which I believe identifies the Summary section of the report.

Try this: begin with the model you have so far, which captures the summary data you want, but also some detail lines you do not want.

Create an Append Level trap that looks for "SOMMAIRE PAR AGENT". Paint a field to capture "SOMMAIRE PAR AGENT" as a data field (let's call this field "FindSummary".)

Now go into the Monarch table view. I believe the FindSummary data field will display "SOMMAIRE PAR AGENT" for the summary lines, and will probably be blank for any other lines.

To display only the summary lines in your table, define a Data Filter with this formula:

FindSummry="SOMMAIRE PAR AGENT"

And that should do it... smile.gif

You could say this is a practical example of using "metadata"...which is "data about the data." smile.gif This solution lets us identify what data lines are summary lines. Often, a page header or report heading/subheading will provide this kind of information. Try to capture such data as its own data field, using an append or page-header template. You can then use that data to filter out the data you don't want in your Monarch table.

Mike