Re: [dabo-users] Reports

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: Dabo-users@leafe.com