Print Page | Close Window

Doubts with Crystal Reports

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19890
Printed Date: 02 May 2024 at 4:46am


Topic: Doubts with Crystal Reports
Posted By: fsilvabrasil
Subject: Doubts with Crystal Reports
Date Posted: 15 Aug 2013 at 1:41am
Good Morning

Dear friends I am having trouble with Crystal, was developed a report in Crystal to the "Summary of Basic Basket" of classes of a company is the problem in time for him to bring the final result of each class. each class has a column of active and missing certificate and the period indicated.

this wrong.

Class    assets attestation lack
57232     91        0            18
57233      118      22            0
57305      165      3              2
57376       129     8              31
66841       129    10             43
69282       127    13             51
69283       128    19             57
69334      129     17             75

data that are certain are that made the hand checking.

Class              assets   attestation   lack
57232                91            0             18
57233                118          0             11
57305                165          3              1
57376                129          5             13
66841                129          2             14
69282                127          3             10
69283                128          2              5
69334                129          2              3

was created formulas

1st Formula
/ / Shared variable:
/ / Group header 2:
shared absence numbervar: = 0;
"" / / Hide the zero

2nd

shared numbervar absence;
/ / Shared numbervar fault;
if (Sum (AGR_FALTA_ATESTADOS_V.ATESTA {}, {} AGR_FALTA_ATESTADOS_V.CD_FUNC))> 5
then absence: absence = 1 / / i do not know what makes the fault
"" / / Hide Increasing the number

3rd

shared numbervar totAbsence;
shared numbervar absence;
if absence> = 3 then totAbsence: totAbsence = 1;
"" / / Hide the full incrementing

4th
shared numbervar totAbsence;

were created these formulas can see that the values ​​sum when they bring the values ​​of the second group forward. coloqueis two to compare.

Someone to help me need urgent response who can help will be grateful.



Print Page | Close Window