Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
store xml string in a variable
Arif shah
<p>Hi,</p>
<p> </p>
<p>I am trying to store an xml string from a dataset row into a pgv. However, when I try to retriew the string from pgv, it removes all the xml tags from the string. I don't know whether these xml tags are removed during the creation of pgv or during the retrieval of the pgv.</p>
<p> </p>
<p>Can someone please tell me what is the best way to store an xml string into a variable without the tags being removed</p>
<p> </p>
<p>Regards</p>
<p>Arif</p>
Find more posts tagged with
Comments
Clement Wong
<p>What version are you using? Do you a have a simple example that illustrates your issue?</p>
<p> </p>
<p>If you are storing a string in a PGV, the string will not be stripped of the XML tags. In my attached example, I am storing an XML string in the beforeFactory event. The complete string is displayed in the final report output. No XML tags were stripped or removed.</p>
<p> </p>
<p>To make sure everything was working in my example, I added logger events (available in commercial BIRT) that writes directly to the Eclipse Error Log in the IDE UI. You'll see the beforeFactory and beforeRender writing out the PGV to make sure that entire string was not modified.</p>
<p> </p>
<p><em>Tip: If you don't know where in your code is failing, you can either add debug/logging statements or use the Eclipse Debug mode to walk through your code.</em></p>
<p> </p>
<p> </p>
<p>BTW, I've replied in the other thread regarding using the reading your web service directly in a Scripted Data Source instead of storing it a PGV @ <a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/topic/36942-scripted-dataset-to-parse-a-dynamic-xml-string/#entry138486'>http://developer.actuate.com/community/forum/index.php?/topic/36942-scripted-dataset-to-parse-a-dynamic-xml-string/#entry138486</a></p>
;
Arif shah
<p>Basically, the pgv would be something like this in the onfetch of the dataset that calls the webservice</p>
<pre class="_prettyXprint">
xml = row[1]
reportContext.setPersistentGlobalVariable("test",xml)</pre>
<p>However, as an example, I am hardcoding the same string that is returned by the above row[1] of the dataset</p>
<pre class="_prettyXprint">
xml= "<response><items><items><item><item><typeData>answer</typeData><value>11</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>70</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>31</value><percent1>1.4</percent1><percent2>1.4</percent2></item><item><typeData>answer</typeData><value>98</value><percent1>4.4</percent1><percent2>4.4</percent2></item><item><typeData>answer</typeData><value>371</value><percent1>16.8</percent1><percent2>16.8</percent2></item><item><typeData>answer</typeData><value>540</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>1066</value><percent1>48.1</percent1><percent2>48.1</percent2></item><item><typeData>nps</typeData><value>66.3</value><percent1>66.3</percent1><percent2>66.3</percent2></item><item><typeData>total</typeData><value>2214</value><percent1>2214</percent1><percent2>2214</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>20</value><percent1>4.8</percent1><percent2>4.8</percent2></item><item><typeData>answer</typeData><value>80</value><percent1>19.4</percent1><percent2>19.4</percent2></item><item><typeData>answer</typeData><value>105</value><percent1>25.4</percent1><percent2>25.4</percent2></item><item><typeData>answer</typeData><value>173</value><percent1>41.9</percent1><percent2>41.9</percent2></item><item><typeData>nps</typeData><value>58.8</value><percent1>58.8</percent1><percent2>58.8</percent2></item><item><typeData>total</typeData><value>413</value><percent1>413</percent1><percent2>413</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.1</percent1><percent2>1.1</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>2.8</percent1><percent2>2.8</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.1</percent1><percent2>2.1</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>5.3</percent1><percent2>5.3</percent2></item><item><typeData>answer</typeData><value>61</value><percent1>21.7</percent1><percent2>21.7</percent2></item><item><typeData>answer</typeData><value>66</value><percent1>23.5</percent1><percent2>23.5</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>42.7</percent1><percent2>42.7</percent2></item><item><typeData>nps</typeData><value>59.4</value><percent1>59.4</percent1><percent2>59.4</percent2></item><item><typeData>total</typeData><value>281</value><percent1>281</percent1><percent2>281</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.8</percent1><percent2>0.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>14.5</percent1><percent2>14.5</percent2></item><item><typeData>answer</typeData><value>68</value><percent1>28.1</percent1><percent2>28.1</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>49.6</percent1><percent2>49.6</percent2></item><item><typeData>nps</typeData><value>72.3</value><percent1>72.3</percent1><percent2>72.3</percent2></item><item><typeData>total</typeData><value>242</value><percent1>242</percent1><percent2>242</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>2.9</percent1><percent2>2.9</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>5.8</percent1><percent2>5.8</percent2></item><item><typeData>answer</typeData><value>21</value><percent1>12.2</percent1><percent2>12.2</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>23.8</percent1><percent2>23.8</percent2></item><item><typeData>answer</typeData><value>92</value><percent1>53.5</percent1><percent2>53.5</percent2></item><item><typeData>nps</typeData><value>72.7</value><percent1>72.7</percent1><percent2>72.7</percent2></item><item><typeData>total</typeData><value>172</value><percent1>172</percent1><percent2>172</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>11</value><percent1>6.5</percent1><percent2>6.5</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>27</value><percent1>16</percent1><percent2>16</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>16.6</percent1><percent2>16.6</percent2></item><item><typeData>answer</typeData><value>94</value><percent1>55.6</percent1><percent2>55.6</percent2></item><item><typeData>nps</typeData><value>63.9</value><percent1>63.9</percent1><percent2>63.9</percent2></item><item><typeData>total</typeData><value>169</value><percent1>169</percent1><percent2>169</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.8</percent1><percent2>1.8</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3</percent1><percent2>3</percent2></item><item><typeData>answer</typeData><value>33</value><percent1>19.8</percent1><percent2>19.8</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>24.6</percent1><percent2>24.6</percent2></item><item><typeData>answer</typeData><value>78</value><percent1>46.7</percent1><percent2>46.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>167</value><percent1>167</percent1><percent2>167</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>5.2</percent1><percent2>5.2</percent2></item><item><typeData>answer</typeData><value>18</value><percent1>11.6</percent1><percent2>11.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>21.9</percent1><percent2>21.9</percent2></item><item><typeData>answer</typeData><value>85</value><percent1>54.8</percent1><percent2>54.8</percent2></item><item><typeData>nps</typeData><value>70.3</value><percent1>70.3</percent1><percent2>70.3</percent2></item><item><typeData>total</typeData><value>155</value><percent1>155</percent1><percent2>155</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.7</percent1><percent2>2.7</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>15.6</percent1><percent2>15.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>23.1</percent1><percent2>23.1</percent2></item><item><typeData>answer</typeData><value>81</value><percent1>55.1</percent1><percent2>55.1</percent2></item><item><typeData>nps</typeData><value>74.8</value><percent1>74.8</percent1><percent2>74.8</percent2></item><item><typeData>total</typeData><value>147</value><percent1>147</percent1><percent2>147</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>8.5</percent1><percent2>8.5</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>23.9</percent1><percent2>23.9</percent2></item><item><typeData>answer</typeData><value>73</value><percent1>62.4</percent1><percent2>62.4</percent2></item><item><typeData>nps</typeData><value>83.8</value><percent1>83.8</percent1><percent2>83.8</percent2></item><item><typeData>total</typeData><value>117</value><percent1>117</percent1><percent2>117</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>22.8</percent1><percent2>22.8</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>35.6</percent1><percent2>35.6</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>34.7</percent1><percent2>34.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>101</value><percent1>101</percent1><percent2>101</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.4</percent1><percent2>3.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.7</percent1><percent2>5.7</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>14.9</percent1><percent2>14.9</percent2></item><item><typeData>answer</typeData><value>24</value><percent1>27.6</percent1><percent2>27.6</percent2></item><item><typeData>answer</typeData><value>42</value><percent1>48.3</percent1><percent2>48.3</percent2></item><item><typeData>nps</typeData><value>72.4</value><percent1>72.4</percent1><percent2>72.4</percent2></item><item><typeData>total</typeData><value>87</value><percent1>87</percent1><percent2>87</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.9</percent1><percent2>5.9</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>9.4</percent1><percent2>9.4</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>17.6</percent1><percent2>17.6</percent2></item><item><typeData>answer</typeData><value>16</value><percent1>18.8</percent1><percent2>18.8</percent2></item><item><typeData>answer</typeData><value>37</value><percent1>43.5</percent1><percent2>43.5</percent2></item><item><typeData>nps</typeData><value>51.8</value><percent1>51.8</percent1><percent2>51.8</percent2></item><item><typeData>total</typeData><value>85</value><percent1>85</percent1><percent2>85</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.8</percent1><percent2>3.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>7.7</percent1><percent2>7.7</percent2></item><item><typeData>answer</typeData><value>12</value><percent1>15.4</percent1><percent2>15.4</percent2></item><item><typeData>answer</typeData><value>19</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>46.2</percent1><percent2>46.2</percent2></item><item><typeData>nps</typeData><value>64.1</value><percent1>64.1</percent1><percent2>64.1</percent2></item><item><typeData>total</typeData><value>78</value><percent1>78</percent1><percent2>78</percent2></item></item></items><columnsName><columnsName>0</columnsName><columnsName>1</columnsName><columnsName>2</columnsName><columnsName>3</columnsName><columnsName>4</columnsName><columnsName>5</columnsName><columnsName>6</columnsName><columnsName>7</columnsName><columnsName>8</columnsName><columnsName>9</columnsName><columnsName>10</columnsName><columnsName>NPS( [9;10] - [0;6] )</columnsName><columnsName>Total</columnsName></columnsName><total/><linesName><linesName>test1</linesName><linesName>test2</linesName><linesName>test3</linesName><linesName>test4</linesName><linesName>test5</linesName><linesName>test6</linesName><linesName>test7</linesName><linesName>test8</linesName><linesName>test9</linesName><linesName>test10</linesName><linesName>test11</linesName><linesName>test12</linesName><linesName>test13</linesName><linesName>test14</linesName></linesName></items></response>"
reportContext.setPersistentGlobalVariable("test",xml) </pre>
<p>Then in the scripted dataset, I am trying to retrieve it like this</p>
<pre class="_prettyXprint">
result = reportContext.getPersistentGlobalVariable("test");</pre>
<p>it does not work but If hardcode the same string in the scripted dataset, it works</p>
<pre class="_prettyXprint">
result= "<response><items><items><item><item><typeData>answer</typeData><value>11</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>70</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>31</value><percent1>1.4</percent1><percent2>1.4</percent2></item><item><typeData>answer</typeData><value>98</value><percent1>4.4</percent1><percent2>4.4</percent2></item><item><typeData>answer</typeData><value>371</value><percent1>16.8</percent1><percent2>16.8</percent2></item><item><typeData>answer</typeData><value>540</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>1066</value><percent1>48.1</percent1><percent2>48.1</percent2></item><item><typeData>nps</typeData><value>66.3</value><percent1>66.3</percent1><percent2>66.3</percent2></item><item><typeData>total</typeData><value>2214</value><percent1>2214</percent1><percent2>2214</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>20</value><percent1>4.8</percent1><percent2>4.8</percent2></item><item><typeData>answer</typeData><value>80</value><percent1>19.4</percent1><percent2>19.4</percent2></item><item><typeData>answer</typeData><value>105</value><percent1>25.4</percent1><percent2>25.4</percent2></item><item><typeData>answer</typeData><value>173</value><percent1>41.9</percent1><percent2>41.9</percent2></item><item><typeData>nps</typeData><value>58.8</value><percent1>58.8</percent1><percent2>58.8</percent2></item><item><typeData>total</typeData><value>413</value><percent1>413</percent1><percent2>413</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.1</percent1><percent2>1.1</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>2.8</percent1><percent2>2.8</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.1</percent1><percent2>2.1</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>5.3</percent1><percent2>5.3</percent2></item><item><typeData>answer</typeData><value>61</value><percent1>21.7</percent1><percent2>21.7</percent2></item><item><typeData>answer</typeData><value>66</value><percent1>23.5</percent1><percent2>23.5</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>42.7</percent1><percent2>42.7</percent2></item><item><typeData>nps</typeData><value>59.4</value><percent1>59.4</percent1><percent2>59.4</percent2></item><item><typeData>total</typeData><value>281</value><percent1>281</percent1><percent2>281</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.8</percent1><percent2>0.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>14.5</percent1><percent2>14.5</percent2></item><item><typeData>answer</typeData><value>68</value><percent1>28.1</percent1><percent2>28.1</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>49.6</percent1><percent2>49.6</percent2></item><item><typeData>nps</typeData><value>72.3</value><percent1>72.3</percent1><percent2>72.3</percent2></item><item><typeData>total</typeData><value>242</value><percent1>242</percent1><percent2>242</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>2.9</percent1><percent2>2.9</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>5.8</percent1><percent2>5.8</percent2></item><item><typeData>answer</typeData><value>21</value><percent1>12.2</percent1><percent2>12.2</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>23.8</percent1><percent2>23.8</percent2></item><item><typeData>answer</typeData><value>92</value><percent1>53.5</percent1><percent2>53.5</percent2></item><item><typeData>nps</typeData><value>72.7</value><percent1>72.7</percent1><percent2>72.7</percent2></item><item><typeData>total</typeData><value>172</value><percent1>172</percent1><percent2>172</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>11</value><percent1>6.5</percent1><percent2>6.5</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>27</value><percent1>16</percent1><percent2>16</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>16.6</percent1><percent2>16.6</percent2></item><item><typeData>answer</typeData><value>94</value><percent1>55.6</percent1><percent2>55.6</percent2></item><item><typeData>nps</typeData><value>63.9</value><percent1>63.9</percent1><percent2>63.9</percent2></item><item><typeData>total</typeData><value>169</value><percent1>169</percent1><percent2>169</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.8</percent1><percent2>1.8</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3</percent1><percent2>3</percent2></item><item><typeData>answer</typeData><value>33</value><percent1>19.8</percent1><percent2>19.8</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>24.6</percent1><percent2>24.6</percent2></item><item><typeData>answer</typeData><value>78</value><percent1>46.7</percent1><percent2>46.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>167</value><percent1>167</percent1><percent2>167</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>5.2</percent1><percent2>5.2</percent2></item><item><typeData>answer</typeData><value>18</value><percent1>11.6</percent1><percent2>11.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>21.9</percent1><percent2>21.9</percent2></item><item><typeData>answer</typeData><value>85</value><percent1>54.8</percent1><percent2>54.8</percent2></item><item><typeData>nps</typeData><value>70.3</value><percent1>70.3</percent1><percent2>70.3</percent2></item><item><typeData>total</typeData><value>155</value><percent1>155</percent1><percent2>155</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.7</percent1><percent2>2.7</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>15.6</percent1><percent2>15.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>23.1</percent1><percent2>23.1</percent2></item><item><typeData>answer</typeData><value>81</value><percent1>55.1</percent1><percent2>55.1</percent2></item><item><typeData>nps</typeData><value>74.8</value><percent1>74.8</percent1><percent2>74.8</percent2></item><item><typeData>total</typeData><value>147</value><percent1>147</percent1><percent2>147</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>8.5</percent1><percent2>8.5</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>23.9</percent1><percent2>23.9</percent2></item><item><typeData>answer</typeData><value>73</value><percent1>62.4</percent1><percent2>62.4</percent2></item><item><typeData>nps</typeData><value>83.8</value><percent1>83.8</percent1><percent2>83.8</percent2></item><item><typeData>total</typeData><value>117</value><percent1>117</percent1><percent2>117</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>22.8</percent1><percent2>22.8</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>35.6</percent1><percent2>35.6</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>34.7</percent1><percent2>34.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>101</value><percent1>101</percent1><percent2>101</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.4</percent1><percent2>3.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.7</percent1><percent2>5.7</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>14.9</percent1><percent2>14.9</percent2></item><item><typeData>answer</typeData><value>24</value><percent1>27.6</percent1><percent2>27.6</percent2></item><item><typeData>answer</typeData><value>42</value><percent1>48.3</percent1><percent2>48.3</percent2></item><item><typeData>nps</typeData><value>72.4</value><percent1>72.4</percent1><percent2>72.4</percent2></item><item><typeData>total</typeData><value>87</value><percent1>87</percent1><percent2>87</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.9</percent1><percent2>5.9</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>9.4</percent1><percent2>9.4</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>17.6</percent1><percent2>17.6</percent2></item><item><typeData>answer</typeData><value>16</value><percent1>18.8</percent1><percent2>18.8</percent2></item><item><typeData>answer</typeData><value>37</value><percent1>43.5</percent1><percent2>43.5</percent2></item><item><typeData>nps</typeData><value>51.8</value><percent1>51.8</percent1><percent2>51.8</percent2></item><item><typeData>total</typeData><value>85</value><percent1>85</percent1><percent2>85</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.8</percent1><percent2>3.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>7.7</percent1><percent2>7.7</percent2></item><item><typeData>answer</typeData><value>12</value><percent1>15.4</percent1><percent2>15.4</percent2></item><item><typeData>answer</typeData><value>19</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>46.2</percent1><percent2>46.2</percent2></item><item><typeData>nps</typeData><value>64.1</value><percent1>64.1</percent1><percent2>64.1</percent2></item><item><typeData>total</typeData><value>78</value><percent1>78</percent1><percent2>78</percent2></item></item></items><columnsName><columnsName>0</columnsName><columnsName>1</columnsName><columnsName>2</columnsName><columnsName>3</columnsName><columnsName>4</columnsName><columnsName>5</columnsName><columnsName>6</columnsName><columnsName>7</columnsName><columnsName>8</columnsName><columnsName>9</columnsName><columnsName>10</columnsName><columnsName>NPS( [9;10] - [0;6] )</columnsName><columnsName>Total</columnsName></columnsName><total/><linesName><linesName>test1</linesName><linesName>test2</linesName><linesName>test3</linesName><linesName>test4</linesName><linesName>test5</linesName><linesName>test6</linesName><linesName>test7</linesName><linesName>test8</linesName><linesName>test9</linesName><linesName>test10</linesName><linesName>test11</linesName><linesName>test12</linesName><linesName>test13</linesName><linesName>test14</linesName></linesName></items></response>"
</pre>
Clement Wong
<p>onFetch? That means you are setting the PGV for every row. Did you intend to do this?</p>
<p> </p>
<p>I'm not sure what you entire report design looks like. What data source are you using? Can you attach your report design?</p>
<p> </p>
<p>Also, what the raw data that is returned from your data set (in case I cannot run your design from my end)?</p>
<p> </p>
<p>In your environment, what is the value of "xml" or "row[1]" in your onFetch? Do you have a debug statement output of the value?</p>
Arif shah
<p>The dataset is using a webservice type datasource. In the dataset, it is returning only one row that has a string that contains the xml string. At the moment, it is returning only one row but in future it could return many rows and then I am planning to store them in an array</p>
<p> </p>
<p>The value of row[1] is</p>
<pre class="_prettyXprint">
<?xml version="1.0" encoding="utf-8"?><response><items><items><item><item><typeData>answer</typeData><value>11</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>70</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>31</value><percent1>1.4</percent1><percent2>1.4</percent2></item><item><typeData>answer</typeData><value>98</value><percent1>4.4</percent1><percent2>4.4</percent2></item><item><typeData>answer</typeData><value>371</value><percent1>16.8</percent1><percent2>16.8</percent2></item><item><typeData>answer</typeData><value>540</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>1066</value><percent1>48.1</percent1><percent2>48.1</percent2></item><item><typeData>nps</typeData><value>66.3</value><percent1>66.3</percent1><percent2>66.3</percent2></item><item><typeData>total</typeData><value>2214</value><percent1>2214</percent1><percent2>2214</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>20</value><percent1>4.8</percent1><percent2>4.8</percent2></item><item><typeData>answer</typeData><value>80</value><percent1>19.4</percent1><percent2>19.4</percent2></item><item><typeData>answer</typeData><value>105</value><percent1>25.4</percent1><percent2>25.4</percent2></item><item><typeData>answer</typeData><value>173</value><percent1>41.9</percent1><percent2>41.9</percent2></item><item><typeData>nps</typeData><value>58.8</value><percent1>58.8</percent1><percent2>58.8</percent2></item><item><typeData>total</typeData><value>413</value><percent1>413</percent1><percent2>413</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.1</percent1><percent2>1.1</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>2.8</percent1><percent2>2.8</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.1</percent1><percent2>2.1</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>5.3</percent1><percent2>5.3</percent2></item><item><typeData>answer</typeData><value>61</value><percent1>21.7</percent1><percent2>21.7</percent2></item><item><typeData>answer</typeData><value>66</value><percent1>23.5</percent1><percent2>23.5</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>42.7</percent1><percent2>42.7</percent2></item><item><typeData>nps</typeData><value>59.4</value><percent1>59.4</percent1><percent2>59.4</percent2></item><item><typeData>total</typeData><value>281</value><percent1>281</percent1><percent2>281</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.8</percent1><percent2>0.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>14.5</percent1><percent2>14.5</percent2></item><item><typeData>answer</typeData><value>68</value><percent1>28.1</percent1><percent2>28.1</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>49.6</percent1><percent2>49.6</percent2></item><item><typeData>nps</typeData><value>72.3</value><percent1>72.3</percent1><percent2>72.3</percent2></item><item><typeData>total</typeData><value>242</value><percent1>242</percent1><percent2>242</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>2.9</percent1><percent2>2.9</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>5.8</percent1><percent2>5.8</percent2></item><item><typeData>answer</typeData><value>21</value><percent1>12.2</percent1><percent2>12.2</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>23.8</percent1><percent2>23.8</percent2></item><item><typeData>answer</typeData><value>92</value><percent1>53.5</percent1><percent2>53.5</percent2></item><item><typeData>nps</typeData><value>72.7</value><percent1>72.7</percent1><percent2>72.7</percent2></item><item><typeData>total</typeData><value>172</value><percent1>172</percent1><percent2>172</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>11</value><percent1>6.5</percent1><percent2>6.5</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>27</value><percent1>16</percent1><percent2>16</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>16.6</percent1><percent2>16.6</percent2></item><item><typeData>answer</typeData><value>94</value><percent1>55.6</percent1><percent2>55.6</percent2></item><item><typeData>nps</typeData><value>63.9</value><percent1>63.9</percent1><percent2>63.9</percent2></item><item><typeData>total</typeData><value>169</value><percent1>169</percent1><percent2>169</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.8</percent1><percent2>1.8</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3</percent1><percent2>3</percent2></item><item><typeData>answer</typeData><value>33</value><percent1>19.8</percent1><percent2>19.8</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>24.6</percent1><percent2>24.6</percent2></item><item><typeData>answer</typeData><value>78</value><percent1>46.7</percent1><percent2>46.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>167</value><percent1>167</percent1><percent2>167</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>5.2</percent1><percent2>5.2</percent2></item><item><typeData>answer</typeData><value>18</value><percent1>11.6</percent1><percent2>11.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>21.9</percent1><percent2>21.9</percent2></item><item><typeData>answer</typeData><value>85</value><percent1>54.8</percent1><percent2>54.8</percent2></item><item><typeData>nps</typeData><value>70.3</value><percent1>70.3</percent1><percent2>70.3</percent2></item><item><typeData>total</typeData><value>155</value><percent1>155</percent1><percent2>155</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.7</percent1><percent2>2.7</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>15.6</percent1><percent2>15.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>23.1</percent1><percent2>23.1</percent2></item><item><typeData>answer</typeData><value>81</value><percent1>55.1</percent1><percent2>55.1</percent2></item><item><typeData>nps</typeData><value>74.8</value><percent1>74.8</percent1><percent2>74.8</percent2></item><item><typeData>total</typeData><value>147</value><percent1>147</percent1><percent2>147</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>8.5</percent1><percent2>8.5</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>23.9</percent1><percent2>23.9</percent2></item><item><typeData>answer</typeData><value>73</value><percent1>62.4</percent1><percent2>62.4</percent2></item><item><typeData>nps</typeData><value>83.8</value><percent1>83.8</percent1><percent2>83.8</percent2></item><item><typeData>total</typeData><value>117</value><percent1>117</percent1><percent2>117</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>22.8</percent1><percent2>22.8</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>35.6</percent1><percent2>35.6</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>34.7</percent1><percent2>34.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>101</value><percent1>101</percent1><percent2>101</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.4</percent1><percent2>3.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.7</percent1><percent2>5.7</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>14.9</percent1><percent2>14.9</percent2></item><item><typeData>answer</typeData><value>24</value><percent1>27.6</percent1><percent2>27.6</percent2></item><item><typeData>answer</typeData><value>42</value><percent1>48.3</percent1><percent2>48.3</percent2></item><item><typeData>nps</typeData><value>72.4</value><percent1>72.4</percent1><percent2>72.4</percent2></item><item><typeData>total</typeData><value>87</value><percent1>87</percent1><percent2>87</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.9</percent1><percent2>5.9</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>9.4</percent1><percent2>9.4</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>17.6</percent1><percent2>17.6</percent2></item><item><typeData>answer</typeData><value>16</value><percent1>18.8</percent1><percent2>18.8</percent2></item><item><typeData>answer</typeData><value>37</value><percent1>43.5</percent1><percent2>43.5</percent2></item><item><typeData>nps</typeData><value>51.8</value><percent1>51.8</percent1><percent2>51.8</percent2></item><item><typeData>total</typeData><value>85</value><percent1>85</percent1><percent2>85</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.8</percent1><percent2>3.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>7.7</percent1><percent2>7.7</percent2></item><item><typeData>answer</typeData><value>12</value><percent1>15.4</percent1><percent2>15.4</percent2></item><item><typeData>answer</typeData><value>19</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>46.2</percent1><percent2>46.2</percent2></item><item><typeData>nps</typeData><value>64.1</value><percent1>64.1</percent1><percent2>64.1</percent2></item><item><typeData>total</typeData><value>78</value><percent1>78</percent1><percent2>78</percent2></item></item></items><columnsName><columnsName>0</columnsName><columnsName>1</columnsName><columnsName>2</columnsName><columnsName>3</columnsName><columnsName>4</columnsName><columnsName>5</columnsName><columnsName>6</columnsName><columnsName>7</columnsName><columnsName>8</columnsName><columnsName>9</columnsName><columnsName>10</columnsName><columnsName>NPS( [9;10] - [0;6] )</columnsName><columnsName>Total</columnsName></columnsName><total/><linesName><linesName>test1</linesName><linesName>test2</linesName><linesName>test3</linesName><linesName>test4</linesName><linesName>test5</linesName><linesName>test6</linesName><linesName>test7</linesName><linesName>test8</linesName><linesName>test9</linesName><linesName>test10</linesName><linesName>test11</linesName><linesName>test12</linesName><linesName>test13</linesName><linesName>test14</linesName></linesName></items></response></pre>
<p>However, for testing, I have put some hardcoded xml into the below variable</p>
<pre class="_prettyXprint">
xml= "<response><items><items><item><item><typeData>answer</typeData><value>11</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>70</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>31</value><percent1>1.4</percent1><percent2>1.4</percent2></item><item><typeData>answer</typeData><value>98</value><percent1>4.4</percent1><percent2>4.4</percent2></item><item><typeData>answer</typeData><value>371</value><percent1>16.8</percent1><percent2>16.8</percent2></item><item><typeData>answer</typeData><value>540</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>1066</value><percent1>48.1</percent1><percent2>48.1</percent2></item><item><typeData>nps</typeData><value>66.3</value><percent1>66.3</percent1><percent2>66.3</percent2></item><item><typeData>total</typeData><value>2214</value><percent1>2214</percent1><percent2>2214</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.2</percent1><percent2>0.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>0.5</percent1><percent2>0.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>20</value><percent1>4.8</percent1><percent2>4.8</percent2></item><item><typeData>answer</typeData><value>80</value><percent1>19.4</percent1><percent2>19.4</percent2></item><item><typeData>answer</typeData><value>105</value><percent1>25.4</percent1><percent2>25.4</percent2></item><item><typeData>answer</typeData><value>173</value><percent1>41.9</percent1><percent2>41.9</percent2></item><item><typeData>nps</typeData><value>58.8</value><percent1>58.8</percent1><percent2>58.8</percent2></item><item><typeData>total</typeData><value>413</value><percent1>413</percent1><percent2>413</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.1</percent1><percent2>1.1</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>2.8</percent1><percent2>2.8</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.1</percent1><percent2>2.1</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>5.3</percent1><percent2>5.3</percent2></item><item><typeData>answer</typeData><value>61</value><percent1>21.7</percent1><percent2>21.7</percent2></item><item><typeData>answer</typeData><value>66</value><percent1>23.5</percent1><percent2>23.5</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>42.7</percent1><percent2>42.7</percent2></item><item><typeData>nps</typeData><value>59.4</value><percent1>59.4</percent1><percent2>59.4</percent2></item><item><typeData>total</typeData><value>281</value><percent1>281</percent1><percent2>281</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>0.8</percent1><percent2>0.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.4</percent1><percent2>0.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>2.5</percent1><percent2>2.5</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>14.5</percent1><percent2>14.5</percent2></item><item><typeData>answer</typeData><value>68</value><percent1>28.1</percent1><percent2>28.1</percent2></item><item><typeData>answer</typeData><value>120</value><percent1>49.6</percent1><percent2>49.6</percent2></item><item><typeData>nps</typeData><value>72.3</value><percent1>72.3</percent1><percent2>72.3</percent2></item><item><typeData>total</typeData><value>242</value><percent1>242</percent1><percent2>242</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>2.9</percent1><percent2>2.9</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>5.8</percent1><percent2>5.8</percent2></item><item><typeData>answer</typeData><value>21</value><percent1>12.2</percent1><percent2>12.2</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>23.8</percent1><percent2>23.8</percent2></item><item><typeData>answer</typeData><value>92</value><percent1>53.5</percent1><percent2>53.5</percent2></item><item><typeData>nps</typeData><value>72.7</value><percent1>72.7</percent1><percent2>72.7</percent2></item><item><typeData>total</typeData><value>172</value><percent1>172</percent1><percent2>172</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>11</value><percent1>6.5</percent1><percent2>6.5</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>3.6</percent1><percent2>3.6</percent2></item><item><typeData>answer</typeData><value>27</value><percent1>16</percent1><percent2>16</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>16.6</percent1><percent2>16.6</percent2></item><item><typeData>answer</typeData><value>94</value><percent1>55.6</percent1><percent2>55.6</percent2></item><item><typeData>nps</typeData><value>63.9</value><percent1>63.9</percent1><percent2>63.9</percent2></item><item><typeData>total</typeData><value>169</value><percent1>169</percent1><percent2>169</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>1.8</percent1><percent2>1.8</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.4</percent1><percent2>2.4</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3</percent1><percent2>3</percent2></item><item><typeData>answer</typeData><value>33</value><percent1>19.8</percent1><percent2>19.8</percent2></item><item><typeData>answer</typeData><value>41</value><percent1>24.6</percent1><percent2>24.6</percent2></item><item><typeData>answer</typeData><value>78</value><percent1>46.7</percent1><percent2>46.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>167</value><percent1>167</percent1><percent2>167</percent2></item></item><item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.6</percent1><percent2>0.6</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>3.2</percent1><percent2>3.2</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>5.2</percent1><percent2>5.2</percent2></item><item><typeData>answer</typeData><value>18</value><percent1>11.6</percent1><percent2>11.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>21.9</percent1><percent2>21.9</percent2></item><item><typeData>answer</typeData><value>85</value><percent1>54.8</percent1><percent2>54.8</percent2></item><item><typeData>nps</typeData><value>70.3</value><percent1>70.3</percent1><percent2>70.3</percent2></item><item><typeData>total</typeData><value>155</value><percent1>155</percent1><percent2>155</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>0.7</percent1><percent2>0.7</percent2></item><item><typeData>answer</typeData><value>4</value><percent1>2.7</percent1><percent2>2.7</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>15.6</percent1><percent2>15.6</percent2></item><item><typeData>answer</typeData><value>34</value><percent1>23.1</percent1><percent2>23.1</percent2></item><item><typeData>answer</typeData><value>81</value><percent1>55.1</percent1><percent2>55.1</percent2></item><item><typeData>nps</typeData><value>74.8</value><percent1>74.8</percent1><percent2>74.8</percent2></item><item><typeData>total</typeData><value>147</value><percent1>147</percent1><percent2>147</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>2.6</percent1><percent2>2.6</percent2></item><item><typeData>answer</typeData><value>10</value><percent1>8.5</percent1><percent2>8.5</percent2></item><item><typeData>answer</typeData><value>28</value><percent1>23.9</percent1><percent2>23.9</percent2></item><item><typeData>answer</typeData><value>73</value><percent1>62.4</percent1><percent2>62.4</percent2></item><item><typeData>nps</typeData><value>83.8</value><percent1>83.8</percent1><percent2>83.8</percent2></item><item><typeData>total</typeData><value>117</value><percent1>117</percent1><percent2>117</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1</percent1><percent2>1</percent2></item><item><typeData>answer</typeData><value>2</value><percent1>2</percent1><percent2>2</percent2></item><item><typeData>answer</typeData><value>23</value><percent1>22.8</percent1><percent2>22.8</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>35.6</percent1><percent2>35.6</percent2></item><item><typeData>answer</typeData><value>35</value><percent1>34.7</percent1><percent2>34.7</percent2></item><item><typeData>nps</typeData><value>65.3</value><percent1>65.3</percent1><percent2>65.3</percent2></item><item><typeData>total</typeData><value>101</value><percent1>101</percent1><percent2>101</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.4</percent1><percent2>3.4</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.7</percent1><percent2>5.7</percent2></item><item><typeData>answer</typeData><value>13</value><percent1>14.9</percent1><percent2>14.9</percent2></item><item><typeData>answer</typeData><value>24</value><percent1>27.6</percent1><percent2>27.6</percent2></item><item><typeData>answer</typeData><value>42</value><percent1>48.3</percent1><percent2>48.3</percent2></item><item><typeData>nps</typeData><value>72.4</value><percent1>72.4</percent1><percent2>72.4</percent2></item><item><typeData>total</typeData><value>87</value><percent1>87</percent1><percent2>87</percent2></item></item><item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>5</value><percent1>5.9</percent1><percent2>5.9</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.2</percent1><percent2>1.2</percent2></item><item><typeData>answer</typeData><value>8</value><percent1>9.4</percent1><percent2>9.4</percent2></item><item><typeData>answer</typeData><value>15</value><percent1>17.6</percent1><percent2>17.6</percent2></item><item><typeData>answer</typeData><value>16</value><percent1>18.8</percent1><percent2>18.8</percent2></item><item><typeData>answer</typeData><value>37</value><percent1>43.5</percent1><percent2>43.5</percent2></item><item><typeData>nps</typeData><value>51.8</value><percent1>51.8</percent1><percent2>51.8</percent2></item><item><typeData>total</typeData><value>85</value><percent1>85</percent1><percent2>85</percent2></item></item><item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>0</value><percent1>0</percent1><percent2>0</percent2></item><item><typeData>answer</typeData><value>3</value><percent1>3.8</percent1><percent2>3.8</percent2></item><item><typeData>answer</typeData><value>1</value><percent1>1.3</percent1><percent2>1.3</percent2></item><item><typeData>answer</typeData><value>6</value><percent1>7.7</percent1><percent2>7.7</percent2></item><item><typeData>answer</typeData><value>12</value><percent1>15.4</percent1><percent2>15.4</percent2></item><item><typeData>answer</typeData><value>19</value><percent1>24.4</percent1><percent2>24.4</percent2></item><item><typeData>answer</typeData><value>36</value><percent1>46.2</percent1><percent2>46.2</percent2></item><item><typeData>nps</typeData><value>64.1</value><percent1>64.1</percent1><percent2>64.1</percent2></item><item><typeData>total</typeData><value>78</value><percent1>78</percent1><percent2>78</percent2></item></item></items><columnsName><columnsName>0</columnsName><columnsName>1</columnsName><columnsName>2</columnsName><columnsName>3</columnsName><columnsName>4</columnsName><columnsName>5</columnsName><columnsName>6</columnsName><columnsName>7</columnsName><columnsName>8</columnsName><columnsName>9</columnsName><columnsName>10</columnsName><columnsName>NPS( [9;10] - [0;6] )</columnsName><columnsName>Total</columnsName></columnsName><total/><linesName><linesName>test1</linesName><linesName>test2</linesName><linesName>test3</linesName><linesName>test4</linesName><linesName>test5</linesName><linesName>test6</linesName><linesName>test7</linesName><linesName>test8</linesName><linesName>test9</linesName><linesName>test10</linesName><linesName>test11</linesName><linesName>test12</linesName><linesName>test13</linesName><linesName>test14</linesName></linesName></items></response>"
reportContext.setPersistentGlobalVariable("test",xml)</pre>
<p>When I output the pgv in a dynamic text element, I see the below output</p>
<pre class="_prettyXprint">
answer110.50.5answer50.20.2answer50.20.2answer40.20.2answer130.60.6answer703.23.2answer311.41.4answer984.44.4answer37116.816.8answer54024.424.4answer106648.148.1nps66.366.366.3total221422142214answer20.50.5answer10.20.2answer20.50.5answer20.50.5answer30.70.7answer153.63.6answer102.42.4answer204.84.8answer8019.419.4answer10525.425.4answer17341.941.9nps58.858.858.8total413413413answer20.70.7answer000answer000answer000answer31.11.1answer82.82.8answer62.12.1answer155.35.3answer6121.721.7answer6623.523.5answer12042.742.7nps59.459.459.4total281281281answer20.80.8answer10.40.4answer10.40.4answer000answer000answer62.52.5answer31.21.2answer62.52.5answer3514.514.5answer6828.128.1answer12049.649.6nps72.372.372.3total242242242answer000answer000answer000answer000answer10.60.6answer52.92.9answer21.21.2answer105.85.8answer2112.212.2answer4123.823.8answer9253.553.5nps72.772.772.7total172172172answer000answer10.60.6answer000answer10.60.6answer10.60.6answer116.56.5answer000answer63.63.6answer271616answer2816.616.6answer9455.655.6nps63.963.963.9total169169169answer10.60.6answer10.60.6answer000answer000answer31.81.8answer42.42.4answer10.60.6answer533answer3319.819.8answer4124.624.6answer7846.746.7nps65.365.365.3total167167167answer21.31.3answer000answer000answer000answer10.60.6answer53.23.2answer21.31.3answer85.25.2answer1811.611.6answer3421.921.9answer8554.854.8nps70.370.370.3total155155155answer000answer000answer000answer10.70.7answer000answer322answer10.70.7answer42.72.7answer2315.615.6answer3423.123.1answer8155.155.1nps74.874.874.8total147147147answer000answer000answer000answer000answer000answer000answer32.62.6answer32.62.6answer108.58.5answer2823.923.9answer7362.462.4nps83.883.883.8total117117117answer111answer000answer111answer000answer000answer222answer111answer222answer2322.822.8answer3635.635.6answer3534.734.7nps65.365.365.3total101101101answer000answer000answer000answer000answ
Clement Wong
<p>I'm using commercial BIRT (Analytics Designer which was formerly named BIRT Designer Professional) so it's easy to debug using the following and it will output directly to the Eclipse's Error Log dialog at the bottom right.</p>
<p> </p>
<p style="margin-left:40px;"><span style="font-family:'courier new', courier, monospace;">logger = java.util.logging.Logger.getLogger("birt.report.logger");<br>
logger.warning ('Your message');</span><br>
</p>
<p>Another option is to use the Eclipse's Debug perspective, and then you can put a break point at the xml = row[1];. Then you can look at the variables or expressions in the upper right hand window to see what the value of xml and row[1] are.</p>
<p> </p>
<p>Or another option is to launch BIRT in console mode and write out debug statements to the console (@ <a data-ipb='nomediaparse' href='
http://birtworld.blogspot.com/2010/01/quick-and-dirty-logging.html'>http://birtworld.blogspot.com/2010/01/quick-and-dirty-logging.html</a>)</p>
;
<p> </p>
<p>Without seeing or running your report design, the reason you might be not seeing the actual output of the XML in the Text Report Item in the final output is that you may have set the format of the Text Report Item to "<span style="color:#800000;"><strong>HTML</strong></span>" and <span style="font-family:'courier new', courier, monospace;"><VALUE-OF <span style="color:rgb(128,0,0);"><strong>format="HTML"</strong></span>>row["YOUR_HTML_DATA_COLUMN"]</VALUE-OF></span> ?</p>
<p> </p>
<p>Please include a sample design that replicates your issue.</p>
Arif shah
<p>Hi Clement,<br><br>
Many thanks for your help. Here is the actual webservice call rptdesign. One dataset is making call to webservice while the other one is scripted dataset to parse the xml returned fromt he webservice</p>
<p> </p>
<p>My purpose is to do the following</p>
<p> </p>
<p>1) From one dataset (named <strong>webservice</strong>), Send a request to webservice (with parameters)</p>
<p>2) Store the returned xml into a pgv</p>
<p>3) In another scripted dataset (<strong>scripted dataset</strong>), parse the xml in pgv and convert them into proper rows and columns</p>
<p>4) Show the coverted rows in a table</p>
<p> </p>
<p>5) Here is one more challange. Instead of using seperate datasets for webservice and seperate for parsing, I want to combine them into one so that I can combine the result of multiple requests (qm_id 3, 5 and 11 for example, please see the paramters of webservice dataset) and then show them all together in a table</p>
<p> </p>
<p>Here is the attached rptdesigner</p>
<p> </p>
<p>Regards</p>
<p>Arif</p>
Clement Wong
<p>Please use Text Report Item instead of Dynamic Text Item. My sample above uses the Text Report Item to display the PGV.</p>
<p> </p>
<p>With the Text Report Item, you can control the content type of the text. In your case, it's "HTML". The Dynamic Report Item does not have this option.</p>
<p> </p>
<p>I changed your design to use the Text Report Item and it is working as expected. Change content type from "Auto" to "HTML". And use the following expression:</p>
<p style="margin-left:40px;"><span style="font-family:'courier new', courier, monospace;"><VALUE-OF>reportContext.getPersistentGlobalVariable("test");</VALUE-OF></span></p>
<p> </p>
<p>