prompting for date range parameters with Report Builder?

Hot Topic

mysql limit equivalent
error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0
Return the data from a table ordered by its hierarchy
SQL Browser service won't start
Date Comparison in Stored Procedure
Upgrade from SS2005 GA to Service Pack 1-how critical is it?
SQL Server 2005 Remote Connection Problem... Big Time.
sending "Empty string" to a textbox on the report
locking semantics on sys.transmission_queue
profiler can't save trace to file

SQL Server

Can't Design a Script
Row numbers on export
DECODE Statement
Join Dates....help!
Registry to store configuration values ?
Cannot complete Install of Express
Dynamically edit DataSet
SQL Looping for Complex Query
slowly changing dimension task problem
how to activate product

prompting for date range parameters with Report Builder?

Hello,
 







I am trying to create a report using Report Builder (not Report Designer) that prompts the user for a Date range to filter on.  The problem is that once I change the filter to be a "From...To" parameter, it removes the "promptable" green question mark icon from the filter condition.  I can't click on the field and get the "Prompt" option either.  I only see "Edit As Formula" and "Remove Condition" in the context menu when I set the date filter to a "From...To" filter.  Is this a limitation in Report Builder   
 


I have found that by using both the "On or After" And "On or Before" I can mimick this functionality, but I can't control how the prompts are displayed. Assuming my Date field is called "Created Date", it sets the prompts to "Created Date" and "Created Date1".  ---Is there a way to define the prompt text (again I am using Report Builder)    
 

I have been posting many questions to this newsgroup, with not much help.
  

Any and all input is appreciated!!!
 

Thanks!!
 

-Brian



Answer this question

prompting for date range parameters with Report Builder?

  • Mickael Provost 44

    Unfortunately, this is a limitation in Report Builder (in combination with the server). As there is no "range" type for parameters, you will need to use two parameters, as you noted. In RB, the captions for the parameters are automatically generated from the field name so you will see one of them with a 1 appended onto the end.

    The only workaround I can see is to add two attributes to the model, one named Begin Date and one named End Date. They would be the same expression but could be used independently.



  • Vladimir Radovic

    Report Deisgner has the same limitation. There is no built-in range. You could create a multi-valued parameter where the first value (Parameters!Date.Value(0)) was the start and the second value (Parameters!Date.Value(1)) was the end. However, there is no range checking or special UI for this.



  • Rasheed Shaik

    This is covered in another post but create two custom fields Created Date From and Created Date to set these up as on and after, on and before respectively. Then specify prompt and should work fine. Dont know why it gives you the option to rename the parameters if this doesnt rename the parameters!

  • tommcd24

    Does Report Designer also have the limitation of not allowing for prompting of "range" parameters

    I see that I can name the parameters how I like in Report Designer, but still no ability for range parameters (i.e. one parameter that holds a start date and end date)...



  • prompting for date range parameters with Report Builder?
Answer this question