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!

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

Search results for query: *

  • Users: ggies07
  • Content: Threads
  • Order by date
  1. ggies07

    Adding two formulas

    Hi Everyone, I know I'm not connecting something somewhere, so I need your help. I have made calculations in each formula and now need to add them together - simple, but not. haha Here is my code: Group 1 - student Group 2 - class Group 3 - StudentWorkList_.Excuse Type (which is divided by...
  2. ggies07

    Formula to choose the latest date?

    Hello, I'm dealing with enrollment dates. Some students leave and then come back so they then have multiple enrollment dates. The online database we use can not pull the latest one, so is there a way to do this in a formula? Say a student enrolled in 2018, left, but then came back last year...
  3. ggies07

    Formula Errors when adding new Excel file

    Hello, I have always used .mdb files in Crystal Reports, but now I have to export data from our online database as an Excel file. So I figured out how to insert it into CR and create my report, but I always get this error message when I try and insert an updated excel file: "Some tables could...
  4. ggies07

    Grouping

    I have a very odd grouping problem that I can't seem to figure out.....This report I've been using year after year, now they want it sorted by homeroom teacher, while still having the child's name. Every time I switch the first group from parent name to Homeroom teacher name, it puts only a few...
  5. ggies07

    Formula Change

    Hello, I need to change a formula in a report I did not create. Here is the code. I need to delete and insert the status date the child enter the school after the bolded part. So an example would be Child's name - status date. Thanks! ]WhilePrintingRecords; StringVar Student1; StringVar...
  6. ggies07

    Formula Creates Dups

    Hello, I have this formula that I created: If {StsAttrsSpecAttr_5.StsAttrsSpecAttr_5_Date} >= Date (2013,08 ,22 ) then "AO" It works fine, but creates dups in the report for any student that has more than one "Applied Out" Attribute. I thought putting the date in formula would suppress...
  7. ggies07

    Copying Details Section

    Hello, I need to copy my details section so that it appears on the page 3 times. The report has one group, by Homeroom Teacher, and the only data in the details section are names. I can't seem to figure it out, either by adding more detail sections or a subreport. Any help is much...
  8. ggies07

    Changing Group Order

    Hello, This report I'm using is set up to print name tags for an event we have at our school. Usually I just print all the name from the report so we don't miss anyone. But this year we are doing RSVPs and I need to change the order of the group to only pull the names that have already RSVPed...
  9. ggies07

    Ordering/Sorting

    Hey All, I work for a school and have a report that uses a subreport. The subreport is linked using the student's system ID number so that the contact info syncs with the right student. That way in cases where there are lots of Johnsons, Smiths, etc. the contact info is not going to the wrong...
  10. ggies07

    Contact type Question

    Hey guys, I have this report that was created by someone else before I got to this job. I am going to explain how it is set up and show you the details of the report and the formulas. We are a school with regular couples and then we have partners (same sex). This report makes the Parent 1 -...
  11. ggies07

    Calculating Age with decimals

    Hello, I got great tips from this thread referenced below, but it only gave me whole numbers and I can't seem to find where in the formula to insert coding that makes it turn into decimals instead of whole numbers. I need to add 3 months to the birth date, but still have the new number come out...

Part and Inventory Search

Back
Top