Combinine summary fields

[agreen10]

Hi,

I have a report that is providing me data as follows:

name date count
jake 200611 5
jake 200611 3
jake 200611 1

how can I get the report to combine those to provide me with one total for the count? eg: jake 200611 8

Thanks for your help.

 

[TheBlondOne]

try this

{first.Field} & {second.Field} & {Third.Field}

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[TheBlondOne]

sorry should have been

{First.Field} & " " & {Second.Field} & " " & {Third.Field}


-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[agreen10]

Thanks!

 

[lbass]

You should insert a group on a formula like this:

{table.name} + " "+totext({table.date},"yyyyMM")

Then right click on the field you are counting in the detail section and insert a summary (sum, not count). Then drag the result into the group header and suppress the detail section and the group footer.

-LB

 

[agreen10]

Okay, let's try this again.
I am using Crystal XI

here is a sample of the data in the detailed section:

item text licensed provisional pending total

Key Employee 280 280
Key Employee 0 0
Key Employee 6 6

How can I get this to print?

Key Employee 280 0 6 286

 

[lbass]

What does this have to do with your previous post? This is a different issue. What are we seeing here? Is this a manual crosstab where you have created conditional formulas for the columns using {table.item}? Or are "licensed", "provisional", etc., separate fields?

-LB

 

[agreen10]

Sorry to take to long to respond.

They are seperate fields.

If I can do this in a crosstab and create conditional formulas for the columns, that would be great. I do not know how to do that though. Please advise.

 

[lbass]

This doesn't make sense for a crosstab. All you need to do is insert a group on the key employee field, place the other fields in the detail section, and right click on each and insert sums at the group level. Then suppress the detail section and drag the group name into the group footer.

-LB

 

[agreen10]

That Worked. . . Thanks.