Using gINT V10 Professional and Data Template gint std ags 4_0
Is there any way of being able for readings to be searched for and then placed across a table in Graphic Tables design.
Example - We only want the water depth data for 5mins to be shown in the 1st column, 10mins to be shown in 2nd column, 15mins to be shown in 3rd column and 20mins to be shown in 4th column even if other times have been recorded.
The table would have to allow multiple water strikes from each record and multiple records to a page.
My apologies if the answer is obvious
I am not familiar with the AGS data structure or standard templates so this may or may not help. A lookup function should probably work here but it will depend on the key sets of your tables and the key set selected for the report. The lookup function would look something like: <<LookUp(<<WSD.Strike_Depth>>,<<WSD.Time_After>> = 5)>> This should return the depth associated with the 5 minute reading. Your actual table and field names would be replace my made up names. Depending on the key fields set in your report and how you want the results grouped, the where clause of the lookup may have to be more complex. note this would only return the exact match for a reading of 5 minutes. If the user entered readings at 1,4, 9, 11, 22 minutes nothing would be returned. You may want to get around this by using the interpolate function. <<Interpolate(<<WSD.Strike_Depth>>,<<WSD.Time_After>> = 5,"A","A")>> This should return a value so long as there are entries <= and >= the requested value in the table. Note that it should return the actual reading if there is a reading at the specified time the same as the lookup function. Interpolation can be arithmetic semi-log or log-log. Again, these are just some thoughts that you may want to explore. I have not tested these answers and do not guarantee that my syntax or usage is correct.