List values from groupe to summary.

[gazol]

I´m bulding a report that i select a specifik field from with a parameter field. The field can contain (numbers and) text. The type of the field are string (with 255).

The report groupes the different types of things inputted into the fields an does a count on them that gives me a output like:

08:00 am
|The color whas red | | 1|
|The color whas blue| | 3|
|3453 | |99|
|Test | | 4|
09:00 am
|The color whas red | | 3|
|The color whas blue| | 4|
|3453 | |56|
|Test | | 5|

and so on ....

(this is also grouped on TIME)

This works exactly as i want, how can i make a summary of the fields at my report footer for a total of all the counts to the summary ??

I need to display all the possabilities from my groupes (data) and a summary for them like

Summary
I'm using crystal 8.5 and oracle database.

 

[gazol]

The problem is that it can be many possibilites of text in the fields so i dont know what they contains.

How can i get all of the possibilites printed out and an summary of the count of how many there was on the different types.

I need a formula that can print out all the posibilites and count them who are equal or singel..

Thanks for the help !

Regards / Gazol

 

[lbass]

If you mean you want to ignore the time groups in the report footer, then insert a crosstab and use the string field as the row and count of the string field as the summary.

-LB

 

[gazol]

Exactly what i wanted ! Works perfekt, Thanks LB