Selection formulas with calculations used later in report

[redbunny78]

Using Crystal 9 and Oracle

I am trying to create a report that shows the number of times a workstation is showing up in the table as receiving the same distribution and is successful.

For example, I have a table 'Logs' that shows the following data:

Pushdate Endpoint Suite Result
10/31/2007 12:20 AM wtoengrxp0071 Office_FileFormat Success
10/31/2007 12:21 AM wtoengrxp0071 Office_FileFormat Success
10/31/2007 12:22 AM wtoengrxp0071 Office_FileFormat Success
10/31/2007 12:23 AM wtoengrxp0071 Office_FileFormat Success
10/31/2007 12:24 AM wtoengrxp0071 Office_FileFormat Success
10/31/2007 12:25 AM wtoengrxp0071 Office_FileFormat Success
10/31/2007 12:30 AM wtoengrxp0071 Office_FileConv Success
10/31/2007 12:31 AM wtoengrxp0074 Office_FileConv Success

I want to show year to date just the workstations that are showing up as receiving the same distribution successfully five times so the output would look something like this:

Pushdate Endpoint Suite Count
10/31/2007 wtoengrxp0071 office_FileFormat 6
11/1/2007 wftoevtxp0034 win_xp_2007 35
11/4/2007 wxparcxp0056 sap_xp_gre 78

I have tried several routes but keep running into problems trying to use the same calculation in the select formula that I use later in the report. Any advice or suggestions is greatly appreciated.

 

[IanWaterman]

Group report

Grp 1date
Grp2 Endpoint
grp3 Suite

Suppress details, all group headers and group 1 & 2 footers and place the fields,

Add date, endpoint and suite and a summary to grp3 footer which counts endpoints.

In group selection

count(endpoint, suite) >= 5

Ian

 

[lbass]

You would need to either use a record selection formula of:

{table.result} = "Success"

...in conjunction with Ian's suggestion, or if you need the failures to show up on the report, create a formula:

//{@success}:
if {table.result} = "Success" then {table.pushdatetime} else datetime({@null})

Create a formula {@null} by opening and saving a formula without entering anything. Then go to report->selection formula->GROUP and enter:

count({@success},{table.suite}) >= 5

-LB

 

[redbunny78]

That worked perfectly! Thanks so much. That was much simpler than what I was doing.

Thanks again