Combining Fields

[Johnkylex]

I have a table with field headings with similar data of headings..then there are entries like this

Code1 Code2 Code3 Code4
Usage
Usage OpPanel
Symptom Prntqual Roller Used
Usage
Symptom Prntqual Cart Refilled

What can I do to have crytsals calculate the number of issues for each entry. The sum feature will only calculate on one CodeX. But I want Crystals to consider the whole line and calculate the number of occurances. Then I want Crystals to print out each entry and the number of times it occurs. The print out will show code1 code2 code3 code4.
Here is an example of what I will need...
Usage 2
Usage OpPanel 2
Symptom Prntqual roller uses 1
Symptom Prntqual Cart Refilled 1

THANKS!!!

 

[dgillz]

You need to concatenate your 4 fields togther in a formula field. Then summarize on that field and do a count summary.

Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Johnkylex]

Can you give me an example of what that formula would look like?

THANKS!!!

 

[dgillz]

{field1}+{field2}+{Field3}

If any of these fields are numeric, date, etc., you will have to use the totext() function to convert them to text, then concatenate them.

Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Johnkylex]

Great...that works...now...two more things...
1. each group is now one work...how would I insert space to define each one even though it is considered one field now?

2. What is the format of formula I would use to make Crystals recognize any code field that is blank...in my case all four code fields must include something in order for it to calculate...what formula do I enter to make crystals count even the null fields?

THANKS!

 

[dgillz]

Create 4 formulas, one for each field:

if Isnull({field}) then " " else {field}+" "

Again you may have to use the totext() function as needed.

Thenuse the first formula I gave you to have all fields, including null values, separated by a space. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Johnkylex]

This is what I have, however it only shows in the report the entries that have all five levels filled. It is still missing the ones that have some blank code levels.
totext ({443 MFP Life Database.TRACK_1});
totext ({443 MFP Life Database.TRACK_2});
totext ({443 MFP Life Database.TRACK_3});
totext ({443 MFP Life Database.TRACK_4});
totext ({443 MFP Life Database.TRACK_5});

if isnull ({443 MFP Life Database.TRACK_1}) then " "
else
{443 MFP Life Database.TRACK_1}+ " ";
if isnull ({443 MFP Life Database.TRACK_2}) then " "
else
{443 MFP Life Database.TRACK_2}+ " ";
if isnull ({443 MFP Life Database.TRACK_3}) then " "
else
{443 MFP Life Database.TRACK_3}+ " ";
if isnull ({443 MFP Life Database.TRACK_4}) then " "
else
{443 MFP Life Database.TRACK_4}+ " ";
if isnull ({443 MFP Life Database.TRACK_5}) then " "
else
{443 MFP Life Database.TRACK_5}+ " ";


{443 MFP Life Database.TRACK_1}+ " " + {443 MFP Life Database.TRACK_2} + " " +{443 MFP Life Database.TRACK_3} + " " + {443 MFP Life Database.TRACK_4} + " " +{443 MFP Life Database.TRACK_5}