Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Hillary

  1. Hillary

    Keep Details Section Together

    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...
  2. Hillary

    Keep Details Section Together

    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...
  3. Hillary

    Keep Details Section Together

    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...
  4. Hillary

    Split Function Returns Array Error

    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))...
  5. Hillary

    Split Function Returns Array Error

    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...
  6. Hillary

    Can't get Variable to print with desired record

    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...
  7. Hillary

    Shared Variable reporting more data than I expect

    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...
  8. Hillary

    Show only one mailing lable per address

    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...
  9. Hillary

    Shared Variable reporting more data than I expect

    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...
  10. Hillary

    Remove formatting tags from RTF field

    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...
  11. Hillary

    IN clause not used properly - what else can I use?

    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...
  12. Hillary

    Parameters - defaulting to all

    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...
  13. Hillary

    Parameters - defaulting to all

    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...
  14. Hillary

    Parameters - defaulting to all

    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...
  15. Hillary

    Parameters - defaulting to all

    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...
See more

Part and Inventory Search

Back
Top