Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: if help Post Reply Post New Topic
<< Prev Page  of 3
Author Message
fabrizio
Newbie
Newbie


Joined: 10 Dec 2012
Online Status: Offline
Posts: 15
Quote fabrizio Replybullet Posted: 13 Dec 2012 at 11:22pm
I putted all the fields on the body report and everything is as I expcted
 
Local numberVar x :=x ;
Local numberVar y :=y ;
Local numberVar z :=z ;

 x :={#nr_Vitellini};
 y :={#nr_Vacche};
 z :={@diff_vit_vac};

if ({VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J10B*' and {#countCapre}>0) or
({VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J09B*' And {#countePecore}>0) or
({VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J11*' and {#countScrofe}>0) or
({VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J02*' and (x<=y))
then
0
else
if {VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J02*' and x>y then
 z*{VR_CLASSIFICA_PS.PS}
else
{VR_CLASSIFICA_PS.PS_AGG_NO_P}
 
I added z as difference between vitellini and vacche . It works on the body report but not in the formula
IP IP Logged
fabrizio
Newbie
Newbie


Joined: 10 Dec 2012
Online Status: Offline
Posts: 15
Quote fabrizio Replybullet Posted: 13 Dec 2012 at 11:36pm
Maybe I understood where is the problem I can't read the code wich start with the same letter J02 J07 because if I punt vitellini(J02)=34 on the body record I have the same value for J04 J06 J07 but the real value for J04 is =0 and J06=0 and J07=21
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 14 Dec 2012 at 4:21am
Sounds like you may not be grouping correctly, how is the report grouped, where are you putting the values in the body of the report.

sounds really like an evaluate issue with the running totals.

Copy and paste the evaluate code from the running totals in question.


IP IP Logged
fabrizio
Newbie
Newbie


Joined: 10 Dec 2012
Online Status: Offline
Posts: 15
Quote fabrizio Replybullet Posted: 14 Dec 2012 at 4:42am
 
I putted  the values in the details part in the body of report
 
 
sum of VR_CLASSIFICA_PS.DIMENSIONE (#nr_vacche)
{VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J07*' or {VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J08*'
 
sum of VR_CLASSIFICA_PS.DIMENSIONE (#nr_vitellini)
 
{VR_CLASSIFICA_PS.ID_ATT_ORIG} like "J02"
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 14 Dec 2012 at 5:46am
{VR_CLASSIFICA_PS.ID_ATT_ORIG} like "J02" should be

{VR_CLASSIFICA_PS.ID_ATT_ORIG} like '*J02*'

Edited by comatt1 - 14 Dec 2012 at 5:47am
IP IP Logged
fabrizio
Newbie
Newbie


Joined: 10 Dec 2012
Online Status: Offline
Posts: 15
Quote fabrizio Replybullet Posted: 19 Dec 2012 at 12:06am

It works Smile .... I'm very happy and my boss too.......... I have to say thanks to you for your incredible help, the problem was the order of the values on the report

IP IP Logged
<< Prev Page  of 3
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.