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 NULLHello 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment