locked
Enable ad hoc report executions RRS feed

  • Question

  • What EXACTLY does "enable ad hoc report executions" option do?  I've disabled it and enabled it and cannot tell a difference.  I'm always able to open report builder, edit reports and publish and run them.

    Also, on a new server I built this option is greyed out.  What does that mean?

     

    Thanks


    • Edited by nd2000 Thursday, May 5, 2011 1:28 PM edit
    Thursday, May 5, 2011 1:28 PM

Answers

  • Hi,

    This option is used for ad hoc report, with ad hoc report, Report Builder users do not have to understand the source data structure in order to create meaningful reports. They can create reports by dragging and dropping data items onto a report layout. Report Builder uses predefined Report Models to access data sources, you will want to provide your end users with already built Report Models to enable ad hoc authoring. If this option is disnabled, you cannot do this option.

    You could refer to this document about how to create a report model http://technet.microsoft.com/en-us/library/dd504762.aspx 

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Challen Fu Saturday, May 14, 2011 4:51 PM
    Monday, May 9, 2011 9:33 AM

All replies

  • Hi,

    This option is used for ad hoc report, with ad hoc report, Report Builder users do not have to understand the source data structure in order to create meaningful reports. They can create reports by dragging and dropping data items onto a report layout. Report Builder uses predefined Report Models to access data sources, you will want to provide your end users with already built Report Models to enable ad hoc authoring. If this option is disnabled, you cannot do this option.

    You could refer to this document about how to create a report model http://technet.microsoft.com/en-us/library/dd504762.aspx 

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Challen Fu Saturday, May 14, 2011 4:51 PM
    Monday, May 9, 2011 9:33 AM
  • But I don't experience any difference in functionality when I disable the setting?  When I disable it I can still launch report builder, edit and create reports in it.
    Monday, May 9, 2011 6:28 PM
  • Hi nd2000,

    Just as my first post, this option is for ad hoc report, what you do is not relevant to ad hoc, ad hoc's datasource is retrieved from report model.

    Thanks for your understanding.

    Regards,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, May 11, 2011 9:03 AM
  • Sorry, I still don't understand.  Can you point me to some documentation?  I've disabled the option and can't tell any difference.
    Monday, May 16, 2011 2:38 PM