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

Exception Report based off of results from Subreports

Exception Report based off of results from Subreports

(OP)
Hi all!

I have created a report where I have 2 sub-reports passing a total of 8 variables back to the main.
On the main I have a formula where I am using the shared variables from the 2 subs to create positive or negative number (basically, open orders minus deliveries minus any avail open stock buckets). I want to be able to only show the results that are negative numbers and it's corresponding order detail from the detail line.
My detail is on the detail line, my subs are both on GF1a and my formula result is on GF1b.
How or what can I do to only show this negative number?? I currently have about 200+ pages of order detail and only about 1 page that are true "exceptions" that I would want to show.

Any ideas???

RE: Exception Report based off of results from Subreports

If the subreports are in the group footer, then they are not running until after the detail has been processed.

You might try moving them to the group header, then it will be available for the detail lines in the group. I would put the subreports in GH1a and the return formulas in GH1b.

RE: Exception Report based off of results from Subreports

(OP)
I am still not able to suppress the positive results. I need to be able to show only the negative results of the formula, which are the exceptions.
Typically I would use the Select Expert/Formula Workshop to say where {formula} < 0.

I have to think that there is a way to create this exception but I just can't seem to come up with a solution. :(

RE: Exception Report based off of results from Subreports

That's exactly what you do. Create another formula in the main report with this
If {formula} < 0 Then {formula} Else 0
Then suppress if that {formula} >= 0.

RE: Exception Report based off of results from Subreports

If you are relying on results from a sub-report, you cant use record selection. A couple of things to check:
  • you need to use shared variables;
  • the sub-report will need to be in a section prior to where the resultant variable is being used.
If you are still having problems, post details of report structure, and the suppression formula you are using.


Hope this helps.


Cheers
Pete

RE: Exception Report based off of results from Subreports

(OP)
I believe I have found a solution.
I ended up using a formula in the Details Section Expert to suppress any "exceptions" (If {@Short To Order} < 0 Then {@Short To Order}Else 0)that were = to "0.0".
Works like a charm.
Thanks for the ideas and assistance!!


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