Solved

Where Group Name is October give Group Summary Field1

Posted on 2011-09-21
4
312 Views
Last Modified: 2012-05-12
hello,

I have attempted to use the crosstab functions but I can not get what my manager wants.  In a formula can I retrieve a group summary field for a specified group?  Such as Group Name is October give me summary field1 or summary field2 or so on.
0
Comment
Question by:Michael
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:edlunad
ID: 36574250
With Sum function you can specify the scope (Dataset, Group or Data Region), something like this...

=Sum(Fields!Field1.Value, "October")

I dont know if this is what you really need.
0
 

Author Comment

by:Michael
ID: 36574470
I am using Crystal Reports and the SUM function is close to that but the conditions seem to limited to group options, that is daily, weekly, monthly, and so on.  I do not believe I can specify a specific group like October.  I have tried.
0
 
LVL 9

Accepted Solution

by:
edlunad earned 500 total points
ID: 36574529
Sorry didn't notice that was Crystal.

In this case, have you tried like a formula for filtering the data you need, then using that formula on you SUM function, like this ...

http://stackoverflow.com/questions/1545883/conditional-group-sum-in-crystal-reports
0
 

Author Closing Comment

by:Michael
ID: 36575191
I am using a formula field and capturing the monthly summary values  in variables.  Then I can place them in my manual CrossTab looking objects.  I may look some more at crosstabs because maintenace of this reporting will be a killer.

Thanks!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

777 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