Crystal 10 Report Help????

[Janet95]

Hi,

I'm extremly rusty on Crystal and I need to create a report for our VP ASAP so I'm in a panic and not having any luck.

I have a table called Calllog
The fields I need in the report are CallLog.ClosedDate and CallLog.RecvdDate.

All I need is a count of records with a CallLog.ClosedDate between / in a weeks time. (Date - Parameter)

And a count of records with a CallLog.RecvdDate between / in a weeks time. (Date - Parameter)

I have tried a crosstab report but the resulting numbers are the same for both fields which is incorrect.

If I query the database with the following I get the numbers I want.


Select Count (*)As CallsIn from heat.calllog
where Recvddate between '2007-05-05' and '2007-06-05'
Result = 1088

Select Count (*)As CallsClosed from heat.calllog
where closedDate between '2007-05-05' and '2007-06-05'
Result = 668

Now when I build my crosstab report the result is 246 for both.
Where / How should I start????

Thanks
Janet

 

[Turkbear]

Hi,
Try this instead of a cross-tab

Create 2 formulas:

@RDate
If Recvddate between '2007-05-05' and '2007-06-05'
then 1 else 0

@ClDate
If
ClosedDate between '2007-05-05' and '2007-06-05'
then 1 else 0


Place these formulas in the details and supress their display
( you can even hide the detail section, unless you want some other information for each record)

For each formula insert a Grant Total - SUM Of

Label them for clarity..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Janet95]

So should I keep my Parameter field called date range?

Thanks
Janet

 

[Turkbear]

Hi,
Sure, just substitute in the formula:


@RDate
If Recvddate IN {?YourDateRangeParameter}
then 1 else 0

@ClDate
If
ClosedDate IN {?YourDateRangeParameter}
then 1 else 0

Should work fine..



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Janet95]

OK I tried that but it didn't work. Not sure if I'm doing it right.
I get the error message ... "The remaing text does not appear to be part of the formula."

Thanks
Janet

 

[Turkbear]

Hi,
I just tried it and it seems to work:

@RDate

If Recvddate IN {?YourDateRangeParameter}
Then
1
else
0

What does your error show as the 'remaining text'?



To Paraphrase:"The Help you get is proportional to the Help you give.."