Format and Conditioning Parameters

Hi;
is there a way to format parameter's input? (I.E. a date that only permits
Month and Year - MM/YYYY- ), and conditioning the input on one parameter
based on the input on another?
TIAOn Mar 17, 12:09 pm, "Willo" <willobe...@.yahoo.com.mx> wrote:
> Hi;
> is there a way to format parameter's input? (I.E. a date that only permits
> Month and Year - MM/YYYY- ), and conditioning the input on one parameter
> based on the input on another?
> TIA
You can use a query or stored procedure that returns a dataset like MM/
YYYY for the report. Also, you can base one parameter on another. When
you create the second parameters dataset, you can include a variable
that is assigned by the first parameter. When creating the dataset,
select the edit Selected Dataset button [...] and select the
Parameters tab and enter the variable name on the left and the
expression used on the right (something like =Parameters!
Parameter1Name.Value should work). Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer