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

Subtotals by different fields sorted independently

Subtotals by different fields sorted independently

(OP)
Can I subtotal the same amount by four different fields on the same report, using WebFOCUS 7?

Not with a nested sort, but four independent sorts.

The situation is that we have a report that gives a grand total of sales and then a choice of subtotals.

To use the hypothetical example of car sales, the report would subtotal all the sales by location, then within that location, you can choose to subtotal it by the make of the car, the color of the car, the size of the car, or the factory where the car was made.

People are calling it up all four ways and then cutting and pasting so that they get a report that has the location, then the subtotals by make of car sold at that location, then the subtotals by color of car sold at that location, then subtotals by size range, then subtotals by factory of origin. This takes a long time, so they have asked for a report that prints it out automatically: By location, with the subtotals for four different sort fields under each location. This is not one sort by multiple fields. It would print all sales for that location by make, then all sales for that location by color, then all sales for that location by size, then all sales for that location by factory.

I have looked in the manuals and in this forum and I haven’t seen a way to do this. Is it possible to do this in WebFOCUS?


Many thanks for your ideas!

RE: Subtotals by different fields sorted independently

Is your question you would like the user to be able to choose the level of subtotal for the report or have the report print the same set of subtotals as mentioned above for all users.

RE: Subtotals by different fields sorted independently

(OP)
Thank you for your response, sxscheck!

I would like to print the same set of subtotals for all users.

I have thought of a way to do this: Create workfiles, each sorted by a field called SORTFIELD which is the same length. In one workfile, make the sortfield the size, in another workfile it would be the color, etc. Then combine the workfiles and print them together. I would have to have another number in the file to sort on to keep all the size records together in the report and all the color records together, etc.

That seems like a possible way to do it.

RE: Subtotals by different fields sorted independently

(OP)
I have completed the report using workfiles as I outlined above. It works! wiggle

wavey2

RE: Subtotals by different fields sorted independently

Workfiles worked for me as well. I thionk you can not go wrong with it.



mobile app development company

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