Microsoft Dynamics SL forum

Unanswered

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

All responses (0)

Answers (0)

Helpful resources

André Arnaud de Cal... 290,554 Super User 2024 Season 2

Martin Dráb 228,588 Most Valuable Professional

nmaenpaa 101,148

Leaderboard