Calculation in reports

[Former Member]

Hi

Table structure

pointdescription Pointvalue evaluationfrom evalutionto

a 4 01/01/2007 10/01/2007

b 3 01/01/2008 12/01/2008

a 2 01/01/2008 12/01/2008

b 2 01/01/2007 12/01/2008

i want to dispaly report like

pointdescription Total css where description were rated less than 4 difference

previous year current year

a 0% 2% 2%

b 3% 2% -1%

Means i want to dispay records only rating less than 4 . user will enter previous year and current year.

How to calculate value?

Thanks

[Former Member]

Hi

Thanks for your explaination, my problem is solved.

[Former Member]

Pointvalue is string, not integer. how to sum pointvalue, if it is string?

How to use data parameters in report record selection formula?

[Former Member]

Pointvalue is string, not integer. how to sum pointvalue, if it is string?

Ok use the same Total Count method you are using, however like this

Name: PointValue

Summary Field: Pointvalue field

Summary Type: Count

Evalution: Each Record

Reset: Group by, Group name

Then place it into the report.

How to use data parameters in report record selection formula?

Ok create two date parameters, static.

One Start Date, Field type (your database field). Value=Date or Datetime (you choose depending on database field type).

Second End Date, Field type (your database field). Value = Date or Datetime (you choose)

Then Click on Report ->Selection Formula-->Record

Type

{database field} >= {?StartDate} and

{database field}<= {?EndDate}

Place both of them into the report header.

Run the report and you will be asked for the dates, once inserted your report will be filtered by date range you entered.

Hope this helps

Regards

Jehanzeb

[Former Member]

Ok now I get it, you are doing it totally wrong here.

Firstly suppress the details section and group header section of the report.

Secondly, you do not need to enter {ASPECT.EvaluationFrom} > {?ef} and {ASPECT.EvaluationTo}<{?et} on each evaluation of the running total.

Thirdly, you have click on "Reset" on change of group and then select the group name in the drop down menu.

Forthly, if you still do not get the right values from implementing the above, try changing the Count into Distinct Count and run the report again.

Fifth, the value {ASPECT.PointValue}<'4' should be written as {ASPECT.PointValue}<4, as this is an integer value and crystal will read it as integer, if you change it to "" then it will read as string value which this isn't.

Sixth, where are you date value parameters? They need to be on the report Record selection formula so that the report utilise the dates given by the user in the report.

Please do all of the above and see if that works.

Many thanks

Regards

Jehanzeb

[Former Member]

Hello,

Are you trying to get percentages from last year? If you are then why not use percentofDistinct Count?

Could you be more specific please as to what you are trying to achieve as your initial description varies from your resulted description.

Many thanks

Regards

Jehanzeb