(Which I do!)... (See http://forum.openoffice.org/en/forum/vi ... 42&t=91167% for how that was done.)Goblet of Fire
Moby Dick
-- Rockwell illustrations
Seven Pillars of Wisdom
The Hobbitt
-- Second edition
The Spire
Winnie-The-Pooh
Yearling
-- Pristine dust jacket
The query scans a table with a book inventory. The table has "Title" and "Comment" fields. The query always produces a line in it's output table for every title. It also, but only when there is something in the Comment field, it produces a line with the comment, pre-fixed with '--' (Which is not anything to do with using "--" to put a comment in some SQL... it just seemed a good idea at the time as a way to distinguish a comment line.
So... according to the sample above, there is nothing in the Comment field for the Goblet of Fire record, but ther IS ("Rocwell Rockwell illustrations") for the Moby Dick record.
Whew! That's the context.
I'm hoping someone can help me do...
I want a report with the title names in one style (font-name/ size/ color, etc), and the comment lines (if any) in a different style.
Maybe the "--" at the start of each line helps... of maybe not, maybe a completely different approach is needed?
I'm hoping all this can be done under OO 4.1.1, using the embedded HSQL engine. (Apologies.. earlier that said "4.4.1"... checked it TWICE, still got it wrong!)