Reporting MOND data

Question

Hi all, I'm in the process of converting a clients gINT system from AGS3 to AGS4. Data template all done as are the logs etc. I then came to do their monitoring data, and realised that it's one I haven't done for anyone before. I set up their Graphic Table report to duplicate their original i.e. columns for BH, Date / Time, CO2, O2, CH4, H2S, Flow and Water Depth etc. Pulled in all the relevant Table Text entities, set the Output Conditions to only report the relevant reading. I populated a test project with some readings and outputed it. Much to my horror (and that of my client) each reading is coming out on a separate line i.e. there's a separate line for each O2 reading, each Water Depth reading and so on. 
 What I'm after is to have each data / times worth of readings to output on the same line, mainly for the readers sanity, and partly to save a small rain forests worth of paper. If they take 6 different readings each round of readings for 10 BHs, that should be 10 lines on the output, not 60 (if this is translated to a hundred or so BHs with months of monitoring, it would generate 10s if not hundreds more pages than are necessary). I have tried a variety of things, all to no avail (I even checked this behaviour with a Text Table report... the same result) 
 . Is it me or am I missing a way of doing this

Kirk Johnson · Accepted Answer

Actually I think I know what it might be. Since you are calling in multiple tables, I bet your point ID expression is for a specific table something like <<MONG.PointID>>

Try just using the System point id expression in the point id text expression of the text table. <<PointID>>

Kirk Johnson · Answer

Hi Miles, 
 
 We don't have a graphic table report for that, but I just made a small example based on what you described. I assume the data you are pulling in comes from the MonD table. In AGS 4 the Keyset of the Monitoring tables are different than before. 
 
 I set the report properties to match the keyset of the MOND table which is POINTID, ItemKey, Datetime

I also set the report properties to consolidate Rows, which is found in the report structure tab.

Lastly here is the output it will consolidate results from the same date/time

Reporting MOND data

Top Replies