Groups | Blog | Home
all groups > sql server reporting services > may 2005 >

sql server reporting services : Report Design help for Newb - Regarding Date Paramaters


tdodd
5/24/2005 8:58:03 PM
I have been trying very hard for days now to build a report using VS 2003.net
I just need to query an order table by a date range. ie) from date a to
date b. The order table contains PO's and have recorded dates. I just need
an example of how to report based upon date range. Seems simple enough,
Mike G.
5/25/2005 5:13:50 PM
I assume you mean you want the user to be able to specify the date range?

If you currently have a sql statement that returns all orders and have a
report that displays that data, simply modify the sql statement and specify:

where datefield between @startdate and @enddate

That will automatically create report parameters. When you preview the
report, it will prompt you to type in start and end dates.

For more info, just do searches for query parameters and report parameters.

Mike G.

[quoted text, click to view]

AddThis Social Bookmark Button