Search results for query: *

You are right. I still had the count within the max and min formula. So removed it from @accum formula. Thanks very much again. Learnt alot from your help.

Thanks but the issue with that that is I need the maximum(datetimestamp,ID) before I can evaluate to get distinct count. New day and clearer head. Whilst the evaluation criteria is maximum(datetimestamp,ID)forcing me to create #GRP1 ID #GRP2 VAR Regardless of what I do the results will...

The result of that will be ID VAR DateTimeStamp 90009 G8 24/5/09 00:00:00 90009 G8 24/5/09 11:00:00 90009 G8 24/5/09 12:00:00 90009 G99 24/5/09 13:00:00 90009 G99 24/5/09 14:00:00 90009 G99 24/5/09 14:30:00 90009 G99 24/5/09 14:50:00 ID VAR...

Crystal XI to Access 2007 database I have the following data ID VAR DateTimeStamp 90009 G8 24/5/09 00:00:00 90009 G8 24/5/09 11:00:00 90009 G8 24/5/09 12:00:00 90009 G99 24/5/09 13:00:00 90009 G99 24/5/09 14:00:00 90009 G99 24/5/09 14:30:00 90009 G99...

Thats excellent!! I made a minor change removing cnt from @accum formula as it was doubling. Thanks very much for your time

I re-tried your original formula. The result of variables secs/cnt was returning a very small value. whileprintingrecords; numbervar secs; numbervar cnt; if maximum({@Start},{table.ID}) = true and maximum({@Archive},{table.ID}) = true then ( secs :=...

Great thanks very much. I do still need to calc average but cannot get total of variable secs. I've tried minor changes to formula but to no avail How can I get this with new formula?

Thanks. The dd:hh:mm differences per {table.id} are being calculated correctly. I have a new requirement - Out of all of the {table.id} dd:hh:mm differences how can I identify the minimum and maximum dd:hh:mm. That is the minimum dd:hh:mm for report as whole? Appreciate your help

Hi Purpose of report is to provide a count of records per customer within a parameter defined date range. Report looks like Group Header - Group #1 - Groupname{Customer} Group Footer - Summarized Distinct count {x.orders) The orders fields is string value. When I run the report and there are...

Crystal XI connected to Access 2007 Simple question. I have a Group on names. I would like the group names to display regardless of no results. e.g. Customer 1 0 Customer 2 0 Customer 3 0 I have multiple group headings and would like to display each. Standard way I would do this is...

Apologies I didnt see your 2nd response & assumed I hadnt explained issue clearly. Thanks for assistance.

Hi Using Crystal XI to Access 2007 database Group # ID Start date End Date @Start @Archive 1/5/09 1/5/09 True False 12/5/09 12/5/09 False True 30/5/09 31/5/09 False True For each Group #ID I and @Archive = True I need to confirm...

Thanks. I resolved via creating new table containing only required detail and linked via inner join back to main table.

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"...

Sorry yes, each unique record = ID. I need the difference between the first and last dates for the group so can calculate aggregate values for report as whole. e.g. Group - ID 1111 Start Date End Date @start @archive 5/5/09 12:00:00 5/5/09 12:00:00 True False...

Access 2007 database, Crystal XI Need to calculate difference between two date/times in days,hrs, mins also calculate an average if item critera has meet "start" & "archive" status. See example Each record has a unique id. Therefore have applied a group to ID. Created a formula to identify...

Access 2007 Database, Crystal XI Creating a report that requires a count of list of items e.g Name Number #Set 10 #Set1 12 #Partial 13 #Complete 20 Counts were initially counted in VB and then passed to Crystal. I would like to calc in Crystal. The Report is to only take...

Sorry I should have added the data within the Access database was converted (& supplied) from SQL 2005.

Using Crystal XI connected to Access 2000 database. I want to create a Group via selection of memo type field. The field I require is NOT displayed in fields I can group on. Why is this? Do I need to convert field type? Thanks in advance.

Using Excel 2003 Is it possible to automatically create monthly columns based on a @datediff calculation? For example: @datediff result is based on columns the difference between columns C & D say 1/12/07 - 1/12/08 = 12 months Is it possible to automatically create columns Dec '07, Jan'08...