Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Where Group Name is October give Group Summary Field1

Posted on 2011-09-21
4
Medium Priority
?
318 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
[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
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
How to increase the row limit in Jasper Server.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

730 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