Date in Report Parameters
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
November 17th, 2010 9:35am

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)
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 10:16am

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
November 17th, 2010 11:20am

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
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 9:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics