Recent content by Hillary

The example data is posted in the third paragraph of the original post. I have no control over the code which controls this report. Like I tried to explain, this is not a typical report build off tables which, (to me) explains why the Course is not grouped in the first place. I'm looking to...

The reason I added the Group was so I could use the Keep Group together option. Adding the group did not work. Note: that in order to see the data it was uploaded into our live db. As soon as I saw extra data reporting, I pulled the report out. I didn't spend much time analyzing it. I added...

I am working on customizing a build-in report that came with our software. The report has 1 Grouping, Data.DefaultStudentSort, and 13 Details sections. The data cannot be seen through Crystal; the report has to be uploaded into the software for any data to show. I am trying to keep the...

Nevermind, I found an old post that had the answer. I changed the second and third formulas... //Comment 1 Split ({Data.Comment},chr(13))[1] //Comment 2 If ubound(split({Data.Comment},chr(13),2)) > 1 then split({Data.Comment},chr(13))[2] //Comment 3 If ubound(split({Data.Comment},chr(13),3))...

Hi, I have a report that came with our Student Management Software. This report has a field {Data.Comment}. The field, {Data.Comment} returns comments one on top of another. Example... Great progress A pleasure to have in class Demonstrates positive attitude I changed the report so the...

Hi all, I am working with a report that has Attendance Values printing at the bottom of each student's record. I have been asked to move the Attendance Values up to the Page Header. I created a Variable and I get either 1 of 2 results depending on if I use WhilePrintingRecords or...

The subreport is linked to the main report via School ID and Student ID. In the subreport, my groupings are... G1 - by School G2 - by @Address G3 - by Grade @Student (which is the Shared Variable) and Group #2 Name (which is the address formula) are both in GF2. The Youngest per Address is...

The address grouping must be before another grouping that would "seperate" the records. For example, I use this same type of report for students in a school. I must group the students by address before I group the students by Homeroom. Let's say a report grouped by homeroom then by address...

I have been tasked to create a Mailing Label for our school that only pulls the youngest student from each family (based on each student's address) and sort the results by homeroom. I had already created the Youngest in the Family Mailing Label before I found out about the homeroom sort. I...

Is there a good way to remove all formatting tags off of a RTF field so they don't display on the report? The RTF field I am using, I need to cut apart and only display part of it, when I use the InStr command the tag "/PAR" shows on the report. I used the "Replace" command but if the user...

I have the following formula in a query... DateOfEntryGrade9: IIf([Current Grade Level] In (["09","10',"11","12"]) And IsNull([Date of Entry Grade 9]),"Date of Entry Grade 9 - Null Error",IIf([Current Grade Level]<>["09","10","11","12"] And Not (IsNull([Date of Entry Grade 9])),"Date of Entry...

It didn't work at first then I went into the Parameter>Edit Default Values and added "All" (which Synapsevampire also said to do - I was just too focused on the formula part) to the list and moved "All" to the top of the default list. That, along with Synapsevampire's formula worked! I never...

Hi, I tried to exactly what you said. Please tell me what's wrong. I think when you stated "All" that ment ["N/A", "White", "Native American", "Hispanic", "Hawaiian or Pacific Islander", "Black", "Asian"]...all the Ethnicities but maybe I misinterpreted you. The only reason I went in and...

Sorry, I forgot to include our Crystal version...again : ) Thanks for the reminder. CR 9.0 This kinda works. I am just starting with Ethnicity. My formula is... {CSL_STD_DEMO_DISTRICT.GENDER} = {?Gender} and {CSL_SET_SCHOOL_INFO.SCHOOL_CODE} = {?School Code} and...

I have a report which has fours parameters; School, Grade, Gender and Ethnicity. If a user does not select any criteria for the parameters, the report will automatically pick the first School(304), the first Grade(Kindergarten), the first Gender(female) and the first Ethnicity(Asian) and return...