cxGrid - Filter Grid View
I know how you can filter records of a column using the built in filters.However I would like the grid level to be filtered when I open it.Is there a way to do it ?
ASKER
With cxGrid you can display data from one table in various ways creating views.
First you create GridLevel and then the view you want .
Example: CxGridLevel1:CxGrid1DBTabl
and so on...
My problem is that this table has too many columns for comfort(I do not need all the fields shown).So I split it in 2 parts (creating 2 TableViews).
However,some fields are still pretinent to both views so I have to filter them further.
The only way I can do it is by a field called EVENT.
Now in this event field values are "bill in" and "bill out".
So I want one view to show me "bill in" and the other"bill out".
But I want it done at runtime,not by using the filter in the columns:Understand?
First you create GridLevel and then the view you want .
Example: CxGridLevel1:CxGrid1DBTabl
and so on...
My problem is that this table has too many columns for comfort(I do not need all the fields shown).So I split it in 2 parts (creating 2 TableViews).
However,some fields are still pretinent to both views so I have to filter them further.
The only way I can do it is by a field called EVENT.
Now in this event field values are "bill in" and "bill out".
So I want one view to show me "bill in" and the other"bill out".
But I want it done at runtime,not by using the filter in the columns:Understand?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Need ti hide columns ...
tried
visible := false ?
visible := false ?
ASKER
I try to avoid that...
That's my last resort :-)
That's my last resort :-)
could you care to clarify a bit more ?
screenshot of the results you want ...
screenshot of the results you want ...
ASKER
How do you band table thing on a column?
eh , ?
to have a banded table view :
hit customize button of grid
right click on level
create view -> Create DB Banded Table view
you set the *position* of each column on the bandindex, columnindex, rowindex
that's it
to have a banded table view :
hit customize button of grid
right click on level
create view -> Create DB Banded Table view
you set the *position* of each column on the bandindex, columnindex, rowindex
that's it
ASKER
"you set the *position* of each column on the bandindex, columnindex, rowindex"
thats the confusing part...
thats the confusing part...
*position* is a property of a column
ASKER
I know,but how do you display different column records separate?
i don't follow you ...
a screenshot explaining what you want ... ?
a screenshot explaining what you want ... ?
ASKER
just like in your pic..
did you add multiple bands ?
ASKER
Yo,I got it but no clue to how to proceed...
Never mind,I am really in no mood for learning.
Never mind,I am really in no mood for learning.
i can't help it you don't understand or in no mood to understand
what's the reason for a B ?
what's the reason for a B ?
Bandedview....never used that...hmmm....
i'll offer max pts for instruct how to do that.
i'll offer max pts for instruct how to do that.
lol, you need to open your own question for that ...
what do mean with grid level ?