XtraReports and parameterized SPs


Author
Message
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Hope this will save somebody else some time.  There is a Joe Kunk webinar and while the technique of using a SQLDataAdapter is seductive, it doesn't work as shown.

Here's my solution :

http://www.devexpress.com/Support/Center/p/Q299515.aspx

Basically, you need to set the param and call the fill in the BeforePrint(), and be sure to reset the design-time sda param before you build (or export your reptx )

This was a head-scratcher but it is working great now - recommend you give it (and DevExpress in general ) a try.
Replies
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Thanks Charles, good info.

Edhy Rijo

Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
I'm a little less excited about it today as I can't seem to get the preview to work with string based params ( you do need to set the param to string.empty to get the run-time to work at all, but setting a "default" param on the SDA doesn't seem to work as it does for integers.  I may see if I can get DevExpress to fix this, since it is their previewer that is the issue.

This only applies to previewing the report, however.  If you right-click on the SDA that is dropped on the report you can preview the data setting params and that works fine.  You just can't see your report populated with data as you can when the param is an int32.

I think the report previewer is just not wrapping the string param with single quotes before sending the exec.  They could probably fix it pretty easily 

( I have source but haven't checked yet to see if I have the source for the Xtrareport Designer.  I don't think I  do but I'm going to ask )
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search