Subreport

[IceRuby]

Crystal XI, Access 2007 database

I need to create a distinct count of record ID's in seperate workflow stages.

There are multiple instances of the record ID as it passed through stages of life cycle.

The workflow has various stages. The ones I need to track are "Start", "DataEntry", "Form", "Except"

The workflow has to actually have started before any other workflow stages can be tracked. Therefore I created a list of all record ID's listing workflow = "start".

I thought the best way to do this may be link a subreport and match record id's so I am always comparing to the confirm records Id's that had started.

Is this correct?

 

[Madawc]

Try Crosstab - you should find it under 'Insert' on the menu. This can group data separately from the report, without the need to access the records again, which is what happens with a subreport.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

I think you would be better off adding an alias of the same table that is linked on ID, and then use a record selection of the following using the first table:

{table.workflow} = "start"

Then you can reference table_1 fields for the various work stages.

-LB