Solved

Summarising field in a group header to exclude suppressed values

Posted on 2012-03-23
8
511 Views
Last Modified: 2012-04-16
Hi

I have a report which shows order values in a group header. The group is suppressed when an order has been completely delivered.
When i add a summary of the order value to the report footer it is showing the total for all orders, and i only want it to show the values which appear in the group header (ie those not suppressed).

I have attached the report with some saved data. It is the order value shown in group header 3 i am trying to summarise. You can see the problem i have on the preview page

Thanks
0
Comment
Question by:Stevepaget
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 250 total points
ID: 37756707
You will have to

1.  Use a running total that evaluates when the order has NOT been delivered
2.  Create a formula like this and summarize it
       If Not {Delivered} then
           {Amount}
3.  Use the selection filter to select only those records that aren't delivered
4.  Use formulas with variables to evaluate the total

mlmcc
0
 
LVL 35

Assisted Solution

by:James0628
James0628 earned 250 total points
ID: 37760179
I don't see any attachments.

 FYI, I believe mlmcc was suggesting 4 different ways that you might handle this, not that you needed to do all of those things.

 Basically, you need to incorporate your suppression conditions when generating the totals.  The available options will depend on the nature of your suppression conditions.

 James
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 37760906
My thoughts apparently are faster than my typing.

I meant  
   You will have to do one of the following

mlmcc
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:Stevepaget
ID: 37766320
Cheers for the replies.

The issue i have is that I am trying to summarise a field which depends on a summary for it's suppression conditon. I have attempted to attach the report again as that best illustrates the issue.
Order-Bank-5.rpt
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 37767415
Are you trying to get the Sum(CallOffs.Value) ?

Does the total need to be in the group header?
Since the suppression depends on a summary, you can't use a summary therefore you can't get it into the group header.

mlmcc
0
 

Author Comment

by:Stevepaget
ID: 37771491
Yes, I need to get the sum of calloffs.value and the sum of orders.value into the report footer, but only for orders where the orderbank formula returns a value greater than 1.

As you say the problem is that the orderbank formula is based on a summary field so i am stuck as to how to get the totals to calculate. Maybe it is impossible but i hope there is some way!

Thanks
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 37771673
DO you need it in the group header?

It is relatively easy to calculate and display in the group footer

mlmcc
0
 

Author Comment

by:Stevepaget
ID: 37772829
The details could go in the group footer yes, if that makes a difference? The key is getting a summary of the details to  show in the report footer.

Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question