On Thursday, December 29, 2011 11:59:18 AM James Bull wrote:

> Thanks, I have created the sql manually and although not an experienced user

> of sql think I am on the right track. The UI displays exactly want I want

> by using a number of grids to display the child tables of allergies and

> medications; that was no effort at all given how user friendly dabo is.

> Trying to produce a report containing that same information is what has me

> confused right now. I am sure there is a simple solution which I cannot see

> yet. regards

> james

>

What database engine are you using? Post the SQL (along with the bizobj) for

us to read and maybe we can help.

If you have the SQL right then it is a matter of creating and using variables

or just grouping in the report.

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com

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/10195755.yrl5iflvWh@linux-12