| | | 
StrataFrame User
       
Group: StrataFrame Users Last Login: Today @ 10:49:34 AM Posts: 478, Visits: 1,969 |
| | 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 |
| | | | 
StrataFrame Developer

Group: StrataFrame Developers Last Login: Today @ 2:14:29 PM Posts: 4,901, Visits: 4,886 |
| | 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. |
| | | | StrataFrame Beginner
       
Group: StrataFrame Users Last Login: Today @ 4:07:28 PM Posts: 11, Visits: 1,055 |
| | 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 |
| | | | 
StrataFrame User
       
Group: StrataFrame Users Last Login: Today @ 10:49:34 AM Posts: 478, Visits: 1,969 |
| | Thanks! I will try assigning the filter string (ActiveFilterString?) to the BO. Great idea! |
| | | | 
StrataFrame User
       
Group: StrataFrame Users Last Login: Today @ 2:01:30 PM Posts: 372, Visits: 2,492 |
| | 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 filterxtrareport.FilterString = lcfilter |
| | | | 
StrataFrame User
       
Group: StrataFrame Users Last Login: Today @ 10:49:34 AM Posts: 478, Visits: 1,969 |
| | Farm out, man! That is great...I will definitely use that tip. MANY thanks!! |
| |
|
|