How Do I Translate a Filtered DevEx Grid to a BO?


Author
Message
Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 785, Visits: 3.6K
The DevEx grid is really nice.  I have set one of my columns to present a checked list for filtering.  Slick.  Now, I want to take the users filtered records and bake them into a report.  I'd like to create a BO that has each of these filtered records.  Is there an easy way to do this?  Or do I need to "walk" the grid and, somehow, copy these records into a new BO, then use that BO to generate a report?

Thanks for your help!!
Bill

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
To be honest, without setting this up I can't give you a straight answer.  I do not live in the DevExpress grid so I really don't know what they are doing behind the scenes here.  The bottom line, though, is that if you can apply the filter on the BO then it will translate into the report.  You would really want to create a custom BBS (using the new 1.6.6 template) as your data source then you could just pass that data source over to a report.  But without "getting my hands dirty" I am not going to be able to give you a 100% answer on this as I just do not have the DevExpress grid logic in my head since it is not something that I use myself.
Kenneth Langley
Kenneth Langley
StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)
Group: StrataFrame Users
Posts: 26, Visits: 1.5K
The filter object has a property named "FilterString". This string can be applied as a filter on the Business object to give you the records you need for your report.

Good luck

Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 785, Visits: 3.6K
Thanks!  I will try assigning the filter string (ActiveFilterString?) to the BO.  Great idea! 
Paul Chase
Paul Chase
Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)Advanced StrataFrame User (580 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
Bill,

I am doing the same thing it is the cat'sass , just take the filter from the grid and apply it to the reports filter string property this will filter the report, something like below, also you can get snazzy and allow the user to save the filter and then create their own list of saved filters so they can simply choose from a list and apply whatever saved filter fits the bill or create a new one.  

Dim lcfilter As String = Me.GridView1.ActiveFilter.Expression

'Set filter

xtrareport.FilterString = lcfilter

Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 785, Visits: 3.6K
Farm out, man!  That is great...I will definitely use that tip.  MANY thanks!!
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