Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Build SSRS report use AOT-Query, could get selected record info to SSRS query field (auto input)??

Posted on by 305

Hello,

Could anyone know build SSRS report with AOT/Query,

the SSRS report Query filter field could can auto get the selected records? No need manual to key in.

anual to key in.

Thank you in advance.

Br, Jen

  • ATMA-Jen Profile Picture
    ATMA-Jen 305 on at
    RE: AX 2012 Build SSRS report use AOT-Query, could get selected record info to SSRS query field (auto input)??

    Hello Start Ax,

    I know how to set default value in range property in AOT Query.

    but I need when selected records then click the print ssrs report button,

    the ssrs with AOT Query's filter field can auto put in the values.

    If know how to do, please to help and thanks a lot.

    Br, Jen

  • ATMA-Jen Profile Picture
    ATMA-Jen 305 on at
    RE: AX 2012 Build SSRS report use AOT-Query, could get selected record info to SSRS query field (auto input)??

    Hello Blue,

    It is Query and had a filter in the query itself.

    Now  I need when selected the records that AOT-Query's filter can auto put in the data in the filter field, not manual.

    I write the Controller - prePromptModifyContract() method to try get the records info to AOT Query's filter field, but still empty.

    So I would like to know SSRS report used AOT-Query how to do it? or not ?

    Please help and Thank you.

    Br, Jen

  • Suggested answer
    startax Profile Picture
    startax 1,845 on at
    RE: AX 2012 Build SSRS report use AOT-Query, could get selected record info to SSRS query field (auto input)??

    Hi Atma,

    In Aot query you can add fields to filter records range option. You can give default value in range property also so when ever you will open this fields in range and value is auto populated.

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: AX 2012 Build SSRS report use AOT-Query, could get selected record info to SSRS query field (auto input)??

    Hi Jen,

    Is your SSRS report based on Query? Or RDP?

    If it is Query, I think you can create a filter in the query itself.

    If it is RDP, I think you can try to create parameters in the Contract class and then use them in the RDP class.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans