ASP.NET and Report Server - some help needed!

Hi All:
I'm new to RS and have been doing my reading to try and understand this
better. I'd like to know if its possible to do the following:
I have a SQL database that has a couple of thousand records, with columns
such as Name, Date, Cost. I'd like the user be able to generate reports
based on the selecting Date and Cost.
For example, show me all names where date > # and cost < $x.
I did go thru the tutorials etc, but could not find one where a report is
generated based on user input (without me having to create the SQL statement
at design time).
I'm quite sure I'm missing something here or am yet to find the
documentation that will let me do this! Any help/pointers will be much
appreciated.
TIA
VinayVinay,
Take a look at parameters in Books Online. That allows one form of
user input into report rendering.
Andrew Watt
MVP - InfoPath
On Mon, 17 Oct 2005 17:28:29 -0700, "Vinay"
<vinay_hs_removethis@.nospam.yahoo.com> wrote:
>Hi All:
>I'm new to RS and have been doing my reading to try and understand this
>better. I'd like to know if its possible to do the following:
>I have a SQL database that has a couple of thousand records, with columns
>such as Name, Date, Cost. I'd like the user be able to generate reports
>based on the selecting Date and Cost.
>For example, show me all names where date > # and cost < $x.
>I did go thru the tutorials etc, but could not find one where a report is
>generated based on user input (without me having to create the SQL statement
>at design time).
>I'm quite sure I'm missing something here or am yet to find the
>documentation that will let me do this! Any help/pointers will be much
>appreciated.
>TIA
>Vinay