not printing rows in table in report?

[Yessen]

When I print the table I want certain rows not to appear on some criteria

in my case rows that have one column field < 200 hours.

how can I do that?

 

[pbaldy]

Either base the report on a query that selects the appropriate records, or use a technique like this:

http://www.baldyweb.com/wherecondition.htm

but with a wherecondition like:

"FieldName < 200"

 

[Yessen]

Either base the report on a query that selects the appropriate records, or use a technique like this:

http://www.baldyweb.com/wherecondition.htm

but with a wherecondition like:

"FieldName < 200"

I need my filter to affect only the DETAIL part of the report, the rest should still be based on the original query.

 

[Yessen]

I just fixed this by making my rows field.invisible = true because rows that I dont need are at the end of the table anyways, i can just make them invisible. but now since it report treats them as they exist anyways, it spills to the next page and I have extra blank pages?

How can I say something, if page doesnt contain field.invisible = true please dont create such?

please help!!!

 

[Yessen]

Or in other words, how can I say that if row field.hours < 200

then ignore all the rest rows and go to the next report in the query?

 

[pbaldy]

Maybe some sample data would help us understand what you've got. Normally you exclude data from the report, not try to hide it.

 

[Yessen]

Maybe some sample data would help us understand what you've got. Normally you exclude data from the report, not try to hide it.

In my upper portion of report I want no filter to be applied

but in the lower part where table is generated I want to apply filter i.e rows that only have more than 200 hours.

Previously I applied more than 200 hours filter to the QUERY that I am basing my report on.

but then some of the information in the upper portion of the report was missing. Thus I need to apply filter only to the DETAIL part of the report section.

 

[Yessen]

to make it simple,

how can i make field on the report not show up at all instead of just saying field.visible = false

 

[pbaldy]

You can try hiding the detail section, as appropriate, in the detail format event:

Me.Detail.Visible = False

 

[Yessen]

You can try hiding the detail section, as appropriate, in the detail format event:

Me.Detail.Visible = False

I dont want that because it is actually there and the table spills over to the next page but doesnt show anything and I have extra blank page.

I need it really skip the row, not just make it invisible.

 

[pbaldy]

Can we get a sample db? I'm having trouble visualizing what you're trying to do.

 

[Yessen]

Can we get a sample db? I'm having trouble visualizing what you're trying to do.

I cant. work security issues.

I just need to find out how can I do something like

field.visible = true

but instead something like

field.skip = true

so it doesnt really have it on the report (wont take space unlike visible = false does)