Avatar of senad
senadFlag for Slovenia asked on

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 ?
Delphi

Avatar of undefined
Last Comment
Geert G

8/22/2022 - Mon
Geert G

could you explain a little more ?
what do mean with grid level ?
ASKER
senad

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:CxGrid1DBTableView1
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
Geert G

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
senad

Need ti hide columns ...
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Geert G

tried
visible := false  ?
ASKER
senad

I try to avoid that...
That's my last resort :-)
Geert G

could you care to clarify a bit more ?
screenshot of the results you want ...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
senad

How do you band table thing on a column?
Geert G

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
ASKER
senad

"you set the *position* of each column on the bandindex, columnindex, rowindex"
thats the confusing part...
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Geert G

*position* is a property of a column
ASKER
senad

I know,but how do you display different column  records separate?
Geert G

i don't follow you ...
a screenshot explaining what you want ... ?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
senad

just like in your  pic..
Geert G

did you add multiple bands ?
ASKER
senad

Yo,I got it but no clue to how to proceed...
Never mind,I am really in no mood for learning.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Geert G

i can't help it you don't understand or in no mood to understand
what's the reason for a B ?
srbenavrbe

Bandedview....never used that...hmmm....
i'll offer max pts for instruct how to do that.
Geert G

lol, you need to open your own question for that ...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.