<p>Hello,</p>
<p>I need to create a report like in example file.</p>
<p>The columns with question â„–* (there will be questions from database) must be dynamic in different situations and in this column will be applicant's answers for this question. So I think I should use crosstab, but I don't know how to organize the data cube for this cross tab.</p>
<p>I created data set with params:</p>
<p>- date</p>
<p>- time</p>
<p>- name</p>
<p>- operatorName</p>
<p>- applicantName</p>
<p>- phone</p>
<p>- serviceName</p>
<p>- name</p>
<p>- question</p>
<p>- answer</p>
<p>- decline</p>
<p>And then put this params to data cube</p>
<p>Group1:</p>
<p>- date</p>
<p>- time</p>
<p>- name</p>
<p>- operatorName</p>
<p>- applicantName</p>
<p>- phone</p>
<p>- serviceName</p>
<p>- name</p>
<p>Group2:</p>
<p>- question</p>
<p>- answer</p>
<p>Summary field:</p>
<p>- question</p>
<p> </p>
<p>But i think it's wrong way. And another problem - the last column "decline" value depends on answers in questions column. How can I add this column after crosstab?</p>
<p>Thanks.</p>
