Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, i am a new user with Crystal

Status
Not open for further replies.

smut

Technical User
Nov 15, 2001
10
GB
Hi,

i am a new user with Crystal and really need some help please. I am using CR 8.5

What i want to do is show a count of records in a field. Although i only want the records shown for dates in which is selected in the parameter value.

To give you some idea of the functions in which i have used already &quot;<&quot;,&quot;upto&quot; and &quot;in date&quot;.

This is the line of code i am trying to produce data for. It looks as though it should work, but doesn't:
{QCallsStatus.Status} = &quot;Open&quot; and {Calls.DateOpened} = upto {?start date}

When i check the code it displays the box &quot;No errors found&quot;. So the code is o.k.

It displays results, but not the results i want. It seems to show a count of all records within that month.Basically all i want is a count of all records of calls that are &quot;open&quot; inwhich haven't been closed. Showing all records before the start date selected in the parameter

please help

Chris
 
The following is a direct quotation from &quot;Crystal Reports 8.0 for Dummies&quot; by Douglas J. Wolf: &quot;WARNING! Just because Crystal Reports examines the formula and determines that it is properly constructed, that doesn't necessarily mean the formula is correct. In a simple formula like the one in (the orders detail) example, you can feel confident that the results of the formula are correct. But, if the formulas you create are highly intricate, they can give the wrong results -- even if they're properly constructed. Be aware of this possibility and use a common-sense approach to the results you get when you check a formula.&quot;...I couldn't have said it better, hence the quote.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top