Thanks Dave,

I put it into the correct row and recieved the desired results. I'm afraid I am self taught on SSRS so am having to learn as i go along.

Jay_Noob thanks for your reply. My query will not always return four rows it can be any number of rows but what i would like is that whatever the number...

Thanks ManicStar, this does the job, just what i needed..

Thanks. you've saved me some serious time.

Hi Guys,

Thanks for your reply and the queries provided but I don't think I was clear in my explanation on the table data.

The description field may be text of...

Thanks Jerry,

I have altered my script to make it one dataset however I still think it is a limitation of reporting services as it should be able to do something...

Hi Guys,

Thanks for your help. I guess my initial explanation didn't really explain it so here goes with some date example:-

col=ID===Pagin=====IssueDate=============PressStart===

1=1489==56==2008-10-10 00:00:00.00======2008-10-10 10:06:00.00

2=1489==56==2008-10-10 00:00:00.00======2008-10-10 10:20:00.00

3=1489==56==2008-10-10 00:00:00.00======2008-10-10 11:40:00.00

4=1489==70==2008-11-11 00:00:00.00======2008-10-11 12:05:00.00

5=1489==70==2008-11-11 00:00:00.00======2008-10-11...

Select max date option only gives me one line. I am looking for three rows one for each date between the 10th and 13th or whatever dates will be input....