Developer forum

kim@occinnovation.dk wrote:

Hi

 

I was working with database publishing and came to a problem.

 

I have a list over schools from different countries and I would like to divide them in groups, where each group represents a country. At the moment are they primary sorted by country but I really need them seperation.

 

What I have:

 

China - School Name

Denmark - School Name

Denmark - School Name

Denmark - School Name

Sweden - School Name

 

 

 

But I want:

China

School name

 

Denmark

School name

School name

School name

 

Sweden

School name

 

-----

 

I use a Acces Database, and I tried to write me out of it, in the SQL sentence but with no luck. Anyone who has some suggestions?

 

-kim

Hej Kim
 

I think you would have to do that by using javascript in the template...

One option could be talking a look at http://www.extjs.com/ - maybe a little overkill, but they have a javascript control which can print out a list with grouping - like you know it from Outlook.

Thank you for your quick reply and great inspiration. Didn't use the example, but made my own script where I eliminate recurring posts.