The detail row visibility setting is as followed

Hidden: an expression is there

Toggleitem: based on previous row, textbox id

This detail row is hidden when viewed in report viewer but when exported...

Thank you

Thanks Jason , I'll try out your suggestion and get back with you

there can be only 1 enrolled_date for book_visited.

Book_visited is a value.

However, for an author and book_name there can be many enrolled_date and book_visited.

I determine the new row of...

I already have the below mentioned base table populated with data.

Create table booksdata(

date_enrolled [datetime],

book_name varchar(50),

author_name varchar(100),

book_visited float

)

The data in this table is like,

date_enrolled book_name author_name book_visited

04/12/2008 ...