single item to be displayed in crystal report

[gerchi152]

I have 3 columns in my database (book title, book author, date added). for example Karen Harper has 5 books in my database and Lisa Jackson has 3. I will enter the date added in a textbox (for example 01-15-2011 since all was added on that date) and once I click "show book author's name" my crystal report will display Karen Harper 5 times and Lisa Jackson displays 3... How can I can display it once?

[M.Waqas Aslam]

hello!
you have to use group on author name ,now there are two possible ways to perform this action ,1-use crystal report groups for this (i not recommend it) and no 2nd is try to use view and in your view group on author name .you want to show your report in this way ?

authorname
  1-book title   addeddate
  1-book title   addeddate
  1-book title   addeddate
  1-book title   addeddate
  1-book title   addeddate
authorname
  1-book title   addeddate
  1-book title   addeddate
  1-book title   addeddate
  1-book title   addeddate

if yes then you have to use crystal report group function .
or if you want to show your records like this

authorname addeddate totalbooks
authorname addeddate totalbooks
authorname addeddate totalbooks
authorname addeddate totalbooks

then it is better to use the view .

[gerchi152]

I don't have any idea about the view function... can you help me with that?