开发者

Non queried parameter - different behaviour SQL Server 2005, SQL Server 2008 R2

I have a report, which has a report parameter with the following prope开发者_如何学运维rties:

  • hidden
  • allow blank value
  • non queried
  • default value ( non-queried ) : dd/MM/yyyy

Report is started using the ReportExecution2005.asmx webservice.

  • On SQL Server 2005, the web service runs the report without problems.
  • On SQL Server 2008 R2, the web service returns an error:

This report requires a default or user-defined value for the report parameter 'datumformaat'. To run or subscribe to this report, you must provide a parameter value.

Can this be fixed somehow, to have the same behaviour as SQL Server 2005?


Parameter contained a null value, which was causing the error

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜