Hi,
I am using Crystal 11. I am trying to create a running total for a group of records and I am not successful. I can create the running total in the detail section but when I try it for the group, it does not work. Can someone please help me with the correct formula to create a running...
Sorry to take to long to respond.
They are seperate fields.
If I can do this in a crosstab and create conditional formulas for the columns, that would be great. I do not know how to do that though. Please advise.
Okay, let's try this again.
I am using Crystal XI
here is a sample of the data in the detailed section:
item text licensed provisional pending total
Key Employee 280 280
Key Employee 0 0
Key Employee...
Hi,
I have a report that is providing me data as follows:
name date count
jake 200611 5
jake 200611 3
jake 200611 1
how can I get the report to combine those to provide me with one total for the count? eg: jake 200611 8
Thanks for your help.
here is my formula:
numbervar div := 0;
div := if (isnull({bssp_grades.sem1_eng_score}) or {bssp_grades.sem1_eng_score}= 0)
then div + 0 else div +1;
div := if (isnull({bssp_grades.sem1_foreign_score}) or {bssp_grades.sem1_eng_score}= 0)
then div + 0 else div +1;
div := if...
Here is a sample of the data in no special format. I hope you can follow it:
sem1_en sem1_ sem1 sem1_ sem1_fsem2_ sem2 sem2_ sem2_ sem2_fTota DIV
Allison Michael 4.00 4.00 3.70 0.00 4.00 3.30 3.30 3.70 0.00 4.00 30. 10.00
Clouse M. Violet 3.00...
Thanks Rosemaryl for your suggestion and I am still missing a tweak. Here is what I have thus far:
numbervar div := 0;
div := if (isnull({bssp_grades.sem1_eng_score}) or {bssp_grades.sem1_eng_score}= 0)
then div + 0 else div +1;
div := if (isnull({bssp_grades.sem1_foreign_score}) or...
Can you please let me know if I did this right? i think I am missing something with the syntax.
whileprintingrecords;
numbervar subjects;
numbervar scores
numbervar X;
for X :=1 to 10
DO(
if {bssp_grades.sem1_eng_score} <> 0 then subjects := subjects+1;
if {bssp_grades.sem1_foreign_score} <>...
I have a set of data
eng mat fren sci totalScore avescore
1 0 3.2 2.7 1.9
2 1.2 3.6 2.8 0
the total score is all the grades added for the subjects. however, the average score takes the grades for those subjects that had a grade and finds the average. We...
I newly installed the new crystal reports XI and it was working fine as of yesterday. Now when I needed to open the application I got an error messages which stated that crystal could not load the keydecoded.dll. Has anyone had this error before? Any advice on how I can fix this would be...
I recently bought crystal reports XI professional and I am having problems opening the formula window to create a new formula. I also have issues opening or editing an already existing formula from other reports. Has anyone else ever had this problem. I have tried the uninstall and reinstall...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.