Tuesday, March 20, 2012

Reports run automatically w/ Allow Null parameters?

I wrote a stored procedure with two paramters, both of which are nullable but
both should not be null at the same time... it is either one or the other...
if both are null then I return an error from the stored procedure.
So now I am making the report to use this stored procedure.
When I click the "Allow null value" checkbox for both report parameters, the
report run automatically without waiting for the user to click the "View
Report" button! This creates a situation where if the user navigates to the
report using the Report Manager web application, then it will always first
give an error and then the user can enter a value and re-execute the report.
Is there some way to ALLOW null but not ASSUME null? I would like the user
to see the textbox for typing the parameter values and also see the unchecked
boxes for nulls.
PS: Both report parameters currently have the "None" as their default value.I have the exact same problem. Anyone find a solution for this?
"Al" wrote:
> I wrote a stored procedure with two paramters, both of which are nullable but
> both should not be null at the same time... it is either one or the other...
> if both are null then I return an error from the stored procedure.
> So now I am making the report to use this stored procedure.
> When I click the "Allow null value" checkbox for both report parameters, the
> report run automatically without waiting for the user to click the "View
> Report" button! This creates a situation where if the user navigates to the
> report using the Report Manager web application, then it will always first
> give an error and then the user can enter a value and re-execute the report.
> Is there some way to ALLOW null but not ASSUME null? I would like the user
> to see the textbox for typing the parameter values and also see the unchecked
> boxes for nulls.
> PS: Both report parameters currently have the "None" as their default value.
>

No comments:

Post a Comment