Quantity of data and Calculation

[Former Member]

Hello,

I've a Dataset like that:

Number - Creation Date - Complete Date

10001 - 25 Feb 2008 - 21 July 2008

10002 - 25 Feb 2008 - 26 Feb 2008

10003 - 20 June 2008 - 21 July 2008

I'm looking to have a report counting Month by Month how many data were created and Complete:

Month - Created - Complete

Jan 2008 - 0 - 0

Feb 2008 - 2 - 1

...

June 2008 - 1 - 0

July 2008 - 0 - 2

Do you have any example of formula to set-up in Crystal Report ?

Thanks in advance

Alex

Edited by: Alexandre VANNIER on Jul 22, 2008 3:29 PM

[former_member260594 · Accepted solution]

I don't have a sample report but you will need to do the following;

1) You will need to return all the months you want displayed from a datasource. If your data does not include all months you wnat displayed you coudl create a field in your database or an Excel spreadsheet and link it with a left outer join to your current datasource.

2) Group on Month and summarize the creation and completion dates with a count

[Former Member · Accepted solution]

For the 1st Proposal, I can't do a left outer joined because my extract come from a Java Bean, so the DataSet is unique without any Table link, so I don't know how to generate this Month fields.

Concerning the Second proposal, I don't well understand how to do 2 types of Group,

- I succeed to group by "Create Date" and Count, but I've no clue, how to re-use this count

- How I can group again on a Second Parameter "Complete Date", then count and extract this value

Thanks for your help

[Former Member · Accepted solution]

I try to use the Distinct Count, but it needs to set-up groups on each Condition fields (ie: Create Date, Complete Date), so I'm still digging.

Thanks in advance for your help