I have a report that takes 2 optional parameters, one int and one datetime.
My data tab is set up as follows: CommandType = Text, Parameters has Parameters.Value etc. for both.
Report Parameters are allowed NULL value, Default Value is NULL, datatypes are Integer and Datetime as well.
This only runs when the parameters are not supplied values, when I enter a date, it does not take it into account, same for the int value.
I have run the proc manually to verify that the query is set up correctly, it seems like the values are not being passed?
Any help debugging this would be helpful.
View Complete Post