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

All responses (0)

Answers (0)

Helpful resources

André Arnaud de Cal... 292,688 Super User 2025 Season 1

Martin Dráb 231,643 Most Valuable Professional

nmaenpaa 101,156 Moderator

Leaderboard