Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Is it possible to appl...
Microsoft Dynamics RMS (Archived)

Is it possible to apply the filter selected in ProcedureCall, Prequery1 or Prequery2 in Active report?

(0) ShareShare
ReportReport
Posted on by Don C.

Hi,

I'm new in customising RMS reports, I just want to know whether it's possible to apply the filter selected in ProcedureCall, Prequery1 or Prequery2?  If not, is there a way to read or capture the values of the filter selected in Active reports or Crystal report before rendering the report?  The main idea is to create a temporary table as a source for the report but I need to capture the filter values in order to generate the correct result for the temporary table.

Thanks in advance.

*This post is locked for comments

  • Don C. Profile Picture
    Don C. on at
    Re: Is it possible to apply the filter selected in ProcedureCall, Prequery1 or Prequery2 in Active report?

    Thanks, now my doubts are cleared.  The reason I asked this is because I am unable to generate the report described in this post: community.dynamics.com/.../177011.aspx.

  • Verified answer
    Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    Re: Is it possible to apply the filter selected in ProcedureCall, Prequery1 or Prequery2 in Active report?

    No, I agree with Spencer. Personally I like Access for reporting, as you can create tables for bucket reports on the fly and back it up with vb without too much torture.

    -Jerry

    JR Data Inc

    jerry@jrdata.us

  • Verified answer
    Spencer McCandless Profile Picture
    Spencer McCandless 2,085 on at
    Re: Is it possible to apply the filter selected in ProcedureCall, Prequery1 or Prequery2 in Active report?

    I'm not sure if it's what you're looking for, but a lot of the built in active reports will dynamically construct a view before running a query against it. Item Movement History, for example. That said, the filters are applied after the view is constructed. I don't think there is any way to capture the filters as variables to construct the view in the first place.

    You could try writing a batch file using osql  to query the database directly. Or python has a module, pyodbc, that would probably work.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans