?
Solved

Where Group Name is October give Group Summary Field1

Posted on 2011-09-21
4
Medium Priority
?
322 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 1500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses
Course of the Month5 days, 20 hours left to enroll

588 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