Hi All,

I need to display a same datafield twice on my report with different conditions. When i drag and drop the same field twice on the report. I want a way to define different conditions for both these field.

I am using MS Access and Crystal reports 8.5 version. the front end of my project is Visual Basic 6

eg: I have three tables: BookMaster (Table 1) with bookId as primary key and bookName as additional field, AuthorMaster (Table 2) with authorId as Primary Key and authorName as additional field; bookAuthor (Table 3) which consists of bookId and authorId as foreign keys and authorType as text field (the field authorType is given because i need to show who is the primary author and who is secondary author). The bookAuthor table has two authorId for the same bookId. One primary author and other secondary author. (Real life scenario where same book have multiple author).

I need to display the names of primary and secondary authors for all the books in BookAuthor table. Like: book id, bookName, primaryauthorid, primaryauthorname, secondaryauthorid, secondaryauthorName row by row. Each row displays one books

I did the following steps: I created the relationships in visual table linking and then I created a group with bookId from bookAuthor and then draged the datafield authorId, authorName twice for primary and secondary author. But the report displays the same author name for the book.

I am in deep trouble due to this.

Can some one help me how to achieve this.

You only need to have the author name once.  If you want the primary and the secondary to show on the same line, you'll have to do something like this:

1.  Create a second detail section.  Put the author name in this section so that it is NOT under the author name in the first detail section. (We're going to line them up side-by-side.)