Hey guys,
I made a table that gets certain variables from a form once the form is submitted. The table is as follows:
This table gets User Names, the RITMs and the Date variable from the form.
I wanted to create a report with all three of these variables but in the report, only the User name and the RITM is being displayed and the Date appears blank:
What can be the reason for this and how do I fix this?
Thank you!
You need to add your variables to the Selected list in the upper right-hand corner of that screenshot:
So go to Available and scroll down to variables and go from there.
Please mark reply as Helpful/Correct, if applicable. Thanks!
Hey Allen,
Thanks for you reply. Unfortunately, I have tried that and it doesn't work for whatever reason...
So, I go into variables, dot walk and manually add the date field and it looks like this:
But when I save it, it is gone from the top right box as follows:
I do not know why it goes away when I save / update it..
Any other way to accomplish it?
It's not just the date one.
It is any variable added manually through dot-walking to the catalog item. I don't think something is wrong with all of the variables.
My main problem is that in the report, I am obtaining the Data from a table called u_office_365_users. This is the table:
When I create a report,
In Data, I put the table name (u_office_365_users), in Type, I put List, Group By is None.
From that table, it pulls in the columns that table has and I add "Add User", "Requested Items" and "Date" as shown above in the screenshot. However, everything appears the same, except the Date.
I don't think it is a variable problem because it appears in the table fine.
Is there anything else that might be causing it to not get the Date from the table?
