Joe Kunk did a Webinar on using parameterized sprocs with Xtrareports. He was using 9.1 at the time. I tried to duplicate exactly what he demostrated and got completely different results, first in that RequestParameters = false had changed as documented here
BC937: The Parameters dock panel is now always shown (with no regard to the XtraReport.RequestParameters property value) if visible parameters exist in a report.
but more importantly in that the parameter changes and subsequent call to showpreview() don't seem to requerying the backend, and I'm wondering if there may be some connection.
Attached in my email to Joe and a zip of a very simple sln using Adventureworks exactly as he did in the Webinar.
Hope you can she some light on this.
TIA
Charles Hankey
Ticket
Q299515
Visible to All Users
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.
Hi Charles,
Thank you for your report.
To solve this problem, please use the XtraReport.BeforePrint event to fill the DataTable.
Please try this solution, and let us know the results.
Thanks,
Andrew
Thanks, Andrew. Filling the datatable through the tableadapter in the beforeprint event worked great.
The technique using a sqldataadapter demonstrated in Joe Kunk's webinar has the advantage of being able to set set a default parameter value and dropping on a sqlconnect class so that data can be previewed at design time. Unfortunately, I was not able to get this to work at run-time the way Joe's demo apparently did.
Generating a dataset from a sqldataadapter does not generate a tableadapter and I was unsuceesful in setting the parameter and filling through the sda at runtime, even in the beforeprint.
Sooo, I found that using your techinique as in the sample you set and then in addition, dropping an sda onto the report that would be used only for design-time previewing gave me the best of both worlds. ( of course the sda and connection class can later be removed as they are not used at runtime )
If anyone has a better way of allowing preview of data in a report based on a parameterized sp I'd love to hear it, but in the meantime, this will work great.
Thanks very much for your prompt help and Merry Christmas to all at DevExpress !
Hi Charles,
Thank you for the feedback. I have tried to use the SqlCommand, but encountered a SQL exception, which is not related directly to the XtraReport suite.
So, instead of using SqlCommand (which is outdated starting from VS2005), I have used TableAdapter instead. You can use the XtraReport.OnBeforePrint script, instead of the event handler to pass values.
Scripts are executed in the End User and Visual Studio designers.
Thanks,
Andrew
Just to be clear, for the benefit of lurkers, I'm not talking about the SQLCommand but the SQLDataAdapter control ( as opposed to the Tableadapter that appears when you drop on a dataset).
Since this technique is shown in a DevExpress Webinar that comes up if you are a looking for guidance on using SPs with XtraReports, I would suggest that if the technique does not work it might be a good idea to either note that where the webinar is posted ( perhaps just a link to this discussion ) as it may save somebody a *lot* of time trying to figure out why something shown in a training video doesn't work :-)
The sqldataadapter trick is very handy though at design time for seeing the layout of a report with actual data.
I *love* XtraReports ( and pretty much everything else I've encountered so far with DevExpress both as a product and as an organization. I'm excited about learning as much as I can about all your tools.
Hi Charles,
Thank you for your feedback.
The approach shown in this webinar should work with the XtraReport.BeforePrint or XtraReport.ParameterRequestSubmit event handlers in the new version of the XtraReport suite.
We will either update or disable this screencast.
Thanks,
Andrew
Thanks so much for your help and patience on this. If I use a SqlDataAdapter (and use that to generate my dataset
as shown in the Webinar) and then set the parameter for the SDA and call the fill in the BeforePrint everything works great and I have the ability to preview at design time and get the results I expect at run-time. ( I was not able to do this with the ParameterRequestSubmit )
One important caveat : If you have a default value for the SDA param set for testing at design time you must reset it to 0 (for Int32 param) before run-time. (haven't tested string params etc yet but I assume they must be reset to string.empty) Before I did that I found I was getting two data pulls - one for the design time param and one for the run-time param and both ending up in the same table. Very confusing and the reason I thought it wasn't working when I tried it before.
So the otherwise excellent Webinar should just be modified to show the code going into the BeforePrint instead of ParametersRequestBeforShow and should include a call to the Fill() and there should be a warning about reseting any design time default params in the SDA.
Thanks again. Now we're rolling !
Hi Charles,
Thank you for your feedback.
This webinar was recorded about year and an half ago, and became outdated since then.
I will contact our XtraReport team evangelist Seth Juarez (sethj@devexpress.com), regarding this webinar.
Thanks,
Andrew