Simple group question

[leveetated]

Hi experts,

CR 8.5/SQL Server 2000. I thought I knew how to do this but I've been pulling my hair out, I'm stuck!

I want to print out basic book information, like so:

Author 1 Name
Author 2 Name (if exists)
Book Title
Place Published, Dated


The problem is that instead of the above format, I get 2 individual blocks of data for books with > 1 author, like so:

Author 1 Name
Book Title
Place Published, Dated

Author 2 Name
Book Title (same as above)
Place Published, Dated (same as above)


...any experts shake my noggin a bit?? I know this is simple. Grouping on the author isn't working and neither is anything else I've tried...

Many many thanks, cheers!

 

[raja2008]

Are all the fields coming from the same table,Are you grouping on anything,how you are pulling the data and what fields do you have in the report and where.
Please explain in detail.

 

[leveetated]

SQL Server 2000 w/ODBC connection. I'm pulling from 2 tables, authors (left outer join) and books. I have fields authors.displayname, books.title, books.publocation, books.pubdate.

Simple stuff, I know this has to be obvious, I'm just missing it here...

many thanks