i have 3 parameter in sp ,that is compulsory .
but in my report i just need to show only 1.the other 2 param doesnt allow null value.
but i cant run my sp without other 2 param. so cant run report without those two.
what is the solution ?
Make the other two hidden with default value.
what default value do i need to put,its does not take null .
and i cant pass anything in this two,report wont show data
Am i getting it right?
1. Your SP has 3 parameters - all of them must be not null
2. In your report you want to give user to choose only 1st parameter, other two must be constant.
In this case I offering to create tree parameters, one of them visible and can be chosen by user,
two others you make hidden with one you hardcoded available value and this value made default.
If requirements are wrong - please explain