INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Group Suppress No Drill Down problem

Group Suppress No Drill Down problem

(OP)
Hi

Not sure if anyone can help. We have some code that si not bringing through all of the results if there is more than one of the same vwWorksSchedule.orderlinetype. This is in a group section expert for Suppress(no drill down)

If they are numbered 1 and 2 and 3 then it works. However if they are number 1 and 2 and 2 and 3 then I don't get the correct result through. Sorry this is hard to explain.
So if the vwWorksSchedule.orderlinetype as more than one 2 for example, how can I get it to display. These are all part of order numbers. I personally thinks maybe there should be an Else statement after, I have tried some things but losing the battle. Sorry it is not very well explained, but if anyone can see anything obvious with the code nay help would be appreciated. Thanks

if {vwWorksSchedule.Name} <> "MDF"
then
{vwWorksSchedule.WOSLineType} = 2 or {vwWorksSchedule.WOSLineType} = 3
or
({vwWorksSchedule.WOSLineType} = 1
and {vwWorksSchedule.orderlinetype} = 1
and {vwWorksSchedule.ProcessLine} > 1)
//and {vwWorksSchedule.ProcessLine} <> {vwWorksSchedule.orderlinenumber}
or
({vwWorksSchedule.WOSLineType} = 1
and {vwWorksSchedule.orderlinetype} = 2
and {vwWorksSchedule.ProcessLine} > 1)
and {vwWorksSchedule.ProcessLine} <> {vwWorksSchedule.orderlinenumber}
Or
({vwWorksSchedule.WOSLineType} = 1
and {vwWorksSchedule.orderlinetype} = 3
and {vwWorksSchedule.ProcessLine} <> {vwWorksSchedule.orderlinenumber})

RE: Group Suppress No Drill Down problem

I'm not sure if anyone else understands what you are trying to do but I certainly don't.

I would suggest the following:
  • Remove the sppression formula so the report returns all data;
  • Provide a sample of the resultant data;
  • Explain what you do and don't want to see on the report, and why
This should help us to understand the issue and to formulate a solution.

Cheers
Pete

RE: Group Suppress No Drill Down problem

(OP)
Hi

I may have sorted it, jus testing some more so please don't spend any time looking thanks.
I have added this line in

if {vwWorksSchedule.Name} <> "MDF1" AND {vwWorksSchedule.Name} <> "MDF2" AND {vwWorksSchedule.Name} <> "MDF Stromab"

I though if {vwWorksSchedule.Name} <> "MDF1*" whoulc have done it but the wild card did not work.

I will update if further help may be needed

Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close