Ba2sai Posted May 8, 2017 Report Share Posted May 8, 2017 Sharing this in case you need to show the text instead of ID value in report datapage. Steps: 1) Make sure you have a table that has your lookup values 2) Add a Calculated Field in your Tabular Report DataPage and insert the code below SELECT LookUpTableDisplayText FROM LookUpTable where LookUpTableIDvalue='[@field:IDFieldInDataPage]' 3) If you want to hide the ID column, you can use the steps below. Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted July 5, 2017 Report Share Posted July 5, 2017 This tutorial explains how to enable this option http://howto.caspio.com/tables-and-views/relationships/relationship-settings/ Quote Link to comment Share on other sites More sharing options...
Question
Ba2sai
Sharing this in case you need to show the text instead of ID value in report datapage.
Steps:
1) Make sure you have a table that has your lookup values
2) Add a Calculated Field in your Tabular Report DataPage and insert the code below
SELECT LookUpTableDisplayText FROM LookUpTable where LookUpTableIDvalue='[@field:IDFieldInDataPage]'
3) If you want to hide the ID column, you can use the steps below.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
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.