Hi Marc,
We could build fetchXml query and visualize it into a SSRS report to achieve your requirement.
e.g:
There is an event, we called it Event X, the event has two sessions: Session A, Session B, and three custom registration fields: question 1, question 2 and question 3.
Clofly Mao registered for session A and gave his reponse to questions.
Viktor Mao registered for both session A and session B and gave his reponse to questions.
To make all of them in one table, the dataset would be below:
| Contact |
Event |
Session |
Question |
Answer |
| Clofly Mao |
Event X |
Session A |
Question 1 |
Lorem |
| Clofly Mao |
Event X |
Session A |
Question 2 |
ipsum |
| Clofly Mao |
Event X |
Session A |
Question 3 |
dolor |
| Viktor Mao |
Event X |
Session A |
Question 1 |
sit |
| Viktor Mao |
Event X |
Session A |
Question 2 |
amet |
| Viktor Mao |
Event X |
Session A |
Question 3 |
consectetur |
| Viktor Mao |
Event X |
Session B |
Question 1 |
adipiscing |
| Viktor Mao |
Event X |
Session B |
Question 2 |
elit |
| Viktor Mao |
Event X |
Session B |
Question 3 |
sed |
A response is associated with one event registration record,
but an event registration record will be associated with many session records,
so Viktors' result will be expanded and thus be duplicated.
Below is my test result in console:
Please follow tutorials below to build a report that shows contact name, event name, associated session name, question and answer in same table:
1. Install necessary tools and packages:
https://readyxrm.blog/2018/07/24/set-up-your-workstation-to-create-sql-server-reporting-services-reports-for-dynamics-365-revisited/
2: Guidance for how to use SSRS tools:
https://readyxrm.blog/2018/07/24/how-to-create-your-first-dynamics-365-ssrs-report/
fetchXml:
javascript code to test fetchXml:
var fetchxml = ''
''
''
''
''
''
''
''
''
''
''
''
''
'';
var query = "?fetchXml=" encodeURIComponent(fetchxml);
Xrm.WebApi.retrieveMultipleRecords("msevtmgt_eventregistration", query).then(
function success(result) {
console.log('ok');
for (var i = 0; i < result.entities.length; i ) {
console.log(result.entities[i]["ContactId@OData.Community.Display.V1.FormattedValue"] " "
result.entities[i]["EventId@OData.Community.Display.V1.FormattedValue"] " "
result.entities[i]["Session.msevtmgt_sessionid@OData.Community.Display.V1.FormattedValue"] " "
result.entities[i]["RegistrationResponse.msevtmgt_customregistrationfield@OData.Community.Display.V1.FormattedValue"] " "
result.entities[i]["RegistrationResponse.msevtmgt_response"]);
}
},
function (error) {
console.log(error.message);
}
);
Regards,
Clofly
Share
Report
895
All responses (
Answers (
