StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



How Do I Translate a Filtered DevEx Grid to a...Expand / Collapse
Author
Message
Posted 07/10/2008 11:00:32 AM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame 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

Post #17763
Posted 07/10/2008 11:05:02 AM


StrataFrame Developer

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.
Post #17764
Posted 07/10/2008 2:57:17 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame 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

Post #17774
Posted 07/10/2008 3:41:25 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame 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! 
Post #17778
Posted 07/10/2008 7:19:52 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame 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 filter

xtrareport.FilterString = lcfilter

Post #17785
Posted 07/11/2008 8:35:43 AM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame 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!!
Post #17796
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 5:30pm

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.062. 9 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.