Microsoft Dynamics RMS (Archived)

Passing parameter to RMS Report Query

(0) Share

Report

Posted on by Shibani

Hello,

Need to filter the Items not sold in a given time duration and populate the records on RMS report.

We can select the duration for filtering the items on report of Store Operations Manager.

Question:

Can we pass the parameter of start date and end date to the query in 'TablesQueried' of ReportSummary section of RMS report while selecting the time duration filter?

Please suggest.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Passing parameter to RMS Report Query

You most likely need to create a column for each; startdate/time and enddate/time. Set the column to be hidden if you don't want them to show on the report.

The report uses the columns to filter.

You can also use the " SelCriteria = " part of the report. this acts like a where clause in sql server query.

Most importantly though is the actual query under the "TablesQueried =" because RMS doesn't track what has NOT been sold, only what has been sold. But you could use the item table and use the lastsold column to see when something was last sold.

I think that will get you the information you need, I am assuming you are looking for slow movers so that you can return or clearance those items.

Let us know if you need more help.
Shibani 90 on at

Like (0)

Report

RE: Passing parameter to RMS Report Query

Thanks for the input; but I want to pass the selected time duration (while setting filter in report opened in Store Operations Manager) as parameters to the stored procedure\query in TablesQueried in the report at the run time.

Please let me know how to achieve that.
archelle16 1,735 on at

Like (0)

Report

RE: Passing parameter to RMS Report Query

Someone suggested this to me. You can use either Active or Crystal Report. In Active Report use PreQuery1. For example: PreQuery1 = "EXEC [your stored procedure name]" You can refer to your customization guide for further reading. I hope this helps.