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: *

  1. ggies07

    Adding two formulas

    Problem has been solved. Thanks everyone!
  2. 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...
  3. ggies07

    Formula to choose the latest date?

    awesome! I thought it could be done, just didn't know what criteria to use. Thanks so much! You are a life saver of work because I was going to have to go another route, which included entering data in a new place, if I couldn't get this figured out. Much appreciated. Cheers.
  4. 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...
  5. 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...
  6. ggies07

    Grouping

    Well, I'm not directly dealing with SQL code tables. Our database has a GUI interface, so the way I see it is the parents names are on the Relationship tab on the student's record. Now, there is an Individual section in our database and that is where the parents records are located. Maybe I...
  7. ggies07

    Grouping

    I can get the parents to show up in the right homeroom teacher group, it's just adding the student + plus their teacher back under the parent names.......
  8. ggies07

    Grouping

    interesting....I'll see what I can do. If it helps, I'm using a .mdb file from our database. Each child has their own record with the homeroom teacher name on it. So I'm pulling an export from the student side with that info: student name, homeroom teacher, parent names. after reading your...
  9. ggies07

    Grouping

    it like the homeroom field I use to group with does not separate from the field that goes by the student's name in the report.....does that have to do with pulling it from the database or just setting it up correctly?
  10. ggies07

    Grouping

    Hey Dell, That makes sense. Though I've tried starting with a group by homeroom, then adding the student relationship names (parents), but I get stuck where every child of the family prints out under the Parent name. side note - these are name tags and in the past it has the parents name and...
  11. 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...
  12. ggies07

    Formula Change

    Thanks Dell. After posting this and playing around, I figured out how to do that. much appreciated though. :)
  13. 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...
  14. 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...
  15. ggies07

    Copying Details Section

    no, I just meant I didn't do the subreport the right way in the past before asking about it here. I just didn't configure it probably. It works now thanks to you! One more question. That works and makes it appear twice, but I need three times, so I copied the subreport again and inserted it into...
  16. ggies07

    Copying Details Section

    awesome! Thank you for the direction. :) I had tried a subreport, but didn't get it right, obviously....hahaha.
  17. ggies07

    Copying Details Section

    It's a really simple report - just names of students grouped by Homeroom Teacher, one group per page. It's a sign-in sheet that one of the directors wanted, but they wanted the group of students three times on the page since it doesn't take up that much room and so they won't have to print it...
  18. ggies07

    Copying Details Section

    Thank you BettyJ, but I already knew how to do that and tried it. It just adds the same names in the group right onto of the first detail section. I need each group on it's on page and the detail section on it 3 times. It's weird I can't do this. It's simple data, just names....

Part and Inventory Search

Back
Top