Formula to suppress different data types that are not relavant 1

[KenziC]

Hi!
I am creating a report that shows me which venders have our parts. We have a workcenter and vender field that are linked to Start dates and end dates. When I preview my report, it shows blanks (which if I had the workcenter field in it would show) next to a list of workcenter dates then the vender next to the correct vender start/end dates I am trying to suppress workcenter dates. I only want to see vender and the vender start/end date. In the suppress formula field, I'm trying:

if {Job_Operation.Vendor} ? {Job_Operation.Sched_Start} then false else true

I dont know what to put in the ? area seeing they are not the same. Like I said, I just want to see the start/end dates for the venders, I want it to suppress all of the dates for the workcenters. Thanks for any help!

Kenzi
"Programmers are tools for converting caffeine into code."

 

[lbass]

Why don't you just remove the workcenter date field from the display?

-LB

 

[dgillz]

Why are you suppressing it as opposed you removing it from the report entirely with a record selection formula?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[KenziC]

The way it is set up is the dates correspond with both workcenters and venders. There is not a "workcenter date" and "vender date". It will always show all dates for both, but if I dont put the workcenter field in the report, then there will be a blank next to the date. Same with the vender. Does that make more sense? I'm sorry I wasn't clearer earlier.

Thank you

Kenzi
"Programmers are tools for converting caffeine into code."

 

[lbass]

Please identify the fields you are placing on the report and then show some mock data that illustrates the problem.

-LB

 

[KenziC]

If I have workcenter and vender on top of each other in the detail section then start_date and end_date beside them it looks like this:

Work Center/ Vender Start Date End Date
Issue Material 9/8/11 9/9/11
Folding Press 9/12/11 9/15/11
South W (vender) 9/16/11 9/20/11
Inspection 9/21/11 9/22/11

If I just have vender in the detail section with start_date and end_date then it looks like:

Work Center/ Vender Start Date End Date
9/8/11 9/9/11
9/12/11 9/15/11
South W (vender) 9/16/11 9/20/11
9/21/11 9/22/11



Kenzi
"Programmers are tools for converting caffeine into code."

 

[lbass]

Go to the section expert->details->suppress->x+2 and enter:

isnull({table.vendor})

-LB

 

[KenziC]

You are amazing. Thank you so very much!!!!!

Kenzi
"Programmers are tools for converting caffeine into code."