Search results for query: *

Problem has been solved. Thanks everyone!

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

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.

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

thanks!

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

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

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

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

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?

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

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

Thanks Dell. After posting this and playing around, I figured out how to do that. much appreciated though. :)

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

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

Thanks!

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

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

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

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