Hi there, Given up now on reading through the threads on the part that I am stuck at. Managed to build a report to exactly how I want. Just need to add one more thing before i can deploy my first report to the public! I have a list of invoices that i have managed to pull through. I have only one Date field (Bill Date) and I want to give the option to a user where it will only return invoices before a given date. For example, if we wanted to show invoices outstanding before 01/01/2010 the user just as to enter the data or even <01/01/2010. Any suggestions on how to achieve this? Thanks J

Use a parameter of date type for them to select, then use the value of that parameter in your dataset query.Dave Frommer - BI Architect Slalom Consulting (www.slalom.com)

Create a parameterized report. In yr. query in where clause write something like where table.date = @parm_date. At run time user will be asked to pass the date i hope that’s what you are looking for. thanks,SSRSRpt

Many thanks David and Pratul_sri, it worked a treat. When I put the date in, annoyingly I have to put the date in backwards which is impractical. How do I get round this?ie 2010-06-30 I have used Pratul_sri's method and basically added <=@Bill_date I figure there must be some conversion in the background where if a user enters in 30-06-2010 - a conversion can take place? =format(cdate(Fields!Bill_Date.Value),"dd/MM/yyyy") Cheers :) J