Database View for HR Multi Row Variable Set
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
We are trying to create a report that lists all of the employees entered through a Multi-Row Variable Set (MRVS) on separate lines on the report.
On our form, a script generates an HTML table using the data from a Multi-Row Variable Set. We use the MRVS to allow users to add multiple employees to a single request, and the HTML table displays those entries on the form.
We would like to create a report that lists the individual employees from the MRVS. Has anyone successfully reported on MRVS data, or is there a recommended approach for making the individual rows available for reporting?
We ultimately are trying to capture this data to put into an EIB to upload to Workday so we would need each employee listed out on separate entry lines even though they were captured in the same field on the form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @HRHngo3760,
OOB reports doen not support Multi Row variable set(MRVS). MRVS treated as table can't flattering record in report.
Recommendation steps :
- Transform the Multi-Row Variable Set (MRVS) data into a child table or another report-friendly data structure.
- Store each MRVS row as an individual record linked to the parent request.
- This enables each employee to appear as a separate record for reporting and exports.
Follow related threads :
https://www.servicenow.com/community/itsm-forum/how-to-add-the-multi-row-variable-set-in-the-report-...
https://www.servicenow.com/docs/r/servicenow-platform/service-catalog/c_ServiceCatalogVariableSets.h...
Parallel, You can raise HI support ticket to get with more details.
Please mark helpful & correct answer if it's worhty for you.
