Temporary Table?

[TEM3]

Using Crystal Reports 8.5 I am working with a report on our users essentially using one Oracle table. I have taken an unused field to enter each users supervisor (a short text field). Not wanting to type the full name of the supervisor (plus using a limited size field) I have entered each using the supervisor's 6 character User ID.

The table already contains the User ID (key field) and full name of each user (including the supervisors) along with other user specific information.

In my report I am using a number of groupings, one of which is the supervisor. I would rather not title the group with the User ID, but instead use the Supervisor's name.

Is there a way to dup the table in my report and link my supervisor field to the User ID field and therefore be able to have the Supervisor's name as the group title?

I know I could do this with a formula (if then), but there are a lot of supervisors......

 

[lbass]

If the supervisor ID is also a string, you should be able to add the table again. Go to database->add database->select the table->confirm that you want the table again. It will be named with an _1 extension. Then do the linking as you suggested.

If the supervisor ID is a number, insert a subreport that uses the same table. In the main report, create a formula {@supID}:

val({table.unusedfield})

Then use this as a linking field with the subreport. In the linking screen, use {@supID} as the main report linking field, and use {table.UserID} as the subreport field. In the subreport display on the username. Place the subreport in the group header of the main report instead of the groupname (while still grouping on the ID field).

-LB