Search results for query: *

Thanks LB, This is really close, but the following results are being returned. Employee has 99 records in Class Roster table. Report returns 99 records, all saying not registered (as my selected class in the parameter was not one of the ones they have done.) How can I display a record that...

Thanks lbass, but I really need to have some way of restricting the classes also, as there are over 5000 of them. Any further ideas, maybe using subreports or something would be great. My LMS uses a custom application for people to read the crystal reports, and this allows them to filter on...

Apologies for the length of the post, but I don't know how else to describe the problem. I am using CR8.5 I am writing reports to extract data from a learning management system with the following structure Table 1 Employee table Emp_PK Emp_LName etc Table 2 Class Roster table Emp_PK Evt_PK...

Thanks, I also need to be able to display a running total count for data (people in levels 4,5 and 6) against the organisation name in level 4. Any help with this would be appreciated. The context is a training database that records when people have registered, completed or cancelled from...

I am using CR9 and Microsoft SQL database. I have an organisationl hierarchy that includes a number for the level of the organisation. I want to be able to find records of people in the bottom org level but display (and group on) the name of the department that is several levels above theirs...