On Sunday, January 01, 2012 08:56:46 AM James Bull wrote: > Thank you for your help, > I have tinkered with grouping but never quite got what I was looking for, > probably not understanding groups properly. Have done as you suggested, > this results in an appropriate list for allergies, but the medication is > repeated twice (once for each ?item in the allergy band) eg. > -allergy 1 > - med 1 > - med 2 > - allergy 2 > - med 1 > - med 2 > > what I am looking for is > - allergy 1 -med 1 > - allergy 2 -med2 > -med3 etc > medication list tend to be much longer than allergies. > > Does each new group nest below the group immediately above? or could the top > level group have two groups directly below? -does this even make sense? > > I presume rw.Cursor can only be run once for a report, in other words one > cannot run separate sql queries and append the data for each run to same > report? > > Again, thanks for your help and such an excellent framework, > All the best for the new year, > james
You know you can have more than one grouping. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/1820206.ghaprc96aV@linux-12
