Hide Grid Row

[CajunCenturion]

Is it possible to programmatically hide certain rows of a grid if the values in one column meet some criteria?

Thanks.

--------------
Good Luck
To get the most from your Tek-Tips experience, please read
FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[MarciaAkins]

Is it possible to programmatically hide certain rows of a grid if the values in one column meet some criteria?

Thew short answer is no. Instead, create a view that excludes the records you do not want to display and use the view as the grid's RecordSource instead.

Marcia G. Akins

http://www.TightlineComputers.com

 

[CajunCenturion]

Thank you.

--------------
Good Luck
To get the most from your Tek-Tips experience, please read
FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[dgrewe]

I have a Field called Active on almost all my Tables. And Set filer to Active = .T. or Active =.F. works on my grids. I have a button on the form and the click method is

SELECT (THISFORM.fcParentDbf)
lcCaption = UPPER(ALLTRIM(THIS.CAPTION))

DO CASE
CASE lcCaption = "IN WORK"
	THIS.CAPTION = "Complete"
	SET FILTER TO Lactive = .F.

CASE lcCaption = "COMPLETE"
	THIS.CAPTION = "No Filter"
	SET FILTER TO 

OTHERWISE
	THIS.CAPTION = "In Work"
	SET FILTER TO Lactive = .T.

ENDCASE

THIS.REFRESH()
THISFORM.grd_Jobs.REFRESH()

So why a filter on another field will not work.

If you are using a backend engine and a view, I do not know the results, Never tried it, But it seems to me you can annd that as part of the view query of SQLEXEC command.


David W. Grewe Dave

 

[MarciaAkins]

SET FILTER TO Lactive = .T.

One word of caution - filters in grids are not Rushore optimizeable.

Marcia G. Akins

http://www.TightlineComputers.com

 

[craigber]

Another word of caution...

Scroll bars and the thumb don't work properly in a filtered grid.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"