Solved

Where Group Name is October give Group Summary Field1

Posted on 2011-09-21
4
313 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Tableau Server - email options 5 136
Average Calculation - SAP Lumira 1 140
SSRS report builder 3.0 6 43
CRM 2011 Error Connecting to Report Datasource 7 72
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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