Solved

Where Group Name is October give Group Summary Field1

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Suggested Solutions

Title # Comments Views Activity
Tableau Graph Question 3 164
SSRS and Visual Studio Setup 7 98
CRM 2011 RDL Report - Print field up to a special character 6 91
Query Builder end user tool for SQL Server 1 129
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…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

751 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