Jump to content
  • 0

How can I use a lookup table in report page?



This is a tricky one. I haven't found any solution yet. In a details report page, one field of my data source is an ID and I would like to show its description from a lookup table rather than the value of the ID itself.

Is there any way to achive that? Thank you.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello @Paolo,

This should be possible in case you have a unique ID field in the lookup table.

In this case you can set one-to-many relationship between lookup table and your data source table (that you use for a Details DataPage) and link the tables by ID field.

In the Relationship Settings check the Use display value on DataPages checkbox and select the Description field in the Display Value dropdown.


I think, these articles will be helpful 


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...