Hiding Query Parameters in AX 2012 SSRS Report Dialog

This question is answered

Hi,

I want to hide the dynamic query parameters in a AX 2012 SSRS report dialog.

The report datasource is a query, which has a  few predefined ranges. But in the report dialog, I just want to see the printer select box and not the query range fields with their predefined values. I set the status of the query ranges to hide, but ist had no effect on the dialog.

Is it possible to hide all the parameters at once for the report dialog?

Thx, Markus     

Verified Answer
  • Hi,

    If you use a report controler class, you can overwrite the showQuerySelectButton method and return false.

    Regards, Dirk

  • Hello,

    If you remove the ranges from the modeled query, and add them back programmatically in the methods of the query, they also will not show up as parameters for the report.

    Best Regards,

    Bill Thompson

    Dynamics AX/Sure Step - Online Support Engineer

    ============================================================

    When responding to posts, please 'Reply to Group' via your newsreader so that

    others may learn and benefit from your issue.

    ============================================================

    This posting is provided 'AS IS' with no warranties, and confers no rights.

    ============================================================

All Replies
  • Hi,

    If you use a report controler class, you can overwrite the showQuerySelectButton method and return false.

    Regards, Dirk

  • Hello,

    If you remove the ranges from the modeled query, and add them back programmatically in the methods of the query, they also will not show up as parameters for the report.

    Best Regards,

    Bill Thompson

    Dynamics AX/Sure Step - Online Support Engineer

    ============================================================

    When responding to posts, please 'Reply to Group' via your newsreader so that

    others may learn and benefit from your issue.

    ============================================================

    This posting is provided 'AS IS' with no warranties, and confers no rights.

    ============================================================

  • Thanks for the help.

    I've tried both solutions und now I've just to choose, which one I use. :-)

    Regards, Markus

  • You have to override the showQueryValues()  of controller class and return false

  • What about the contract class parameters ? I tried to set the parameter's property to hidden in  visual studio , it does not help.

  • Raj_kumar's answer is the most suited as you dont want to show query ranges and the button

    @ aaa510

    contract parameters are can definately be hidden . Look at any report that uses srstmpTableMarshaller class (Pseudo tmp table report's ). or  any document reports . Journal record id is generally passed from controller --> Design (via parameter value in contract class) -- >DP class.

    But still its not visible on the report

    All you need to is set its property to hidden in VS

    I feel its more like issue with the usage data.

    Once you set the property to hidden you need delete the report from report manager and then redeploy

    remove usage data , delete records

    in SYSLastValue , SRSReportQuery

    restart Reporting services

  • @venkatesh vadlamani  Thank you for your reply.

    This morning when I try to run the report the parameter is hidden, i have not changed anything since yesterday I set the property to hidden, I think that it is the normally cache problem some I have had before.

    anyway it works now, thanks again!