I've got a report that is pulling timesheet information for specific teams.
The team name is OC_NAME and the unique ID is CODE_UID. The timesheet table
just has an entry for the team's Unique ID which I'm returning in a dataset.
Can I do a lookup in Reporting Services Expression to change the CODE_UID
field to the OC_NAME data?


CREATE TABLE [dbo].[MSP_OUTLINE_CODES](
[CODE_UID] [int] NULL,
[OC_NAME] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL

Hello Colin,

No, you could not use the Expression to lookup it. You need to join the
table in the dataset.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.