Ticket T291993
Visible to All Users
Duplicate

We have closed this ticket because another page addresses its subject:

Web Report Designer - Is it possible to disable data source queries editing for some users

Web Report Designer - How to disable the Delete/Edit/New Datasource buttons

created 9 years ago (modified 9 years ago)

I'm not sure if this is a bug or by design, but in our testing of the end user report designer we have come across an issue that we have to resolve.

We were able to use the report designer to delete data from the database.  Under sqldatasource, we clicked the "add query" button.  In the dialog that opens under "SQL string" we typed in "delete from tablename" and then clicked next and finish on the dialog.

Once the dialog closed it executed that statement and deleted all of the data from our table.

Ideally the dialog would only allow the user to enter a SQL Select statement.

Can we disable the add/delete/edit buttons for queries in the report designer?  We will be programatically adding the queries to limit the data tables that the end user can see and add to the report.

Answers approved by DevExpress Support

created 9 years ago (modified 9 years ago)

Hi,

It seems that the similar task was discussed in the Web Report Designer - Is it possible to disable data source queries editing for some users thread. Please refer to it and let us know if you have any other questions.

    Comments (2)
    FB FB
    Fielding Brewster 9 years ago

      Hi, I have tested this and it works when the designer is first loaded.
      However, if I then run the report wizard to create a default report, all of these buttons come back and are enabled again.
      How do I disable this buttons again after running the report wizard?
      Thank you

      Vasily (DevExpress Support) 9 years ago

        Hello,

        To process your recent post more efficiently, I created a separate ticket on your behalf: T292893: Web Report Designer - Customization applied to a field list is reset after the report wizard is run. This ticket is currently in our processing queue. Our team will address it as soon as we have any updates.

        Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

        Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.