March 14, 2012 at 11:32 am
I'd like to include e.g. the name of the user in the title of the report.
The name and id already reside in a dataset Users which is used to populate a picklist which returns the userID as a parameter when the report is launched. (the userID is used to query the main data set on which the report is based.)
It seems I should be able to just lookup into the Users dataset with the userID parameter to return the username. But it seems that the Lookup function doesn't like an @user-id for its first value. Nor can I use the user_id field from the main dataset in the Lookup function (it complains about that).
Do I really have to include the username again as a column in the main dataset? Or create a new dataset just to populate the title? Seems like there must be a way to use the already populated Users dataset..
March 14, 2012 at 12:14 pm
Never mind.. I was using @User_id as the first argument to the lookup function rather than Parameters!User_id.value
Doing it correctly works..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply