StrataFrame Forum
Back
Login
Login
Home
»
Updates and Information
»
StrataFrame Users Contributed Samples
»
XtraReports and parameterized SPs
XtraReports and parameterized SPs
Post Reply
Like
3
XtraReports and parameterized SPs
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Charles R Hankey
Charles R Hankey
posted 15 Years Ago
ANSWER
Topic Details
Share Topic
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.
Tags
Devexpress
XtraReports
Reply
Like
3
Replies
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Thanks Charles, good info.
Edhy Rijo
Reply
Like
3
Charles R Hankey
Charles R Hankey
posted 15 Years Ago
ANSWER
Post Details
Share Post
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 )
Reply
Like
4
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
XtraReports and parameterized SPs
Charles R Hankey
-
15 Years Ago
Thanks Charles, good info.
Edhy Rijo
-
15 Years Ago
I'm a little less excited about it today as I can't seem to get the...
Charles R Hankey
-
15 Years Ago
Yes. Thanks Charles. By the way, just as an interesting aside,...
Russell Scott Brown
-
15 Years Ago
I decided life is too short for Infragistics :-) There property...
Charles R Hankey
-
15 Years Ago
Hi Charles, Russell, I totally agree with Charles, even though I have...
Edhy Rijo
-
15 Years Ago
I'm with you. I've alreadydecided onDevExpress and XtraReports,...
Russell Scott Brown
-
15 Years Ago
Post Reply
Like
3
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search