I am using a sql server stored procedure x as the data source for a report .
It has one parameter as
x param1(datetime of sql server)..
so when I use this as my data source the parameter pops up with time factor also. Is there any way I can avoid it ..other than using the datasource as "exec x param1".