<div>
You can specify your own groups with your own names when you Insert a group on a particular field.<br />
When you get the Insert Group dialog choose 'In specified order ' from the sort sequence drop down.<br />
This open up a new dialog box which allows to specify a group name - click New and then add all the Account nos that make up that group. Repeat as necessary for each New group.
</div>


You can specify your own groups with your own names when you Insert a group on a particular field.
When you get the Insert Group dialog choose 'In specified order ' from the sort sequence drop down.
This open up a new dialog box which allows to specify a group name - click New and then add all the Account nos that make up that group. Repeat as necessary for each New group.

<div>
Ok that formula that bdreed gave me seems to work, but it will not sum of the total for the group.. any ideas why?
</div>


Ok that formula that bdreed gave me seems to work, but it will not sum of the total for the group.. any ideas why?

<div>
The formula I gave you only allows you to group records, not sum them.<br />
Once you create the group, you should be able to insert a summary on any numeric field that you need a sum for.
</div>


The formula I gave you only allows you to group records, not sum them.
Once you create the group, you should be able to insert a summary on any numeric field that you need a sum for.

<div>
Thanks, Worked like a charm
</div>


<div>
<div class="content wysiwyg-content">
I am looking to make an expense report in Crystal. &nbsp;The database has several fields that relate to the same general type of expenses(eg. Salary &amp;&nbsp;Wages - Temp; Salary &amp;&nbsp;Wages - Manager) &nbsp;that i want to sum up under a single Salary Heading, and not show the indivual groups. &nbsp;the database has account numbers and i know what account #'s i want under each heading; however I cannot figure out how to incorparate this logic into CR 11.5.<br />
<br />

</div>
</div>


I am looking to make an expense report in Crystal.  The database has several fields that relate to the same general type of expenses(eg. Salary & Wages - Temp; Salary & Wages - Manager)  that i want to sum up under a single Salary Heading, and not show the indivual groups.  the database has account numbers and i know what account #'s i want under each heading; however I cannot figure out how to incorparate this logic into CR 11.5.



Grouping only certain values into a group

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.