I have a xtrareport that I am using in XAF winforms.
I am using XtraReport.RequestParameters = true so that the user gets prompted for parameters.
The report binds to a list of business objects that are populated from the output of a stored procedure.
I want the stored procedure to re-run after the user presses Submit in the parameter screen.
What do I need to do?
This question relates to https://www.devexpress.com/Support/Center/Question/Details/T317718
Hello,
If you need to customize a data source query after submitting report parameters, use the XtraReportBase.DataSourceDemanded event. It is raised before the report is generated and after submitting parameter values. In the event handler, you can modify your stored procedure manually.
See also: How to use a stored procedure as a report data source (System.Data.DataSet) in a WinForms application
Please let me know if this approach helps.
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.
Hello Kirsten,
I have forwarded your ticket to our XtraReports team, because this task is not directly related to XAF.
Would you please also attach your test project so we can research your current implementation and the aforementioned behavior? This will help us provide a solution much faster. Thanks in advance.