Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Details suppression question

Status
Not open for further replies.

ghostofelmo

IS-IT--Management
Jul 20, 2006
18
US
Using CR 8
Can you suppress in the details section using 2 qualifiers?

I am writing the report off of 6 tables, one is a master and there are five tables that link directly to it. I need to indicate wether one of the buttons on each of the five areclicked on and the other clicked off to pull data or not.
I have 5 details sections.
 
Odd post.

What are these buttons you speak of and why would you think we know what they are?

Try using real technical terms with respect to fields and data in Crystal.

And yes, you can suppress based on 2 "qualifiers", depending on what that means to you.

Post specifics what are the qualifiers, and again, why would you think that we know what this means?

A formula might read:

{table.field1} > "blah"
and
{table.field2} = "blah blah"

-k

-k
 
Sorry to confuse with all of the button lingo. Here is what I am working with: First off we have production folders that can either be active or inactive (first suppression) but the active ones need to be turned off once a particular field is marked as true (second suppression). Still clear as mud? All that I want to see in each details section is Active with particular field as false.
 
Wow all it took was writing my response to you. I think that the following formula was all I needed.

{P Folder 1.Room 1 Active} = False or
{P Folder 1.Room 1 Active} = True and {P Folder 1.PAR:} = True

Thanks for letting me have something to respond to.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top