Help with relevance

Reporting
1

(imported topic written by SystemAdmin)

I’m trying to get a report that will list the names of the bes custom sites and in the next columns list the writers and readers of those sites. The clause below does just that but… the format the results come back in is not exactly what I had in mind.

(name of it, names of writers of it, names of readers of it) of bes custom sites

The results look like this:

site1,writer1,reader1

site1,writer1,reader2

site1,writer1,reader3

site1,writer2,reader1

site1,writer2,reader2

site1,writer2,reader3

and on and on and on…

What I’d like is this:

site1, writer1, reader1

writer2, reader2

writer3, reader3

site2, writer1, reader1

etc…

or

site1

writers,readers

site2

writers,readers

Does that make sense? Is there anyway to write the clause to do this?

-Baraq

2

(imported comment written by Lee Wei)

Maybe this will work for you.

(name of it, concatenations 
", " of names of writers of it, concatenations 
", "  of names of readers of it) of bes custom sites

(        html 
"<table border=1><th><tr><td>Site</td><td>Writers</td><td>Readers</td></tr></th>" & it & html 
"</html>") of concatenations of trs of (td of name of it & td of concatenations 
", " of names of writers of it & td of concatenations 
", "  of names of readers of it) of bes custom sites

Lee Wei

3

(imported comment written by SystemAdmin)

Ok Lee, when I grow up I want to be just like you:)

thanks, that worked great.

-Baraq