You’re offline. This is a read only version of the page.

Microsoft Dynamics SL (Archived)

Pass date parameters from Dynamics screen to stored procedure dataset in SSRS

(0) Share

Report

Posted on by Prathima

I am having trouble passing parameters from Dynamics to stored procedure dataset in SSRS.

I have the stored procedure that accepts endperiod as parameter.

For example, my dataset query is: sptestparameters @endperiod

To pass the value for @endperiod, I set the default value in the SSRS parameters sections as code.RIPARAM("endpernbr").

When I try to run the report, it just crashes. Does Dynamics SL2011 support parameters in SSRS report?

If so, what is the logical method to pass values from Dynamics to parameters in SSRS report?

Thanks,

Prathima

*This post is locked for comments

I have the same question (0)

All responses (0)

Answers (0)

Helpful resources

Last 30 days Overall leaderboard