API tools faq
paste
Guest User

Untitled

a guest
Nov 23rd, 2018
122
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 276.66 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
  3. <property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905 Build &lt;3.7.1.v20110905-1820></property>
  4. <simple-property-list name="includeResource">
  5. <value>dburl</value>
  6. </simple-property-list>
  7. <list-property name="propertyBindings">
  8. <structure>
  9. <property name="name">odaURL</property>
  10. <property name="id">27</property>
  11. <expression name="value">"jdbc:mysql://www.scafinext.com/"+reportContext.getMessage("cli"+params["emId"].value, reportContext.getLocale());</expression>
  12. </structure>
  13. <structure>
  14. <property name="name">odaUser</property>
  15. <property name="id">27</property>
  16. <expression name="value">reportContext.getMessage("cli"+params["emId"].value, reportContext.getLocale());</expression>
  17. </structure>
  18. </list-property>
  19. <property name="units">in</property>
  20. <method name="initialize"><![CDATA[saldoU = 0;
  21. saldoUt = 0;
  22. saldoVt = 0;
  23. debeU = 0;
  24. haberU = 0;
  25. saldoV = 0;
  26. debeV = 0;
  27. haberV = 0;
  28. costoP = 0;]]></method>
  29. <property name="iconFile">/templates/simple_listing.gif</property>
  30. <property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting</property>
  31. <property name="bidiLayoutOrientation">ltr</property>
  32. <property name="imageDPI">96</property>
  33. <property name="locale">es_ES</property>
  34. <parameters>
  35. <scalar-parameter name="sucursalId" id="29">
  36. <property name="valueType">static</property>
  37. <property name="isRequired">true</property>
  38. <property name="dataType">integer</property>
  39. <property name="distinct">true</property>
  40. <simple-property-list name="defaultValue">
  41. <value type="constant">1</value>
  42. </simple-property-list>
  43. <list-property name="selectionList"/>
  44. <property name="paramType">simple</property>
  45. <property name="concealValue">false</property>
  46. <property name="controlType">text-box</property>
  47. <structure name="format">
  48. <property name="category">Unformatted</property>
  49. </structure>
  50. </scalar-parameter>
  51. <scalar-parameter name="bodegaId" id="116">
  52. <text-property name="promptText">bodegaId</text-property>
  53. <property name="valueType">static</property>
  54. <property name="isRequired">false</property>
  55. <property name="dataType">integer</property>
  56. <property name="distinct">true</property>
  57. <simple-property-list name="defaultValue">
  58. <value type="constant">1</value>
  59. </simple-property-list>
  60. <list-property name="selectionList"/>
  61. <property name="paramType">simple</property>
  62. <property name="concealValue">false</property>
  63. <property name="controlType">text-box</property>
  64. <structure name="format">
  65. <property name="category">Unformatted</property>
  66. </structure>
  67. </scalar-parameter>
  68. <scalar-parameter name="fechaI" id="30">
  69. <property name="valueType">static</property>
  70. <property name="isRequired">false</property>
  71. <property name="dataType">string</property>
  72. <property name="distinct">true</property>
  73. <simple-property-list name="defaultValue">
  74. <value type="constant">2010-01-01</value>
  75. </simple-property-list>
  76. <list-property name="selectionList"/>
  77. <property name="paramType">simple</property>
  78. <property name="concealValue">false</property>
  79. <property name="controlType">text-box</property>
  80. <structure name="format">
  81. <property name="category">Unformatted</property>
  82. </structure>
  83. </scalar-parameter>
  84. <scalar-parameter name="fechaF" id="31">
  85. <property name="valueType">static</property>
  86. <property name="isRequired">false</property>
  87. <property name="dataType">string</property>
  88. <property name="distinct">true</property>
  89. <simple-property-list name="defaultValue">
  90. <value type="constant">2016-12-31</value>
  91. </simple-property-list>
  92. <list-property name="selectionList"/>
  93. <property name="paramType">simple</property>
  94. <property name="concealValue">false</property>
  95. <property name="controlType">text-box</property>
  96. <structure name="format">
  97. <property name="category">Unformatted</property>
  98. </structure>
  99. </scalar-parameter>
  100. <scalar-parameter name="productoI" id="32">
  101. <property name="valueType">static</property>
  102. <property name="isRequired">false</property>
  103. <property name="dataType">integer</property>
  104. <property name="distinct">true</property>
  105. <simple-property-list name="defaultValue">
  106. <value type="constant">3102</value>
  107. </simple-property-list>
  108. <list-property name="selectionList"/>
  109. <property name="paramType">simple</property>
  110. <property name="concealValue">false</property>
  111. <property name="controlType">text-box</property>
  112. <structure name="format">
  113. <property name="category">Unformatted</property>
  114. </structure>
  115. </scalar-parameter>
  116. <scalar-parameter name="usuarioId" id="329">
  117. <property name="valueType">static</property>
  118. <property name="isRequired">false</property>
  119. <property name="dataType">integer</property>
  120. <property name="distinct">true</property>
  121. <simple-property-list name="defaultValue">
  122. <value type="constant">1</value>
  123. </simple-property-list>
  124. <list-property name="selectionList"/>
  125. <property name="paramType">simple</property>
  126. <property name="concealValue">false</property>
  127. <property name="controlType">text-box</property>
  128. <structure name="format">
  129. <property name="category">Unformatted</property>
  130. </structure>
  131. </scalar-parameter>
  132. <scalar-parameter name="productoF" id="330">
  133. <property name="valueType">static</property>
  134. <property name="isRequired">false</property>
  135. <property name="dataType">integer</property>
  136. <property name="distinct">true</property>
  137. <simple-property-list name="defaultValue">
  138. <value type="constant">3102</value>
  139. </simple-property-list>
  140. <list-property name="selectionList"/>
  141. <property name="paramType">simple</property>
  142. <property name="concealValue">false</property>
  143. <property name="controlType">text-box</property>
  144. <structure name="format">
  145. <property name="category">Unformatted</property>
  146. </structure>
  147. </scalar-parameter>
  148. <scalar-parameter name="sucId" id="464">
  149. <property name="valueType">static</property>
  150. <property name="dataType">integer</property>
  151. <property name="distinct">true</property>
  152. <simple-property-list name="defaultValue">
  153. <value type="constant">1</value>
  154. </simple-property-list>
  155. <list-property name="selectionList"/>
  156. <property name="paramType">simple</property>
  157. <property name="controlType">text-box</property>
  158. <structure name="format">
  159. <property name="category">Unformatted</property>
  160. </structure>
  161. </scalar-parameter>
  162. <scalar-parameter name="buscarPor" id="514">
  163. <property name="valueType">static</property>
  164. <property name="isRequired">false</property>
  165. <property name="dataType">integer</property>
  166. <property name="distinct">true</property>
  167. <simple-property-list name="defaultValue">
  168. <value type="constant">1</value>
  169. </simple-property-list>
  170. <list-property name="selectionList"/>
  171. <property name="paramType">simple</property>
  172. <property name="concealValue">false</property>
  173. <property name="controlType">text-box</property>
  174. <structure name="format">
  175. <property name="category">Unformatted</property>
  176. </structure>
  177. </scalar-parameter>
  178. <scalar-parameter name="flags" id="515">
  179. <property name="valueType">static</property>
  180. <property name="isRequired">false</property>
  181. <property name="dataType">string</property>
  182. <property name="distinct">true</property>
  183. <simple-property-list name="defaultValue">
  184. <value type="constant">1|1|1|1|1|1|1|1|1|0|0|0|1|1|1</value>
  185. </simple-property-list>
  186. <list-property name="selectionList"/>
  187. <property name="paramType">simple</property>
  188. <property name="controlType">text-box</property>
  189. <structure name="format">
  190. <property name="category">Unformatted</property>
  191. </structure>
  192. </scalar-parameter>
  193. <scalar-parameter name="emId" id="518">
  194. <property name="valueType">static</property>
  195. <property name="dataType">integer</property>
  196. <property name="distinct">true</property>
  197. <simple-property-list name="defaultValue">
  198. <value type="constant">161</value>
  199. </simple-property-list>
  200. <list-property name="selectionList"/>
  201. <property name="paramType">simple</property>
  202. <property name="controlType">text-box</property>
  203. <structure name="format">
  204. <property name="category">Unformatted</property>
  205. </structure>
  206. </scalar-parameter>
  207. <scalar-parameter name="emFolder" id="10510">
  208. <property name="valueType">static</property>
  209. <property name="dataType">string</property>
  210. <property name="distinct">true</property>
  211. <simple-property-list name="defaultValue">
  212. <value type="constant">tecnoguate</value>
  213. </simple-property-list>
  214. <list-property name="selectionList"/>
  215. <property name="paramType">simple</property>
  216. <property name="controlType">text-box</property>
  217. <structure name="format">
  218. <property name="category">Unformatted</property>
  219. </structure>
  220. </scalar-parameter>
  221. <scalar-parameter name="catIn" id="10813">
  222. <property name="valueType">static</property>
  223. <property name="isRequired">false</property>
  224. <property name="dataType">string</property>
  225. <property name="distinct">true</property>
  226. <simple-property-list name="defaultValue">
  227. <value type="constant">0</value>
  228. </simple-property-list>
  229. <list-property name="selectionList"/>
  230. <property name="paramType">simple</property>
  231. <property name="concealValue">false</property>
  232. <property name="controlType">text-box</property>
  233. <structure name="format">
  234. <property name="category">Unformatted</property>
  235. </structure>
  236. </scalar-parameter>
  237. </parameters>
  238. <data-sources>
  239. <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="webpos" id="27">
  240. <list-property name="privateDriverProperties">
  241. <ex-property>
  242. <name>contentBidiFormatStr</name>
  243. <value>ILYNN</value>
  244. </ex-property>
  245. <ex-property>
  246. <name>metadataBidiFormatStr</name>
  247. <value>ILYNN</value>
  248. </ex-property>
  249. <ex-property>
  250. <name>disabledMetadataBidiFormatStr</name>
  251. </ex-property>
  252. <ex-property>
  253. <name>disabledContentBidiFormatStr</name>
  254. </ex-property>
  255. </list-property>
  256. <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
  257. <property name="odaURL">jdbc:mysql://www.scafinext.com/scafinex_tienda</property>
  258. <property name="odaUser">scafinex_tienda</property>
  259. <encrypted-property name="odaPassword" encryptionID="base64">cGxkYjgwMA==</encrypted-property>
  260. </oda-data-source>
  261. </data-sources>
  262. <data-sets>
  263. <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet" name="kardex" id="28">
  264. <property name="nullsOrdering">nulls lowest</property>
  265. <list-property name="columnHints">
  266. <structure>
  267. <property name="columnName">valor</property>
  268. <property name="alias">cod_alterno</property>
  269. <property name="analysis">attribute</property>
  270. </structure>
  271. <structure>
  272. <property name="columnName">cat1</property>
  273. <property name="alias">linea</property>
  274. <property name="analysis">attribute</property>
  275. </structure>
  276. <structure>
  277. <property name="columnName">cat2</property>
  278. <property name="alias">marca</property>
  279. <property name="analysis">attribute</property>
  280. </structure>
  281. </list-property>
  282. <list-property name="filter">
  283. <structure>
  284. <property name="operator">ne</property>
  285. <expression name="expr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  286. if (fl[13]==0)&#13;
  287. Math.round(row["ExistenciaUF"],2);</expression>
  288. <simple-property-list name="value1">
  289. <value>0</value>
  290. </simple-property-list>
  291. </structure>
  292. <structure>
  293. <property name="operator">lt</property>
  294. <expression name="expr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  295. if (fl[14]==0)&#13;
  296. Math.round(row["ExistenciaUF"],2);</expression>
  297. <simple-property-list name="value1">
  298. <value>0</value>
  299. </simple-property-list>
  300. </structure>
  301. </list-property>
  302. <list-property name="parameters">
  303. <structure>
  304. <property name="name">sucursalId</property>
  305. <property name="paramName">sucursalId</property>
  306. <property name="nativeName">sucursalId</property>
  307. <property name="dataType">integer</property>
  308. <property name="nativeDataType">4</property>
  309. <property name="position">1</property>
  310. <property name="isOptional">true</property>
  311. <property name="allowNull">true</property>
  312. <property name="isInput">true</property>
  313. <property name="isOutput">false</property>
  314. </structure>
  315. <structure>
  316. <property name="name">usuarioId</property>
  317. <property name="paramName">usuarioId</property>
  318. <property name="nativeName">usuarioId</property>
  319. <property name="dataType">integer</property>
  320. <property name="nativeDataType">4</property>
  321. <property name="position">2</property>
  322. <property name="isOptional">true</property>
  323. <property name="allowNull">true</property>
  324. <property name="isInput">true</property>
  325. <property name="isOutput">false</property>
  326. </structure>
  327. <structure>
  328. <property name="name">bodegaId</property>
  329. <property name="paramName">bodegaId</property>
  330. <property name="nativeName">bodegaId</property>
  331. <property name="dataType">integer</property>
  332. <property name="nativeDataType">4</property>
  333. <property name="position">3</property>
  334. <property name="isOptional">true</property>
  335. <property name="allowNull">true</property>
  336. <property name="isInput">true</property>
  337. <property name="isOutput">false</property>
  338. </structure>
  339. <structure>
  340. <property name="name">fechaI</property>
  341. <property name="paramName">fechaI</property>
  342. <property name="nativeName">fechaI</property>
  343. <property name="dataType">string</property>
  344. <property name="nativeDataType">93</property>
  345. <property name="position">4</property>
  346. <property name="isOptional">true</property>
  347. <property name="allowNull">true</property>
  348. <property name="isInput">true</property>
  349. <property name="isOutput">false</property>
  350. </structure>
  351. <structure>
  352. <property name="name">fechaF</property>
  353. <property name="paramName">fechaF</property>
  354. <property name="nativeName">fechaF</property>
  355. <property name="dataType">string</property>
  356. <property name="nativeDataType">93</property>
  357. <property name="position">5</property>
  358. <property name="isOptional">true</property>
  359. <property name="allowNull">true</property>
  360. <property name="isInput">true</property>
  361. <property name="isOutput">false</property>
  362. </structure>
  363. <structure>
  364. <property name="name">productoI</property>
  365. <property name="paramName">productoI</property>
  366. <property name="nativeName">productoI</property>
  367. <property name="dataType">integer</property>
  368. <property name="nativeDataType">4</property>
  369. <property name="position">6</property>
  370. <property name="isOptional">true</property>
  371. <property name="allowNull">true</property>
  372. <property name="isInput">true</property>
  373. <property name="isOutput">false</property>
  374. </structure>
  375. <structure>
  376. <property name="name">productoF</property>
  377. <property name="paramName">productoF</property>
  378. <property name="nativeName">productoF</property>
  379. <property name="dataType">integer</property>
  380. <property name="nativeDataType">4</property>
  381. <property name="position">7</property>
  382. <property name="isOptional">true</property>
  383. <property name="allowNull">true</property>
  384. <property name="isInput">true</property>
  385. <property name="isOutput">false</property>
  386. </structure>
  387. <structure>
  388. <property name="name">buscarPor</property>
  389. <property name="paramName">buscarPor</property>
  390. <property name="nativeName">buscarPor</property>
  391. <property name="dataType">integer</property>
  392. <property name="nativeDataType">4</property>
  393. <property name="position">8</property>
  394. <property name="isOptional">true</property>
  395. <property name="allowNull">true</property>
  396. <property name="isInput">true</property>
  397. <property name="isOutput">false</property>
  398. </structure>
  399. <structure>
  400. <property name="name">catIn</property>
  401. <property name="paramName">catIn</property>
  402. <property name="nativeName">catIn</property>
  403. <property name="dataType">string</property>
  404. <property name="nativeDataType">12</property>
  405. <property name="position">9</property>
  406. <property name="isOptional">true</property>
  407. <property name="allowNull">true</property>
  408. <property name="isInput">true</property>
  409. <property name="isOutput">false</property>
  410. </structure>
  411. </list-property>
  412. <structure name="cachedMetaData">
  413. <list-property name="resultSet">
  414. <structure>
  415. <property name="position">1</property>
  416. <property name="name">sucursal</property>
  417. <property name="dataType">string</property>
  418. </structure>
  419. <structure>
  420. <property name="position">2</property>
  421. <property name="name">sucursal_id</property>
  422. <property name="dataType">integer</property>
  423. </structure>
  424. <structure>
  425. <property name="position">3</property>
  426. <property name="name">id</property>
  427. <property name="dataType">integer</property>
  428. </structure>
  429. <structure>
  430. <property name="position">4</property>
  431. <property name="name">nombre</property>
  432. <property name="dataType">string</property>
  433. </structure>
  434. <structure>
  435. <property name="position">5</property>
  436. <property name="name">documento</property>
  437. <property name="dataType">string</property>
  438. </structure>
  439. <structure>
  440. <property name="position">6</property>
  441. <property name="name">producto_id</property>
  442. <property name="dataType">integer</property>
  443. </structure>
  444. <structure>
  445. <property name="position">7</property>
  446. <property name="name">sku</property>
  447. <property name="dataType">string</property>
  448. </structure>
  449. <structure>
  450. <property name="position">8</property>
  451. <property name="name">descrip</property>
  452. <property name="dataType">string</property>
  453. </structure>
  454. <structure>
  455. <property name="position">9</property>
  456. <property name="name">debeu</property>
  457. <property name="dataType">decimal</property>
  458. </structure>
  459. <structure>
  460. <property name="position">10</property>
  461. <property name="name">haberu</property>
  462. <property name="dataType">decimal</property>
  463. </structure>
  464. <structure>
  465. <property name="position">11</property>
  466. <property name="name">debev</property>
  467. <property name="dataType">decimal</property>
  468. </structure>
  469. <structure>
  470. <property name="position">12</property>
  471. <property name="name">haberv</property>
  472. <property name="dataType">decimal</property>
  473. </structure>
  474. <structure>
  475. <property name="position">13</property>
  476. <property name="name">debec</property>
  477. <property name="dataType">decimal</property>
  478. </structure>
  479. <structure>
  480. <property name="position">14</property>
  481. <property name="name">id_14</property>
  482. <property name="dataType">decimal</property>
  483. </structure>
  484. <structure>
  485. <property name="position">15</property>
  486. <property name="name">numero</property>
  487. <property name="dataType">string</property>
  488. </structure>
  489. <structure>
  490. <property name="position">16</property>
  491. <property name="name">fecha</property>
  492. <property name="dataType">date-time</property>
  493. </structure>
  494. <structure>
  495. <property name="position">17</property>
  496. <property name="name">ExistenciaUI</property>
  497. <property name="dataType">decimal</property>
  498. </structure>
  499. <structure>
  500. <property name="position">18</property>
  501. <property name="name">ExistenciaUF</property>
  502. <property name="dataType">decimal</property>
  503. </structure>
  504. <structure>
  505. <property name="position">19</property>
  506. <property name="name">ExistenciaVI</property>
  507. <property name="dataType">decimal</property>
  508. </structure>
  509. <structure>
  510. <property name="position">20</property>
  511. <property name="name">ExistenciaVF</property>
  512. <property name="dataType">decimal</property>
  513. </structure>
  514. <structure>
  515. <property name="position">21</property>
  516. <property name="name">CostoU</property>
  517. <property name="dataType">decimal</property>
  518. </structure>
  519. <structure>
  520. <property name="position">22</property>
  521. <property name="name">cod_alterno</property>
  522. <property name="dataType">string</property>
  523. </structure>
  524. <structure>
  525. <property name="position">23</property>
  526. <property name="name">grupo</property>
  527. <property name="dataType">string</property>
  528. </structure>
  529. <structure>
  530. <property name="position">24</property>
  531. <property name="name">linea</property>
  532. <property name="dataType">string</property>
  533. </structure>
  534. <structure>
  535. <property name="position">25</property>
  536. <property name="name">marca</property>
  537. <property name="dataType">string</property>
  538. </structure>
  539. <structure>
  540. <property name="position">26</property>
  541. <property name="name">cat3</property>
  542. <property name="dataType">string</property>
  543. </structure>
  544. <structure>
  545. <property name="position">27</property>
  546. <property name="name">cat4</property>
  547. <property name="dataType">string</property>
  548. </structure>
  549. <structure>
  550. <property name="position">28</property>
  551. <property name="name">cat5</property>
  552. <property name="dataType">string</property>
  553. </structure>
  554. <structure>
  555. <property name="position">29</property>
  556. <property name="name">tipo_documento</property>
  557. <property name="dataType">decimal</property>
  558. </structure>
  559. <structure>
  560. <property name="position">30</property>
  561. <property name="name">joinid</property>
  562. <property name="dataType">string</property>
  563. </structure>
  564. <structure>
  565. <property name="position">31</property>
  566. <property name="name">nomfac</property>
  567. <property name="dataType">string</property>
  568. </structure>
  569. <structure>
  570. <property name="position">32</property>
  571. <property name="name">costoprom</property>
  572. <property name="dataType">decimal</property>
  573. </structure>
  574. <structure>
  575. <property name="position">33</property>
  576. <property name="name">saldou</property>
  577. <property name="dataType">decimal</property>
  578. </structure>
  579. <structure>
  580. <property name="position">34</property>
  581. <property name="name">saldov</property>
  582. <property name="dataType">decimal</property>
  583. </structure>
  584. </list-property>
  585. </structure>
  586. <property name="dataSource">webpos</property>
  587. <list-property name="resultSet">
  588. <structure>
  589. <property name="position">1</property>
  590. <property name="name">sucursal</property>
  591. <property name="nativeName">sucursal</property>
  592. <property name="dataType">string</property>
  593. </structure>
  594. <structure>
  595. <property name="position">2</property>
  596. <property name="name">sucursal_id</property>
  597. <property name="nativeName">sucursal_id</property>
  598. <property name="dataType">integer</property>
  599. </structure>
  600. <structure>
  601. <property name="position">3</property>
  602. <property name="name">id</property>
  603. <property name="nativeName">id</property>
  604. <property name="dataType">integer</property>
  605. </structure>
  606. <structure>
  607. <property name="position">4</property>
  608. <property name="name">nombre</property>
  609. <property name="nativeName">nombre</property>
  610. <property name="dataType">string</property>
  611. </structure>
  612. <structure>
  613. <property name="position">5</property>
  614. <property name="name">documento</property>
  615. <property name="nativeName">documento</property>
  616. <property name="dataType">string</property>
  617. </structure>
  618. <structure>
  619. <property name="position">6</property>
  620. <property name="name">producto_id</property>
  621. <property name="nativeName">producto_id</property>
  622. <property name="dataType">integer</property>
  623. </structure>
  624. <structure>
  625. <property name="position">7</property>
  626. <property name="name">sku</property>
  627. <property name="nativeName">sku</property>
  628. <property name="dataType">string</property>
  629. </structure>
  630. <structure>
  631. <property name="position">8</property>
  632. <property name="name">descrip</property>
  633. <property name="nativeName">descrip</property>
  634. <property name="dataType">string</property>
  635. </structure>
  636. <structure>
  637. <property name="position">9</property>
  638. <property name="name">debeu</property>
  639. <property name="nativeName">debeu</property>
  640. <property name="dataType">decimal</property>
  641. </structure>
  642. <structure>
  643. <property name="position">10</property>
  644. <property name="name">haberu</property>
  645. <property name="nativeName">haberu</property>
  646. <property name="dataType">decimal</property>
  647. </structure>
  648. <structure>
  649. <property name="position">11</property>
  650. <property name="name">debev</property>
  651. <property name="nativeName">debev</property>
  652. <property name="dataType">decimal</property>
  653. </structure>
  654. <structure>
  655. <property name="position">12</property>
  656. <property name="name">haberv</property>
  657. <property name="nativeName">haberv</property>
  658. <property name="dataType">decimal</property>
  659. </structure>
  660. <structure>
  661. <property name="position">13</property>
  662. <property name="name">debec</property>
  663. <property name="nativeName">debec</property>
  664. <property name="dataType">decimal</property>
  665. </structure>
  666. <structure>
  667. <property name="position">14</property>
  668. <property name="name">id_14</property>
  669. <property name="nativeName">id</property>
  670. <property name="dataType">decimal</property>
  671. </structure>
  672. <structure>
  673. <property name="position">15</property>
  674. <property name="name">numero</property>
  675. <property name="nativeName">numero</property>
  676. <property name="dataType">string</property>
  677. </structure>
  678. <structure>
  679. <property name="position">16</property>
  680. <property name="name">fecha</property>
  681. <property name="nativeName">fecha</property>
  682. <property name="dataType">date-time</property>
  683. </structure>
  684. <structure>
  685. <property name="position">17</property>
  686. <property name="name">ExistenciaUI</property>
  687. <property name="nativeName">ExistenciaUI</property>
  688. <property name="dataType">decimal</property>
  689. </structure>
  690. <structure>
  691. <property name="position">18</property>
  692. <property name="name">ExistenciaUF</property>
  693. <property name="nativeName">ExistenciaUF</property>
  694. <property name="dataType">decimal</property>
  695. </structure>
  696. <structure>
  697. <property name="position">19</property>
  698. <property name="name">ExistenciaVI</property>
  699. <property name="nativeName">ExistenciaVI</property>
  700. <property name="dataType">decimal</property>
  701. </structure>
  702. <structure>
  703. <property name="position">20</property>
  704. <property name="name">ExistenciaVF</property>
  705. <property name="nativeName">ExistenciaVF</property>
  706. <property name="dataType">decimal</property>
  707. </structure>
  708. <structure>
  709. <property name="position">21</property>
  710. <property name="name">CostoU</property>
  711. <property name="nativeName">CostoU</property>
  712. <property name="dataType">decimal</property>
  713. </structure>
  714. <structure>
  715. <property name="position">22</property>
  716. <property name="name">valor</property>
  717. <property name="nativeName">valor</property>
  718. <property name="dataType">string</property>
  719. </structure>
  720. <structure>
  721. <property name="position">23</property>
  722. <property name="name">grupo</property>
  723. <property name="nativeName">grupo</property>
  724. <property name="dataType">string</property>
  725. </structure>
  726. <structure>
  727. <property name="position">24</property>
  728. <property name="name">cat1</property>
  729. <property name="nativeName">cat1</property>
  730. <property name="dataType">string</property>
  731. </structure>
  732. <structure>
  733. <property name="position">25</property>
  734. <property name="name">cat2</property>
  735. <property name="nativeName">cat2</property>
  736. <property name="dataType">string</property>
  737. </structure>
  738. <structure>
  739. <property name="position">26</property>
  740. <property name="name">cat3</property>
  741. <property name="nativeName">cat3</property>
  742. <property name="dataType">string</property>
  743. </structure>
  744. <structure>
  745. <property name="position">27</property>
  746. <property name="name">cat4</property>
  747. <property name="nativeName">cat4</property>
  748. <property name="dataType">string</property>
  749. </structure>
  750. <structure>
  751. <property name="position">28</property>
  752. <property name="name">cat5</property>
  753. <property name="nativeName">cat5</property>
  754. <property name="dataType">string</property>
  755. </structure>
  756. <structure>
  757. <property name="position">29</property>
  758. <property name="name">tipo_documento</property>
  759. <property name="nativeName">tipo_documento</property>
  760. <property name="dataType">decimal</property>
  761. </structure>
  762. <structure>
  763. <property name="position">30</property>
  764. <property name="name">joinid</property>
  765. <property name="nativeName">joinid</property>
  766. <property name="dataType">string</property>
  767. </structure>
  768. <structure>
  769. <property name="position">31</property>
  770. <property name="name">nomfac</property>
  771. <property name="nativeName">nomfac</property>
  772. <property name="dataType">string</property>
  773. </structure>
  774. <structure>
  775. <property name="position">32</property>
  776. <property name="name">costoprom</property>
  777. <property name="nativeName">costoprom</property>
  778. <property name="dataType">decimal</property>
  779. </structure>
  780. <structure>
  781. <property name="position">33</property>
  782. <property name="name">saldou</property>
  783. <property name="nativeName">saldou</property>
  784. <property name="dataType">decimal</property>
  785. </structure>
  786. <structure>
  787. <property name="position">34</property>
  788. <property name="name">saldov</property>
  789. <property name="nativeName">saldov</property>
  790. <property name="dataType">decimal</property>
  791. </structure>
  792. </list-property>
  793. <xml-property name="queryText"><![CDATA[{call rpt_pos_kardex (?,?,?,?,?,?,?,?,?)} ]]></xml-property>
  794. <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  795. <model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  796. <Version>2.0</Version>
  797. <DataSetParameters>
  798. <parameter>
  799. <design:ParameterDefinition>
  800. <design:inOutMode>In</design:inOutMode>
  801. <design:attributes>
  802. <design:identifier>
  803. <design:name>sucursalId</design:name>
  804. <design:position>1</design:position>
  805. </design:identifier>
  806. <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
  807. <design:precision>10</design:precision>
  808. <design:scale>0</design:scale>
  809. <design:nullability>Nullable</design:nullability>
  810. </design:attributes>
  811. <design:inputAttributes>
  812. <design:elementAttributes>
  813. <design:optional>true</design:optional>
  814. </design:elementAttributes>
  815. </design:inputAttributes>
  816. </design:ParameterDefinition>
  817. </parameter>
  818. <parameter>
  819. <design:ParameterDefinition>
  820. <design:inOutMode>In</design:inOutMode>
  821. <design:attributes>
  822. <design:identifier>
  823. <design:name>usuarioId</design:name>
  824. <design:position>2</design:position>
  825. </design:identifier>
  826. <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
  827. <design:precision>10</design:precision>
  828. <design:scale>0</design:scale>
  829. <design:nullability>Nullable</design:nullability>
  830. </design:attributes>
  831. <design:inputAttributes>
  832. <design:elementAttributes>
  833. <design:optional>true</design:optional>
  834. </design:elementAttributes>
  835. </design:inputAttributes>
  836. </design:ParameterDefinition>
  837. </parameter>
  838. <parameter>
  839. <design:ParameterDefinition>
  840. <design:inOutMode>In</design:inOutMode>
  841. <design:attributes>
  842. <design:identifier>
  843. <design:name>bodegaId</design:name>
  844. <design:position>3</design:position>
  845. </design:identifier>
  846. <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
  847. <design:precision>10</design:precision>
  848. <design:scale>0</design:scale>
  849. <design:nullability>Nullable</design:nullability>
  850. </design:attributes>
  851. <design:inputAttributes>
  852. <design:elementAttributes>
  853. <design:optional>true</design:optional>
  854. </design:elementAttributes>
  855. </design:inputAttributes>
  856. </design:ParameterDefinition>
  857. </parameter>
  858. <parameter>
  859. <design:ParameterDefinition>
  860. <design:inOutMode>In</design:inOutMode>
  861. <design:attributes>
  862. <design:identifier>
  863. <design:name>fechaI</design:name>
  864. <design:position>4</design:position>
  865. </design:identifier>
  866. <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
  867. <design:precision>19</design:precision>
  868. <design:scale>0</design:scale>
  869. <design:nullability>Nullable</design:nullability>
  870. </design:attributes>
  871. <design:inputAttributes>
  872. <design:elementAttributes>
  873. <design:optional>true</design:optional>
  874. </design:elementAttributes>
  875. </design:inputAttributes>
  876. </design:ParameterDefinition>
  877. </parameter>
  878. <parameter>
  879. <design:ParameterDefinition>
  880. <design:inOutMode>In</design:inOutMode>
  881. <design:attributes>
  882. <design:identifier>
  883. <design:name>fechaF</design:name>
  884. <design:position>5</design:position>
  885. </design:identifier>
  886. <design:nativeDataTypeCode>93</design:nativeDataTypeCode>
  887. <design:precision>19</design:precision>
  888. <design:scale>0</design:scale>
  889. <design:nullability>Nullable</design:nullability>
  890. </design:attributes>
  891. <design:inputAttributes>
  892. <design:elementAttributes>
  893. <design:optional>true</design:optional>
  894. </design:elementAttributes>
  895. </design:inputAttributes>
  896. </design:ParameterDefinition>
  897. </parameter>
  898. <parameter>
  899. <design:ParameterDefinition>
  900. <design:inOutMode>In</design:inOutMode>
  901. <design:attributes>
  902. <design:identifier>
  903. <design:name>productoI</design:name>
  904. <design:position>6</design:position>
  905. </design:identifier>
  906. <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
  907. <design:precision>10</design:precision>
  908. <design:scale>0</design:scale>
  909. <design:nullability>Nullable</design:nullability>
  910. </design:attributes>
  911. <design:inputAttributes>
  912. <design:elementAttributes>
  913. <design:optional>true</design:optional>
  914. </design:elementAttributes>
  915. </design:inputAttributes>
  916. </design:ParameterDefinition>
  917. </parameter>
  918. <parameter>
  919. <design:ParameterDefinition>
  920. <design:inOutMode>In</design:inOutMode>
  921. <design:attributes>
  922. <design:identifier>
  923. <design:name>productoF</design:name>
  924. <design:position>7</design:position>
  925. </design:identifier>
  926. <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
  927. <design:precision>10</design:precision>
  928. <design:scale>0</design:scale>
  929. <design:nullability>Nullable</design:nullability>
  930. </design:attributes>
  931. <design:inputAttributes>
  932. <design:elementAttributes>
  933. <design:optional>true</design:optional>
  934. </design:elementAttributes>
  935. </design:inputAttributes>
  936. </design:ParameterDefinition>
  937. </parameter>
  938. <parameter>
  939. <design:ParameterDefinition>
  940. <design:inOutMode>In</design:inOutMode>
  941. <design:attributes>
  942. <design:identifier>
  943. <design:name>buscarPor</design:name>
  944. <design:position>8</design:position>
  945. </design:identifier>
  946. <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
  947. <design:precision>10</design:precision>
  948. <design:scale>0</design:scale>
  949. <design:nullability>Nullable</design:nullability>
  950. </design:attributes>
  951. <design:inputAttributes>
  952. <design:elementAttributes>
  953. <design:optional>true</design:optional>
  954. </design:elementAttributes>
  955. </design:inputAttributes>
  956. </design:ParameterDefinition>
  957. </parameter>
  958. <parameter>
  959. <design:ParameterDefinition>
  960. <design:inOutMode>In</design:inOutMode>
  961. <design:attributes>
  962. <design:identifier>
  963. <design:name>catIn</design:name>
  964. <design:position>9</design:position>
  965. </design:identifier>
  966. <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
  967. <design:precision>1000</design:precision>
  968. <design:scale>0</design:scale>
  969. <design:nullability>Nullable</design:nullability>
  970. </design:attributes>
  971. <design:inputAttributes>
  972. <design:elementAttributes>
  973. <design:optional>true</design:optional>
  974. </design:elementAttributes>
  975. </design:inputAttributes>
  976. </design:ParameterDefinition>
  977. </parameter>
  978. </DataSetParameters>
  979. </model:DesignValues>]]></xml-property>
  980. </oda-data-set>
  981. <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="encabezado" id="463">
  982. <property name="nullsOrdering">nulls lowest</property>
  983. <list-property name="parameters">
  984. <structure>
  985. <property name="name">sucId</property>
  986. <property name="paramName">sucId</property>
  987. <property name="dataType">integer</property>
  988. <property name="position">1</property>
  989. <property name="isInput">true</property>
  990. <property name="isOutput">false</property>
  991. </structure>
  992. </list-property>
  993. <structure name="cachedMetaData">
  994. <list-property name="resultSet">
  995. <structure>
  996. <property name="position">1</property>
  997. <property name="name">nombre_empresa</property>
  998. <property name="dataType">string</property>
  999. </structure>
  1000. <structure>
  1001. <property name="position">2</property>
  1002. <property name="name">razon_social</property>
  1003. <property name="dataType">string</property>
  1004. </structure>
  1005. <structure>
  1006. <property name="position">3</property>
  1007. <property name="name">nit</property>
  1008. <property name="dataType">string</property>
  1009. </structure>
  1010. <structure>
  1011. <property name="position">4</property>
  1012. <property name="name">direccion</property>
  1013. <property name="dataType">string</property>
  1014. </structure>
  1015. <structure>
  1016. <property name="position">5</property>
  1017. <property name="name">logo</property>
  1018. <property name="dataType">string</property>
  1019. </structure>
  1020. <structure>
  1021. <property name="position">6</property>
  1022. <property name="name">nombre</property>
  1023. <property name="dataType">string</property>
  1024. </structure>
  1025. <structure>
  1026. <property name="position">7</property>
  1027. <property name="name">simbolo</property>
  1028. <property name="dataType">string</property>
  1029. </structure>
  1030. </list-property>
  1031. </structure>
  1032. <property name="dataSource">webpos</property>
  1033. <list-property name="resultSet">
  1034. <structure>
  1035. <property name="position">1</property>
  1036. <property name="name">nombre_empresa</property>
  1037. <property name="nativeName">nombre_empresa</property>
  1038. <property name="dataType">string</property>
  1039. </structure>
  1040. <structure>
  1041. <property name="position">2</property>
  1042. <property name="name">razon_social</property>
  1043. <property name="nativeName">razon_social</property>
  1044. <property name="dataType">string</property>
  1045. </structure>
  1046. <structure>
  1047. <property name="position">3</property>
  1048. <property name="name">nit</property>
  1049. <property name="nativeName">nit</property>
  1050. <property name="dataType">string</property>
  1051. </structure>
  1052. <structure>
  1053. <property name="position">4</property>
  1054. <property name="name">direccion</property>
  1055. <property name="nativeName">direccion</property>
  1056. <property name="dataType">string</property>
  1057. </structure>
  1058. <structure>
  1059. <property name="position">5</property>
  1060. <property name="name">logo</property>
  1061. <property name="nativeName">logo</property>
  1062. <property name="dataType">string</property>
  1063. </structure>
  1064. <structure>
  1065. <property name="position">6</property>
  1066. <property name="name">nombre</property>
  1067. <property name="nativeName">nombre</property>
  1068. <property name="dataType">string</property>
  1069. </structure>
  1070. <structure>
  1071. <property name="position">7</property>
  1072. <property name="name">simbolo</property>
  1073. <property name="nativeName">simbolo</property>
  1074. <property name="dataType">string</property>
  1075. </structure>
  1076. </list-property>
  1077. <xml-property name="queryText"><![CDATA[SELECT s.nombre_empresa, s.razon_social, s.nit, s.direccion, s.logo, m.nombre as moneda, m.simbolo
  1078. FROM sucursal s
  1079. left join moneda m ON (s.moneda_id = m.id)
  1080. WHERE s.id = ?; ]]></xml-property>
  1081. </oda-data-set>
  1082. </data-sets>
  1083. <styles>
  1084. <style name="report" id="24">
  1085. <property name="fontFamily">sans-serif</property>
  1086. <property name="fontSize">10pt</property>
  1087. </style>
  1088. <style name="crosstab-cell" id="25">
  1089. <property name="borderBottomColor">#CCCCCC</property>
  1090. <property name="borderBottomStyle">solid</property>
  1091. <property name="borderBottomWidth">1pt</property>
  1092. <property name="borderLeftColor">#CCCCCC</property>
  1093. <property name="borderLeftStyle">solid</property>
  1094. <property name="borderLeftWidth">1pt</property>
  1095. <property name="borderRightColor">#CCCCCC</property>
  1096. <property name="borderRightStyle">solid</property>
  1097. <property name="borderRightWidth">1pt</property>
  1098. <property name="borderTopColor">#CCCCCC</property>
  1099. <property name="borderTopStyle">solid</property>
  1100. <property name="borderTopWidth">1pt</property>
  1101. </style>
  1102. <style name="crosstab" id="26">
  1103. <property name="borderBottomColor">#CCCCCC</property>
  1104. <property name="borderBottomStyle">solid</property>
  1105. <property name="borderBottomWidth">1pt</property>
  1106. <property name="borderLeftColor">#CCCCCC</property>
  1107. <property name="borderLeftStyle">solid</property>
  1108. <property name="borderLeftWidth">1pt</property>
  1109. <property name="borderRightColor">#CCCCCC</property>
  1110. <property name="borderRightStyle">solid</property>
  1111. <property name="borderRightWidth">1pt</property>
  1112. <property name="borderTopColor">#CCCCCC</property>
  1113. <property name="borderTopStyle">solid</property>
  1114. <property name="borderTopWidth">1pt</property>
  1115. </style>
  1116. </styles>
  1117. <page-setup>
  1118. <simple-master-page name="Simple MasterPage" id="2">
  1119. <property name="type">us-legal</property>
  1120. <property name="orientation">landscape</property>
  1121. <property name="leftMargin">0.1in</property>
  1122. <property name="rightMargin">0.1in</property>
  1123. <property name="headerHeight">0.8in</property>
  1124. <property name="footerHeight">0.5in</property>
  1125. <page-header>
  1126. <grid id="892">
  1127. <property name="backgroundColor">#FFFFFF</property>
  1128. <property name="color">#000000</property>
  1129. <property name="height">1.21875in</property>
  1130. <property name="width">10.333333333333334in</property>
  1131. <column id="987">
  1132. <property name="width">3.9791666666666665in</property>
  1133. </column>
  1134. <column id="988">
  1135. <property name="width">3.7083333333333335in</property>
  1136. </column>
  1137. <column id="989">
  1138. <property name="width">2.6458333333333335in</property>
  1139. </column>
  1140. <row id="795">
  1141. <property name="height">1.21875in</property>
  1142. <cell id="990">
  1143. <property name="colSpan">1</property>
  1144. <property name="rowSpan">1</property>
  1145. <grid id="975">
  1146. <column id="976"/>
  1147. <row id="977">
  1148. <cell id="978">
  1149. <data id="924">
  1150. <property name="fontWeight">normal</property>
  1151. <property name="paddingTop">0pt</property>
  1152. <property name="paddingLeft">0pt</property>
  1153. <property name="paddingBottom">0pt</property>
  1154. <property name="paddingRight">0pt</property>
  1155. <property name="display">inline</property>
  1156. <property name="dataSet">encabezado</property>
  1157. <list-property name="visibility">
  1158. <structure>
  1159. <property name="format">all</property>
  1160. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');
  1161. fl[0]==0</expression>
  1162. </structure>
  1163. </list-property>
  1164. <list-property name="boundDataColumns">
  1165. <structure>
  1166. <property name="name">nombre_empresa</property>
  1167. <text-property name="displayName">nombre_empresa</text-property>
  1168. <expression name="expression" type="javascript">dataSetRow["nombre_empresa"]</expression>
  1169. <property name="dataType">string</property>
  1170. </structure>
  1171. </list-property>
  1172. <property name="resultSetColumn">nombre_empresa</property>
  1173. </data>
  1174. </cell>
  1175. </row>
  1176. <row id="979">
  1177. <cell id="980">
  1178. <data id="925">
  1179. <property name="fontWeight">normal</property>
  1180. <property name="paddingTop">0pt</property>
  1181. <property name="paddingLeft">0pt</property>
  1182. <property name="paddingBottom">0pt</property>
  1183. <property name="paddingRight">0pt</property>
  1184. <property name="display">inline</property>
  1185. <property name="dataSet">encabezado</property>
  1186. <list-property name="visibility">
  1187. <structure>
  1188. <property name="format">all</property>
  1189. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');
  1190. fl[1]==0</expression>
  1191. </structure>
  1192. </list-property>
  1193. <list-property name="boundDataColumns">
  1194. <structure>
  1195. <property name="name">razon_social</property>
  1196. <text-property name="displayName">razon_social</text-property>
  1197. <expression name="expression" type="javascript">dataSetRow["razon_social"]</expression>
  1198. <property name="dataType">string</property>
  1199. </structure>
  1200. </list-property>
  1201. <property name="resultSetColumn">razon_social</property>
  1202. </data>
  1203. </cell>
  1204. </row>
  1205. <row id="981">
  1206. <cell id="982">
  1207. <data id="926">
  1208. <property name="fontWeight">normal</property>
  1209. <property name="paddingTop">0pt</property>
  1210. <property name="paddingLeft">0pt</property>
  1211. <property name="paddingBottom">0pt</property>
  1212. <property name="paddingRight">0pt</property>
  1213. <property name="display">inline</property>
  1214. <property name="dataSet">encabezado</property>
  1215. <list-property name="visibility">
  1216. <structure>
  1217. <property name="format">all</property>
  1218. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');
  1219. fl[3]==0</expression>
  1220. </structure>
  1221. </list-property>
  1222. <list-property name="boundDataColumns">
  1223. <structure>
  1224. <property name="name">nit</property>
  1225. <text-property name="displayName">nit</text-property>
  1226. <expression name="expression" type="javascript">dataSetRow["nit"]</expression>
  1227. <property name="dataType">string</property>
  1228. </structure>
  1229. </list-property>
  1230. <property name="resultSetColumn">nit</property>
  1231. </data>
  1232. </cell>
  1233. </row>
  1234. <row id="983">
  1235. <cell id="984">
  1236. <grid id="963">
  1237. <property name="width">3.6145833333333335in</property>
  1238. <column id="964">
  1239. <property name="width">1.8020833333333333in</property>
  1240. </column>
  1241. <column id="965">
  1242. <property name="width">1.8125in</property>
  1243. </column>
  1244. <row id="966">
  1245. <cell id="967">
  1246. <label id="941">
  1247. <property name="fontSize">10pt</property>
  1248. <property name="fontWeight">normal</property>
  1249. <property name="textAlign">left</property>
  1250. <list-property name="visibility">
  1251. <structure>
  1252. <property name="format">all</property>
  1253. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1254. fl[4]==0</expression>
  1255. </structure>
  1256. </list-property>
  1257. <text-property name="text">Cantidades expresadas en:</text-property>
  1258. </label>
  1259. </cell>
  1260. <cell id="968">
  1261. <grid id="10629">
  1262. <property name="width">2.5520833333333335in</property>
  1263. <column id="10630">
  1264. <property name="width">0.1875in</property>
  1265. </column>
  1266. <column id="10631">
  1267. <property name="width">0.15625in</property>
  1268. </column>
  1269. <column id="10632">
  1270. <property name="width">0.8541666666666666in</property>
  1271. </column>
  1272. <column id="10633">
  1273. <property name="width">0.10416666666666667in</property>
  1274. </column>
  1275. <column id="10634">
  1276. <property name="width">1.25in</property>
  1277. </column>
  1278. <row id="10635">
  1279. <cell id="10636">
  1280. <data id="10637">
  1281. <property name="textAlign">right</property>
  1282. <property name="dataSet">encabezado</property>
  1283. <list-property name="visibility">
  1284. <structure>
  1285. <property name="format">all</property>
  1286. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1287. fl[10]==0</expression>
  1288. </structure>
  1289. </list-property>
  1290. <list-property name="boundDataColumns">
  1291. <structure>
  1292. <property name="name">simbolo</property>
  1293. <text-property name="displayName">simbolo</text-property>
  1294. <expression name="expression" type="javascript">dataSetRow["simbolo"]</expression>
  1295. <property name="dataType">string</property>
  1296. </structure>
  1297. </list-property>
  1298. <property name="resultSetColumn">simbolo</property>
  1299. </data>
  1300. </cell>
  1301. <cell id="10638">
  1302. <label id="10639">
  1303. <property name="textAlign">left</property>
  1304. <list-property name="visibility">
  1305. <structure>
  1306. <property name="format">all</property>
  1307. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1308. fl[10]==0</expression>
  1309. </structure>
  1310. </list-property>
  1311. <text-property name="text">-</text-property>
  1312. </label>
  1313. </cell>
  1314. <cell id="10640">
  1315. <data id="10641">
  1316. <property name="fontWeight">normal</property>
  1317. <property name="marginTop">0pt</property>
  1318. <property name="marginRight">75pt</property>
  1319. <property name="paddingLeft">0pt</property>
  1320. <property name="textAlign">left</property>
  1321. <property name="dataSet">encabezado</property>
  1322. <list-property name="visibility">
  1323. <structure>
  1324. <property name="format">all</property>
  1325. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');
  1326. fl[4]==0</expression>
  1327. </structure>
  1328. </list-property>
  1329. <list-property name="boundDataColumns">
  1330. <structure>
  1331. <property name="name">nombre</property>
  1332. <text-property name="displayName">nombre</text-property>
  1333. <expression name="expression" type="javascript">dataSetRow["nombre"]</expression>
  1334. <property name="dataType">string</property>
  1335. </structure>
  1336. </list-property>
  1337. <property name="resultSetColumn">nombre</property>
  1338. </data>
  1339. </cell>
  1340. <cell id="10642">
  1341. <label id="10643">
  1342. <property name="textAlign">left</property>
  1343. <list-property name="visibility">
  1344. <structure>
  1345. <property name="format">all</property>
  1346. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1347. fl[11]==0</expression>
  1348. </structure>
  1349. </list-property>
  1350. <text-property name="text">-</text-property>
  1351. </label>
  1352. </cell>
  1353. <cell id="10644">
  1354. <data id="10645">
  1355. <property name="textAlign">left</property>
  1356. <property name="dataSet">encabezado</property>
  1357. <list-property name="visibility">
  1358. <structure>
  1359. <property name="format">all</property>
  1360. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1361. fl[11]==0</expression>
  1362. </structure>
  1363. </list-property>
  1364. <list-property name="boundDataColumns">
  1365. <structure>
  1366. <property name="name">simbolo</property>
  1367. <text-property name="displayName">simbolo</text-property>
  1368. <expression name="expression" type="javascript">dataSetRow["simbolo"]</expression>
  1369. <property name="dataType">string</property>
  1370. </structure>
  1371. </list-property>
  1372. <property name="resultSetColumn">simbolo</property>
  1373. </data>
  1374. </cell>
  1375. </row>
  1376. </grid>
  1377. </cell>
  1378. </row>
  1379. </grid>
  1380. </cell>
  1381. </row>
  1382. </grid>
  1383. </cell>
  1384. <cell id="991">
  1385. <property name="colSpan">1</property>
  1386. <property name="rowSpan">1</property>
  1387. <property name="fontWeight">bold</property>
  1388. <property name="textAlign">center</property>
  1389. <grid id="969">
  1390. <property name="height">1.1354166666666667in</property>
  1391. <column id="970"/>
  1392. <row id="971">
  1393. <cell id="972"/>
  1394. </row>
  1395. <row id="973">
  1396. <property name="height">0.96875in</property>
  1397. <cell id="974">
  1398. <grid id="943">
  1399. <property name="marginTop">15pt</property>
  1400. <property name="width">3.4791666666666665in</property>
  1401. <column id="944">
  1402. <property name="width">0.8333333333333334in</property>
  1403. </column>
  1404. <column id="945">
  1405. <property name="width">0.7708333333333334in</property>
  1406. </column>
  1407. <column id="946">
  1408. <property name="width">0.34375in</property>
  1409. </column>
  1410. <column id="947">
  1411. <property name="width">1.53125in</property>
  1412. </column>
  1413. <row id="948">
  1414. <cell id="949">
  1415. <property name="colSpan">4</property>
  1416. <property name="rowSpan">1</property>
  1417. <label id="820">
  1418. <property name="fontWeight">bold</property>
  1419. <property name="textAlign">center</property>
  1420. <text-property name="text">REPORTE KARDEX</text-property>
  1421. </label>
  1422. </cell>
  1423. </row>
  1424. <row id="953">
  1425. <cell id="954">
  1426. <property name="textAlign">right</property>
  1427. <label id="849">
  1428. <property name="fontWeight">normal</property>
  1429. <property name="textAlign">right</property>
  1430. <property name="display">inline</property>
  1431. <text-property name="text">DEL</text-property>
  1432. </label>
  1433. </cell>
  1434. <cell id="955">
  1435. <property name="textAlign">left</property>
  1436. <data id="853">
  1437. <property name="fontWeight">normal</property>
  1438. <property name="marginLeft">3pt</property>
  1439. <structure name="dateTimeFormat">
  1440. <property name="category">Custom</property>
  1441. <property name="pattern">dd/MM/yyyy</property>
  1442. <property name="locale">es_GT</property>
  1443. </structure>
  1444. <property name="textAlign">left</property>
  1445. <list-property name="boundDataColumns">
  1446. <structure>
  1447. <property name="name">fechaI</property>
  1448. <expression name="expression" type="javascript">params["fechaI"]</expression>
  1449. <property name="dataType">date</property>
  1450. </structure>
  1451. </list-property>
  1452. <structure name="toc"/>
  1453. <property name="resultSetColumn">fechaI</property>
  1454. </data>
  1455. </cell>
  1456. <cell id="956">
  1457. <property name="textAlign">right</property>
  1458. <label id="852">
  1459. <property name="fontWeight">normal</property>
  1460. <property name="marginLeft">2pt</property>
  1461. <property name="marginRight">7pt</property>
  1462. <property name="textAlign">left</property>
  1463. <property name="display">inline</property>
  1464. <text-property name="text">AL</text-property>
  1465. </label>
  1466. </cell>
  1467. <cell id="957">
  1468. <property name="textAlign">left</property>
  1469. <data id="854">
  1470. <property name="fontWeight">normal</property>
  1471. <structure name="dateTimeFormat">
  1472. <property name="category">Custom</property>
  1473. <property name="pattern">dd/MM/yyyy</property>
  1474. <property name="locale">es_GT</property>
  1475. </structure>
  1476. <property name="textAlign">left</property>
  1477. <list-property name="boundDataColumns">
  1478. <structure>
  1479. <property name="name">fechaF</property>
  1480. <expression name="expression" type="javascript">params["fechaF"]</expression>
  1481. <property name="dataType">date</property>
  1482. </structure>
  1483. </list-property>
  1484. <property name="resultSetColumn">fechaF</property>
  1485. </data>
  1486. </cell>
  1487. </row>
  1488. </grid>
  1489. </cell>
  1490. </row>
  1491. </grid>
  1492. </cell>
  1493. <cell id="992">
  1494. <property name="colSpan">1</property>
  1495. <property name="rowSpan">1</property>
  1496. <grid id="903">
  1497. <property name="height">1.0729166666666667in</property>
  1498. <property name="width">3.292134831460674in</property>
  1499. <column id="906">
  1500. <property name="width">2.6853932584269664in</property>
  1501. </column>
  1502. <row id="907">
  1503. <property name="height">1.0729166666666667in</property>
  1504. <cell id="910">
  1505. <image id="923">
  1506. <property name="marginLeft">65pt</property>
  1507. <property name="height">0.7604166666666666in</property>
  1508. <property name="width">1.625in</property>
  1509. <property name="dataSet">encabezado</property>
  1510. <list-property name="visibility">
  1511. <structure>
  1512. <property name="format">all</property>
  1513. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1514. fl[8]==0</expression>
  1515. </structure>
  1516. </list-property>
  1517. <list-property name="boundDataColumns">
  1518. <structure>
  1519. <property name="name">nombre_empresa</property>
  1520. <expression name="expression" type="javascript">dataSetRow["nombre_empresa"]</expression>
  1521. <property name="dataType">string</property>
  1522. </structure>
  1523. <structure>
  1524. <property name="name">razon_social</property>
  1525. <expression name="expression" type="javascript">dataSetRow["razon_social"]</expression>
  1526. <property name="dataType">string</property>
  1527. </structure>
  1528. <structure>
  1529. <property name="name">nit</property>
  1530. <expression name="expression" type="javascript">dataSetRow["nit"]</expression>
  1531. <property name="dataType">string</property>
  1532. </structure>
  1533. <structure>
  1534. <property name="name">direccion</property>
  1535. <expression name="expression" type="javascript">dataSetRow["direccion"]</expression>
  1536. <property name="dataType">string</property>
  1537. </structure>
  1538. <structure>
  1539. <property name="name">logo</property>
  1540. <expression name="expression" type="javascript">dataSetRow["logo"]</expression>
  1541. <property name="dataType">string</property>
  1542. </structure>
  1543. <structure>
  1544. <property name="name">nombre</property>
  1545. <expression name="expression" type="javascript">dataSetRow["nombre"]</expression>
  1546. <property name="dataType">string</property>
  1547. </structure>
  1548. </list-property>
  1549. <property name="source">url</property>
  1550. <expression name="uri" type="javascript">"http://www.scafinext.com/"+params["emFolder"].value+"/images/"+row["logo"]</expression>
  1551. </image>
  1552. </cell>
  1553. </row>
  1554. </grid>
  1555. </cell>
  1556. </row>
  1557. </grid>
  1558. </page-header>
  1559. <page-footer>
  1560. <grid id="48">
  1561. <property name="marginTop">13pt</property>
  1562. <property name="height">0.3541666666666667in</property>
  1563. <property name="width">10.354166666666666in</property>
  1564. <column id="67">
  1565. <property name="width">4.208333333333333in</property>
  1566. </column>
  1567. <column id="49">
  1568. <property name="width">3.1979166666666665in</property>
  1569. </column>
  1570. <column id="993">
  1571. <property name="width">2.9479166666666665in</property>
  1572. </column>
  1573. <row id="52">
  1574. <property name="height">0.3541666666666667in</property>
  1575. <cell id="66">
  1576. <grid id="54">
  1577. <property name="width">3.8541666666666665in</property>
  1578. <column id="55">
  1579. <property name="width">0.6875in</property>
  1580. </column>
  1581. <column id="56">
  1582. <property name="width">0.2708333333333333in</property>
  1583. </column>
  1584. <column id="57">
  1585. <property name="width">2.8958333333333335in</property>
  1586. </column>
  1587. <row id="58">
  1588. <cell id="59">
  1589. <property name="textAlign">right</property>
  1590. <auto-text id="60">
  1591. <list-property name="visibility">
  1592. <structure>
  1593. <property name="format">all</property>
  1594. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1595. fl[7]==0</expression>
  1596. </structure>
  1597. </list-property>
  1598. <property name="type">page-number</property>
  1599. </auto-text>
  1600. </cell>
  1601. <cell id="61">
  1602. <text id="62">
  1603. <list-property name="visibility">
  1604. <structure>
  1605. <property name="format">all</property>
  1606. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1607. fl[7]==0</expression>
  1608. </structure>
  1609. </list-property>
  1610. <property name="contentType">plain</property>
  1611. <text-property name="content"><![CDATA[ /]]></text-property>
  1612. </text>
  1613. </cell>
  1614. <cell id="63">
  1615. <property name="textAlign">left</property>
  1616. <auto-text id="64">
  1617. <list-property name="visibility">
  1618. <structure>
  1619. <property name="format">all</property>
  1620. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1621. fl[7]==0</expression>
  1622. </structure>
  1623. </list-property>
  1624. <property name="type">total-page</property>
  1625. </auto-text>
  1626. </cell>
  1627. </row>
  1628. </grid>
  1629. </cell>
  1630. <cell id="53">
  1631. <property name="textAlign">center</property>
  1632. <data id="927">
  1633. <property name="marginRight">35pt</property>
  1634. <property name="dataSet">encabezado</property>
  1635. <list-property name="visibility">
  1636. <structure>
  1637. <property name="format">all</property>
  1638. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');
  1639. fl[2]==0</expression>
  1640. </structure>
  1641. </list-property>
  1642. <list-property name="boundDataColumns">
  1643. <structure>
  1644. <property name="name">direccion</property>
  1645. <text-property name="displayName">direccion</text-property>
  1646. <expression name="expression" type="javascript">dataSetRow["direccion"]</expression>
  1647. <property name="dataType">string</property>
  1648. </structure>
  1649. </list-property>
  1650. <property name="resultSetColumn">direccion</property>
  1651. </data>
  1652. </cell>
  1653. <cell id="994">
  1654. <property name="textAlign">center</property>
  1655. <grid id="995">
  1656. <property name="marginLeft">60pt</property>
  1657. <property name="width">3.7083333333333335in</property>
  1658. <column id="996">
  1659. <property name="width">1.21875in</property>
  1660. </column>
  1661. <column id="997">
  1662. <property name="width">2.4895833333333335in</property>
  1663. </column>
  1664. <row id="998">
  1665. <cell id="999">
  1666. <text id="1007">
  1667. <property name="textAlign">right</property>
  1668. <list-property name="visibility">
  1669. <structure>
  1670. <property name="format">all</property>
  1671. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1672. fl[5]==0</expression>
  1673. </structure>
  1674. </list-property>
  1675. <property name="contentType">html</property>
  1676. <text-property name="content"><![CDATA[<value-of format="dd/MM/yyyy">new Date()</value-of>]]></text-property>
  1677. </text>
  1678. </cell>
  1679. <cell id="1000">
  1680. <text id="3">
  1681. <property name="marginLeft">5pt</property>
  1682. <property name="textAlign">left</property>
  1683. <list-property name="visibility">
  1684. <structure>
  1685. <property name="format">all</property>
  1686. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  1687. fl[6]==0</expression>
  1688. </structure>
  1689. </list-property>
  1690. <property name="contentType">html</property>
  1691. <text-property name="content"><![CDATA[<value-of format="hh:mm:ss a">new Date()</value-of>]]></text-property>
  1692. </text>
  1693. </cell>
  1694. </row>
  1695. </grid>
  1696. </cell>
  1697. </row>
  1698. </grid>
  1699. </page-footer>
  1700. </simple-master-page>
  1701. </page-setup>
  1702. <body>
  1703. <table id="4">
  1704. <property name="width">13.75in</property>
  1705. <property name="dataSet">kardex</property>
  1706. <list-property name="boundDataColumns">
  1707. <structure>
  1708. <property name="name">sucursal_id</property>
  1709. <text-property name="displayName">sucursal_id</text-property>
  1710. <expression name="expression" type="javascript">dataSetRow["sucursal_id"]</expression>
  1711. <property name="dataType">integer</property>
  1712. </structure>
  1713. <structure>
  1714. <property name="name">documento</property>
  1715. <text-property name="displayName">documento</text-property>
  1716. <expression name="expression" type="javascript">dataSetRow["documento"]</expression>
  1717. <property name="dataType">string</property>
  1718. </structure>
  1719. <structure>
  1720. <property name="name">producto_id</property>
  1721. <text-property name="displayName">producto_id</text-property>
  1722. <expression name="expression" type="javascript">dataSetRow["producto_id"]</expression>
  1723. <property name="dataType">integer</property>
  1724. </structure>
  1725. <structure>
  1726. <property name="name">sku</property>
  1727. <text-property name="displayName">sku</text-property>
  1728. <expression name="expression" type="javascript">dataSetRow["sku"]</expression>
  1729. <property name="dataType">string</property>
  1730. </structure>
  1731. <structure>
  1732. <property name="name">descrip</property>
  1733. <text-property name="displayName">descrip</text-property>
  1734. <expression name="expression" type="javascript">dataSetRow["descrip"]</expression>
  1735. <property name="dataType">string</property>
  1736. </structure>
  1737. <structure>
  1738. <property name="name">debeu</property>
  1739. <text-property name="displayName">debeu</text-property>
  1740. <expression name="expression" type="javascript">dataSetRow["debeu"]</expression>
  1741. <property name="dataType">float</property>
  1742. </structure>
  1743. <structure>
  1744. <property name="name">haberu</property>
  1745. <text-property name="displayName">haberu</text-property>
  1746. <expression name="expression" type="javascript">dataSetRow["haberu"]</expression>
  1747. <property name="dataType">float</property>
  1748. </structure>
  1749. <structure>
  1750. <property name="name">debev</property>
  1751. <text-property name="displayName">debev</text-property>
  1752. <expression name="expression" type="javascript">dataSetRow["debev"]</expression>
  1753. <property name="dataType">float</property>
  1754. </structure>
  1755. <structure>
  1756. <property name="name">haberv</property>
  1757. <text-property name="displayName">haberv</text-property>
  1758. <expression name="expression" type="javascript">dataSetRow["haberv"]</expression>
  1759. <property name="dataType">float</property>
  1760. </structure>
  1761. <structure>
  1762. <property name="name">debec</property>
  1763. <text-property name="displayName">debec</text-property>
  1764. <expression name="expression" type="javascript">dataSetRow["debec"]</expression>
  1765. <property name="dataType">float</property>
  1766. </structure>
  1767. <structure>
  1768. <property name="name">id</property>
  1769. <text-property name="displayName">id</text-property>
  1770. <expression name="expression" type="javascript">dataSetRow["id"]</expression>
  1771. <property name="dataType">integer</property>
  1772. </structure>
  1773. <structure>
  1774. <property name="name">numero</property>
  1775. <text-property name="displayName">numero</text-property>
  1776. <expression name="expression" type="javascript">dataSetRow["numero"]</expression>
  1777. <property name="dataType">string</property>
  1778. </structure>
  1779. <structure>
  1780. <property name="name">fecha</property>
  1781. <text-property name="displayName">fecha</text-property>
  1782. <expression name="expression" type="javascript">dataSetRow["fecha"]</expression>
  1783. <property name="dataType">date-time</property>
  1784. </structure>
  1785. <structure>
  1786. <property name="name">ExistenciaUI</property>
  1787. <text-property name="displayName">ExistenciaUI</text-property>
  1788. <expression name="expression" type="javascript">dataSetRow["ExistenciaUI"]</expression>
  1789. <property name="dataType">float</property>
  1790. </structure>
  1791. <structure>
  1792. <property name="name">ExistenciaUF</property>
  1793. <text-property name="displayName">ExistenciaUF</text-property>
  1794. <expression name="expression" type="javascript">dataSetRow["ExistenciaUF"]</expression>
  1795. <property name="dataType">float</property>
  1796. </structure>
  1797. <structure>
  1798. <property name="name">ExistenciaVI</property>
  1799. <text-property name="displayName">ExistenciaVI</text-property>
  1800. <expression name="expression" type="javascript">dataSetRow["ExistenciaVI"]</expression>
  1801. <property name="dataType">float</property>
  1802. </structure>
  1803. <structure>
  1804. <property name="name">ExistenciaVF</property>
  1805. <text-property name="displayName">ExistenciaVF</text-property>
  1806. <expression name="expression" type="javascript">dataSetRow["ExistenciaVF"]</expression>
  1807. <property name="dataType">float</property>
  1808. </structure>
  1809. <structure>
  1810. <property name="name">CostoU</property>
  1811. <text-property name="displayName">CostoU</text-property>
  1812. <expression name="expression" type="javascript">if (dataSetRow["ExistenciaUI"]==0 &amp;&amp; dataSetRow["ExistenciaVI"]==0)&#13;
  1813. 0.00&#13;
  1814. else&#13;
  1815. dataSetRow["ExistenciaVI"]/dataSetRow["ExistenciaUI"]</expression>
  1816. <property name="dataType">float</property>
  1817. <property name="allowExport">true</property>
  1818. </structure>
  1819. <structure>
  1820. <property name="name">totDebeU</property>
  1821. <property name="dataType">float</property>
  1822. <property name="aggregateFunction">SUM</property>
  1823. <list-property name="arguments">
  1824. <structure>
  1825. <property name="name">Expression</property>
  1826. <expression name="value" type="javascript">row["debeu"]</expression>
  1827. </structure>
  1828. </list-property>
  1829. <property name="allowExport">true</property>
  1830. </structure>
  1831. <structure>
  1832. <property name="name">totDebeC</property>
  1833. <property name="dataType">float</property>
  1834. <property name="aggregateFunction">SUM</property>
  1835. <list-property name="arguments">
  1836. <structure>
  1837. <property name="name">Expression</property>
  1838. <expression name="value" type="javascript">row["debec"]</expression>
  1839. </structure>
  1840. </list-property>
  1841. <property name="allowExport">true</property>
  1842. </structure>
  1843. <structure>
  1844. <property name="name">totHaberU</property>
  1845. <property name="dataType">float</property>
  1846. <property name="aggregateFunction">SUM</property>
  1847. <list-property name="arguments">
  1848. <structure>
  1849. <property name="name">Expression</property>
  1850. <expression name="value" type="javascript">row["haberu"]</expression>
  1851. </structure>
  1852. </list-property>
  1853. <property name="allowExport">true</property>
  1854. </structure>
  1855. <structure>
  1856. <property name="name">totHaberV</property>
  1857. <property name="dataType">float</property>
  1858. <property name="aggregateFunction">SUM</property>
  1859. <list-property name="arguments">
  1860. <structure>
  1861. <property name="name">Expression</property>
  1862. <expression name="value" type="javascript">row["haberv"]</expression>
  1863. </structure>
  1864. </list-property>
  1865. <property name="allowExport">true</property>
  1866. </structure>
  1867. <structure>
  1868. <property name="name">totalU</property>
  1869. <expression name="expression" type="javascript">row["totDebeU"]-row["totHaberU"]</expression>
  1870. <property name="dataType">float</property>
  1871. <property name="allowExport">true</property>
  1872. </structure>
  1873. <structure>
  1874. <property name="name">totalV</property>
  1875. <expression name="expression" type="javascript">row["ExistenciaVI"]+row["totDebeC"]-row["totHaberV"]</expression>
  1876. <property name="dataType">float</property>
  1877. <property name="allowExport">true</property>
  1878. </structure>
  1879. <structure>
  1880. <property name="name">nombre</property>
  1881. <text-property name="displayName">nombre</text-property>
  1882. <expression name="expression" type="javascript">dataSetRow["nombre"]</expression>
  1883. <property name="dataType">string</property>
  1884. </structure>
  1885. <structure>
  1886. <property name="name">bodDebeU</property>
  1887. <property name="dataType">float</property>
  1888. <simple-property-list name="aggregateOn">
  1889. <value>bodega</value>
  1890. </simple-property-list>
  1891. <property name="aggregateFunction">SUM</property>
  1892. <list-property name="arguments">
  1893. <structure>
  1894. <property name="name">Expression</property>
  1895. <expression name="value" type="javascript">row["debeu"]</expression>
  1896. </structure>
  1897. </list-property>
  1898. <property name="allowExport">true</property>
  1899. </structure>
  1900. <structure>
  1901. <property name="name">bodDebeC</property>
  1902. <property name="dataType">float</property>
  1903. <simple-property-list name="aggregateOn">
  1904. <value>bodega</value>
  1905. </simple-property-list>
  1906. <property name="aggregateFunction">SUM</property>
  1907. <list-property name="arguments">
  1908. <structure>
  1909. <property name="name">Expression</property>
  1910. <expression name="value" type="javascript">row["debec"]</expression>
  1911. </structure>
  1912. </list-property>
  1913. <property name="allowExport">true</property>
  1914. </structure>
  1915. <structure>
  1916. <property name="name">bodHaberU</property>
  1917. <property name="dataType">float</property>
  1918. <simple-property-list name="aggregateOn">
  1919. <value>bodega</value>
  1920. </simple-property-list>
  1921. <property name="aggregateFunction">SUM</property>
  1922. <list-property name="arguments">
  1923. <structure>
  1924. <property name="name">Expression</property>
  1925. <expression name="value" type="javascript">row["haberu"]</expression>
  1926. </structure>
  1927. </list-property>
  1928. <property name="allowExport">true</property>
  1929. </structure>
  1930. <structure>
  1931. <property name="name">bodHaberV</property>
  1932. <property name="dataType">float</property>
  1933. <simple-property-list name="aggregateOn">
  1934. <value>bodega</value>
  1935. </simple-property-list>
  1936. <property name="aggregateFunction">SUM</property>
  1937. <list-property name="arguments">
  1938. <structure>
  1939. <property name="name">Expression</property>
  1940. <expression name="value" type="javascript">row["haberv"]</expression>
  1941. </structure>
  1942. </list-property>
  1943. <property name="allowExport">true</property>
  1944. </structure>
  1945. <structure>
  1946. <property name="name">bodU</property>
  1947. <expression name="expression" type="javascript">row["bodDebeU"]-row["bodHaberU"]</expression>
  1948. <property name="dataType">float</property>
  1949. <property name="allowExport">true</property>
  1950. </structure>
  1951. <structure>
  1952. <property name="name">bodV</property>
  1953. <expression name="expression" type="javascript">row["ExistenciaVI"]+row["bodDebeC"]-row["bodHaberV"]</expression>
  1954. <property name="dataType">float</property>
  1955. <property name="allowExport">true</property>
  1956. </structure>
  1957. <structure>
  1958. <property name="name">sucursal</property>
  1959. <text-property name="displayName">sucursal</text-property>
  1960. <expression name="expression" type="javascript">dataSetRow["sucursal"]</expression>
  1961. <property name="dataType">string</property>
  1962. </structure>
  1963. <structure>
  1964. <property name="name">valor</property>
  1965. <text-property name="displayName">valor</text-property>
  1966. <expression name="expression" type="javascript">dataSetRow["valor"]</expression>
  1967. <property name="dataType">string</property>
  1968. </structure>
  1969. <structure>
  1970. <property name="name">cod_alterno</property>
  1971. <text-property name="displayName">cod_alterno</text-property>
  1972. <expression name="expression" type="javascript">dataSetRow["cod_alterno"]</expression>
  1973. <property name="dataType">string</property>
  1974. </structure>
  1975. <structure>
  1976. <property name="name">linea</property>
  1977. <text-property name="displayName">linea</text-property>
  1978. <expression name="expression" type="javascript">dataSetRow["linea"]</expression>
  1979. <property name="dataType">string</property>
  1980. </structure>
  1981. <structure>
  1982. <property name="name">marca</property>
  1983. <text-property name="displayName">marca</text-property>
  1984. <expression name="expression" type="javascript">dataSetRow["marca"]</expression>
  1985. <property name="dataType">string</property>
  1986. </structure>
  1987. <structure>
  1988. <property name="name">sucU</property>
  1989. <property name="dataType">float</property>
  1990. <simple-property-list name="aggregateOn">
  1991. <value>sucursalGroup</value>
  1992. </simple-property-list>
  1993. <property name="aggregateFunction">SUM</property>
  1994. <list-property name="arguments">
  1995. <structure>
  1996. <property name="name">Expression</property>
  1997. <expression name="value" type="javascript">row["debeu"]</expression>
  1998. </structure>
  1999. </list-property>
  2000. <property name="allowExport">true</property>
  2001. </structure>
  2002. <structure>
  2003. <property name="name">sucD</property>
  2004. <property name="dataType">float</property>
  2005. <simple-property-list name="aggregateOn">
  2006. <value>sucursalGroup</value>
  2007. </simple-property-list>
  2008. <property name="aggregateFunction">SUM</property>
  2009. <list-property name="arguments">
  2010. <structure>
  2011. <property name="name">Expression</property>
  2012. <expression name="value" type="javascript">row["debec"]</expression>
  2013. </structure>
  2014. </list-property>
  2015. <property name="allowExport">true</property>
  2016. </structure>
  2017. <structure>
  2018. <property name="name">sucHaberU</property>
  2019. <property name="dataType">float</property>
  2020. <simple-property-list name="aggregateOn">
  2021. <value>sucursalGroup</value>
  2022. </simple-property-list>
  2023. <property name="aggregateFunction">SUM</property>
  2024. <list-property name="arguments">
  2025. <structure>
  2026. <property name="name">Expression</property>
  2027. <expression name="value" type="javascript">row["haberu"]</expression>
  2028. </structure>
  2029. </list-property>
  2030. <property name="allowExport">true</property>
  2031. </structure>
  2032. <structure>
  2033. <property name="name">sucHaberC</property>
  2034. <property name="dataType">float</property>
  2035. <simple-property-list name="aggregateOn">
  2036. <value>sucursalGroup</value>
  2037. </simple-property-list>
  2038. <property name="aggregateFunction">SUM</property>
  2039. <list-property name="arguments">
  2040. <structure>
  2041. <property name="name">Expression</property>
  2042. <expression name="value" type="javascript">row["haberv"]</expression>
  2043. </structure>
  2044. </list-property>
  2045. <property name="allowExport">true</property>
  2046. </structure>
  2047. <structure>
  2048. <property name="name">suc_u</property>
  2049. <expression name="expression" type="javascript">row["sucU"]-row["sucHaberU"]</expression>
  2050. <property name="dataType">float</property>
  2051. <property name="allowExport">true</property>
  2052. </structure>
  2053. <structure>
  2054. <property name="name">suc_c</property>
  2055. <expression name="expression" type="javascript">row["ExistenciaVI"]+row["sucD"]-row["sucHaberC"]</expression>
  2056. <property name="dataType">float</property>
  2057. <property name="allowExport">true</property>
  2058. </structure>
  2059. <structure>
  2060. <property name="name">lindebeu</property>
  2061. <property name="dataType">float</property>
  2062. <simple-property-list name="aggregateOn">
  2063. <value>linea</value>
  2064. </simple-property-list>
  2065. <property name="aggregateFunction">SUM</property>
  2066. <list-property name="arguments">
  2067. <structure>
  2068. <property name="name">Expression</property>
  2069. <expression name="value" type="javascript">row["debeu"]</expression>
  2070. </structure>
  2071. </list-property>
  2072. <property name="allowExport">true</property>
  2073. </structure>
  2074. <structure>
  2075. <property name="name">lindebev</property>
  2076. <property name="dataType">float</property>
  2077. <simple-property-list name="aggregateOn">
  2078. <value>linea</value>
  2079. </simple-property-list>
  2080. <property name="aggregateFunction">SUM</property>
  2081. <list-property name="arguments">
  2082. <structure>
  2083. <property name="name">Expression</property>
  2084. <expression name="value" type="javascript">row["debec"]</expression>
  2085. </structure>
  2086. </list-property>
  2087. <property name="allowExport">true</property>
  2088. </structure>
  2089. <structure>
  2090. <property name="name">linhaberu</property>
  2091. <property name="dataType">float</property>
  2092. <simple-property-list name="aggregateOn">
  2093. <value>linea</value>
  2094. </simple-property-list>
  2095. <property name="aggregateFunction">SUM</property>
  2096. <list-property name="arguments">
  2097. <structure>
  2098. <property name="name">Expression</property>
  2099. <expression name="value" type="javascript">row["haberu"]</expression>
  2100. </structure>
  2101. </list-property>
  2102. <property name="allowExport">true</property>
  2103. </structure>
  2104. <structure>
  2105. <property name="name">linhaberv</property>
  2106. <property name="dataType">float</property>
  2107. <simple-property-list name="aggregateOn">
  2108. <value>linea</value>
  2109. </simple-property-list>
  2110. <property name="aggregateFunction">SUM</property>
  2111. <list-property name="arguments">
  2112. <structure>
  2113. <property name="name">Expression</property>
  2114. <expression name="value" type="javascript">row["haberv"]</expression>
  2115. </structure>
  2116. </list-property>
  2117. <property name="allowExport">true</property>
  2118. </structure>
  2119. <structure>
  2120. <property name="name">lineaU</property>
  2121. <expression name="expression" type="javascript">row["lindebeu"]-row["linhaberu"]</expression>
  2122. <property name="dataType">float</property>
  2123. <property name="allowExport">true</property>
  2124. </structure>
  2125. <structure>
  2126. <property name="name">lineaV</property>
  2127. <expression name="expression" type="javascript">row["ExistenciaVI"]+row["lindebev"]-row["linhaberv"]</expression>
  2128. <property name="dataType">float</property>
  2129. <property name="allowExport">true</property>
  2130. </structure>
  2131. <structure>
  2132. <property name="name">mardebeu</property>
  2133. <property name="dataType">float</property>
  2134. <simple-property-list name="aggregateOn">
  2135. <value>marca</value>
  2136. </simple-property-list>
  2137. <property name="aggregateFunction">SUM</property>
  2138. <list-property name="arguments">
  2139. <structure>
  2140. <property name="name">Expression</property>
  2141. <expression name="value" type="javascript">row["debeu"]</expression>
  2142. </structure>
  2143. </list-property>
  2144. <property name="allowExport">true</property>
  2145. </structure>
  2146. <structure>
  2147. <property name="name">mardebev</property>
  2148. <property name="dataType">float</property>
  2149. <simple-property-list name="aggregateOn">
  2150. <value>marca</value>
  2151. </simple-property-list>
  2152. <property name="aggregateFunction">SUM</property>
  2153. <list-property name="arguments">
  2154. <structure>
  2155. <property name="name">Expression</property>
  2156. <expression name="value" type="javascript">row["debec"]</expression>
  2157. </structure>
  2158. </list-property>
  2159. <property name="allowExport">true</property>
  2160. </structure>
  2161. <structure>
  2162. <property name="name">marhaberu</property>
  2163. <property name="dataType">float</property>
  2164. <simple-property-list name="aggregateOn">
  2165. <value>marca</value>
  2166. </simple-property-list>
  2167. <property name="aggregateFunction">SUM</property>
  2168. <list-property name="arguments">
  2169. <structure>
  2170. <property name="name">Expression</property>
  2171. <expression name="value" type="javascript">row["haberu"]</expression>
  2172. </structure>
  2173. </list-property>
  2174. <property name="allowExport">true</property>
  2175. </structure>
  2176. <structure>
  2177. <property name="name">marhaberv</property>
  2178. <property name="dataType">float</property>
  2179. <simple-property-list name="aggregateOn">
  2180. <value>marca</value>
  2181. </simple-property-list>
  2182. <property name="aggregateFunction">SUM</property>
  2183. <list-property name="arguments">
  2184. <structure>
  2185. <property name="name">Expression</property>
  2186. <expression name="value" type="javascript">row["haberv"]</expression>
  2187. </structure>
  2188. </list-property>
  2189. <property name="allowExport">true</property>
  2190. </structure>
  2191. <structure>
  2192. <property name="name">marcaU</property>
  2193. <expression name="expression" type="javascript">row["mardebeu"]-row["marhaberu"]</expression>
  2194. <property name="dataType">float</property>
  2195. <property name="allowExport">true</property>
  2196. </structure>
  2197. <structure>
  2198. <property name="name">marcaV</property>
  2199. <expression name="expression" type="javascript">row["ExistenciaVI"]+row["mardebev"]-row["marhaberv"]</expression>
  2200. <property name="dataType">float</property>
  2201. <property name="allowExport">true</property>
  2202. </structure>
  2203. <structure>
  2204. <property name="name">CostoU_1</property>
  2205. <expression name="expression" type="javascript">dataSetRow["CostoU"]</expression>
  2206. <property name="dataType">float</property>
  2207. </structure>
  2208. <structure>
  2209. <property name="name">tipo_documento</property>
  2210. <expression name="expression" type="javascript">dataSetRow["tipo_documento"]</expression>
  2211. <property name="dataType">integer</property>
  2212. </structure>
  2213. <structure>
  2214. <property name="name">marcaU2</property>
  2215. <expression name="expression" type="javascript">row["mardebeu"]-row["marhaberu"]+dataSetRow["ExistenciaUI"]</expression>
  2216. <property name="dataType">float</property>
  2217. <property name="allowExport">true</property>
  2218. </structure>
  2219. <structure>
  2220. <property name="name">lineaU2</property>
  2221. <expression name="expression" type="javascript">row["lindebeu"]-row["linhaberu"]+dataSetRow["ExistenciaUI"]</expression>
  2222. <property name="dataType">float</property>
  2223. <property name="allowExport">true</property>
  2224. </structure>
  2225. <structure>
  2226. <property name="name">bodU2</property>
  2227. <expression name="expression" type="javascript">row["bodDebeU"]-row["bodHaberU"]+dataSetRow["ExistenciaUI"]</expression>
  2228. <property name="dataType">float</property>
  2229. <property name="allowExport">true</property>
  2230. </structure>
  2231. <structure>
  2232. <property name="name">suc_u2</property>
  2233. <expression name="expression" type="javascript">row["sucU"]-row["sucHaberU"]+dataSetRow["ExistenciaUI"]</expression>
  2234. <property name="dataType">float</property>
  2235. <property name="allowExport">true</property>
  2236. </structure>
  2237. <structure>
  2238. <property name="name">totalU2</property>
  2239. <expression name="expression" type="javascript">row["totDebeU"]-row["totHaberU"]+dataSetRow["ExistenciaUI"]</expression>
  2240. <property name="dataType">float</property>
  2241. <property name="allowExport">true</property>
  2242. </structure>
  2243. <structure>
  2244. <property name="name">saldoubodega</property>
  2245. <property name="dataType">float</property>
  2246. <simple-property-list name="aggregateOn">
  2247. <value>bodega</value>
  2248. </simple-property-list>
  2249. <property name="aggregateFunction">SUM</property>
  2250. <list-property name="arguments">
  2251. <structure>
  2252. <property name="name">Expression</property>
  2253. <expression name="value" type="javascript">row["ExistenciaUF"]</expression>
  2254. </structure>
  2255. </list-property>
  2256. <property name="allowExport">true</property>
  2257. </structure>
  2258. <structure>
  2259. <property name="name">saldousucursal</property>
  2260. <property name="dataType">float</property>
  2261. <simple-property-list name="aggregateOn">
  2262. <value>sucursalGroup</value>
  2263. </simple-property-list>
  2264. <property name="aggregateFunction">SUM</property>
  2265. <list-property name="arguments">
  2266. <structure>
  2267. <property name="name">Expression</property>
  2268. <expression name="value" type="javascript">row["ExistenciaUF"]</expression>
  2269. </structure>
  2270. </list-property>
  2271. <property name="allowExport">true</property>
  2272. </structure>
  2273. <structure>
  2274. <property name="name">saldoutotal</property>
  2275. <property name="dataType">float</property>
  2276. <property name="aggregateFunction">SUM</property>
  2277. <list-property name="arguments">
  2278. <structure>
  2279. <property name="name">Expression</property>
  2280. <expression name="value" type="javascript">row["ExistenciaUF"]</expression>
  2281. </structure>
  2282. </list-property>
  2283. <property name="allowExport">true</property>
  2284. </structure>
  2285. <structure>
  2286. <property name="name">saldoulinea</property>
  2287. <property name="dataType">float</property>
  2288. <simple-property-list name="aggregateOn">
  2289. <value>linea</value>
  2290. </simple-property-list>
  2291. <property name="aggregateFunction">SUM</property>
  2292. <list-property name="arguments">
  2293. <structure>
  2294. <property name="name">Expression</property>
  2295. <expression name="value" type="javascript">row["ExistenciaUF"]</expression>
  2296. </structure>
  2297. </list-property>
  2298. <property name="allowExport">true</property>
  2299. </structure>
  2300. <structure>
  2301. <property name="name">saldoumarca</property>
  2302. <property name="dataType">float</property>
  2303. <simple-property-list name="aggregateOn">
  2304. <value>marca</value>
  2305. </simple-property-list>
  2306. <property name="aggregateFunction">SUM</property>
  2307. <list-property name="arguments">
  2308. <structure>
  2309. <property name="name">Expression</property>
  2310. <expression name="value" type="javascript">row["mardebeu"]-row["marhaberu"]</expression>
  2311. </structure>
  2312. </list-property>
  2313. <property name="allowExport">true</property>
  2314. </structure>
  2315. <structure>
  2316. <property name="name">saldovmarca</property>
  2317. <property name="dataType">float</property>
  2318. <simple-property-list name="aggregateOn">
  2319. <value>marca</value>
  2320. </simple-property-list>
  2321. <property name="aggregateFunction">SUM</property>
  2322. <list-property name="arguments">
  2323. <structure>
  2324. <property name="name">Expression</property>
  2325. <expression name="value" type="javascript">row["ExistenciaVF"]</expression>
  2326. </structure>
  2327. </list-property>
  2328. <property name="allowExport">true</property>
  2329. </structure>
  2330. <structure>
  2331. <property name="name">saldovlinea</property>
  2332. <property name="dataType">float</property>
  2333. <simple-property-list name="aggregateOn">
  2334. <value>linea</value>
  2335. </simple-property-list>
  2336. <property name="aggregateFunction">SUM</property>
  2337. <list-property name="arguments">
  2338. <structure>
  2339. <property name="name">Expression</property>
  2340. <expression name="value" type="javascript">row["ExistenciaVF"]</expression>
  2341. </structure>
  2342. </list-property>
  2343. <property name="allowExport">true</property>
  2344. </structure>
  2345. <structure>
  2346. <property name="name">saldovbodega</property>
  2347. <property name="dataType">float</property>
  2348. <simple-property-list name="aggregateOn">
  2349. <value>bodega</value>
  2350. </simple-property-list>
  2351. <property name="aggregateFunction">SUM</property>
  2352. <list-property name="arguments">
  2353. <structure>
  2354. <property name="name">Expression</property>
  2355. <expression name="value" type="javascript">row["ExistenciaVF"]</expression>
  2356. </structure>
  2357. </list-property>
  2358. <property name="allowExport">true</property>
  2359. </structure>
  2360. <structure>
  2361. <property name="name">saldovsucursal</property>
  2362. <property name="dataType">float</property>
  2363. <simple-property-list name="aggregateOn">
  2364. <value>sucursalGroup</value>
  2365. </simple-property-list>
  2366. <property name="aggregateFunction">SUM</property>
  2367. <list-property name="arguments">
  2368. <structure>
  2369. <property name="name">Expression</property>
  2370. <expression name="value" type="javascript">row["ExistenciaVF"]</expression>
  2371. </structure>
  2372. </list-property>
  2373. <property name="allowExport">true</property>
  2374. </structure>
  2375. <structure>
  2376. <property name="name">saldovtotal</property>
  2377. <property name="dataType">float</property>
  2378. <property name="aggregateFunction">SUM</property>
  2379. <list-property name="arguments">
  2380. <structure>
  2381. <property name="name">Expression</property>
  2382. <expression name="value" type="javascript">row["ExistenciaVF"]</expression>
  2383. </structure>
  2384. </list-property>
  2385. <property name="allowExport">true</property>
  2386. </structure>
  2387. <structure>
  2388. <property name="name">CostoU_2</property>
  2389. <text-property name="displayName">CostoU</text-property>
  2390. <expression name="expression" type="javascript">dataSetRow["CostoU"]</expression>
  2391. <property name="dataType">decimal</property>
  2392. </structure>
  2393. <structure>
  2394. <property name="name">grupo</property>
  2395. <text-property name="displayName">grupo</text-property>
  2396. <expression name="expression" type="javascript">dataSetRow["grupo"]</expression>
  2397. <property name="dataType">string</property>
  2398. </structure>
  2399. <structure>
  2400. <property name="name">cat3</property>
  2401. <text-property name="displayName">cat3</text-property>
  2402. <expression name="expression" type="javascript">dataSetRow["cat3"]</expression>
  2403. <property name="dataType">string</property>
  2404. </structure>
  2405. <structure>
  2406. <property name="name">cat4</property>
  2407. <text-property name="displayName">cat4</text-property>
  2408. <expression name="expression" type="javascript">dataSetRow["cat4"]</expression>
  2409. <property name="dataType">string</property>
  2410. </structure>
  2411. <structure>
  2412. <property name="name">cat5</property>
  2413. <text-property name="displayName">cat5</text-property>
  2414. <expression name="expression" type="javascript">dataSetRow["cat5"]</expression>
  2415. <property name="dataType">string</property>
  2416. </structure>
  2417. <structure>
  2418. <property name="name">tipo_documento_1</property>
  2419. <text-property name="displayName">tipo_documento</text-property>
  2420. <expression name="expression" type="javascript">dataSetRow["tipo_documento"]</expression>
  2421. <property name="dataType">decimal</property>
  2422. </structure>
  2423. <structure>
  2424. <property name="name">joinid</property>
  2425. <text-property name="displayName">joinid</text-property>
  2426. <expression name="expression" type="javascript">dataSetRow["joinid"]</expression>
  2427. <property name="dataType">string</property>
  2428. </structure>
  2429. <structure>
  2430. <property name="name">sumcat3debeu</property>
  2431. <property name="dataType">float</property>
  2432. <simple-property-list name="aggregateOn">
  2433. <value>categoria3</value>
  2434. </simple-property-list>
  2435. <property name="aggregateFunction">SUM</property>
  2436. <list-property name="arguments">
  2437. <structure>
  2438. <property name="name">Expression</property>
  2439. <expression name="value" type="javascript">row["debeu"]</expression>
  2440. </structure>
  2441. </list-property>
  2442. <property name="allowExport">true</property>
  2443. </structure>
  2444. <structure>
  2445. <property name="name">sumcat4debeu</property>
  2446. <property name="dataType">float</property>
  2447. <simple-property-list name="aggregateOn">
  2448. <value>categoria4</value>
  2449. </simple-property-list>
  2450. <property name="aggregateFunction">SUM</property>
  2451. <list-property name="arguments">
  2452. <structure>
  2453. <property name="name">Expression</property>
  2454. <expression name="value" type="javascript">row["debeu"]</expression>
  2455. </structure>
  2456. </list-property>
  2457. <property name="allowExport">true</property>
  2458. </structure>
  2459. <structure>
  2460. <property name="name">sumcat5debeu</property>
  2461. <property name="dataType">float</property>
  2462. <simple-property-list name="aggregateOn">
  2463. <value>categoria5</value>
  2464. </simple-property-list>
  2465. <property name="aggregateFunction">SUM</property>
  2466. <list-property name="arguments">
  2467. <structure>
  2468. <property name="name">Expression</property>
  2469. <expression name="value" type="javascript">row["debeu"]</expression>
  2470. </structure>
  2471. </list-property>
  2472. <property name="allowExport">true</property>
  2473. </structure>
  2474. <structure>
  2475. <property name="name">sumcate3debec</property>
  2476. <property name="dataType">float</property>
  2477. <simple-property-list name="aggregateOn">
  2478. <value>categoria3</value>
  2479. </simple-property-list>
  2480. <property name="aggregateFunction">SUM</property>
  2481. <list-property name="arguments">
  2482. <structure>
  2483. <property name="name">Expression</property>
  2484. <expression name="value" type="javascript">row["debec"]</expression>
  2485. </structure>
  2486. </list-property>
  2487. <property name="allowExport">true</property>
  2488. </structure>
  2489. <structure>
  2490. <property name="name">sumcat4debec</property>
  2491. <property name="dataType">float</property>
  2492. <simple-property-list name="aggregateOn">
  2493. <value>categoria4</value>
  2494. </simple-property-list>
  2495. <property name="aggregateFunction">SUM</property>
  2496. <list-property name="arguments">
  2497. <structure>
  2498. <property name="name">Expression</property>
  2499. <expression name="value" type="javascript">row["debec"]</expression>
  2500. </structure>
  2501. </list-property>
  2502. <property name="allowExport">true</property>
  2503. </structure>
  2504. <structure>
  2505. <property name="name">sumcat5debec</property>
  2506. <property name="dataType">float</property>
  2507. <simple-property-list name="aggregateOn">
  2508. <value>categoria5</value>
  2509. </simple-property-list>
  2510. <property name="aggregateFunction">SUM</property>
  2511. <list-property name="arguments">
  2512. <structure>
  2513. <property name="name">Expression</property>
  2514. <expression name="value" type="javascript">row["debec"]</expression>
  2515. </structure>
  2516. </list-property>
  2517. <property name="allowExport">true</property>
  2518. </structure>
  2519. <structure>
  2520. <property name="name">sumcat3haberu</property>
  2521. <property name="dataType">float</property>
  2522. <simple-property-list name="aggregateOn">
  2523. <value>categoria3</value>
  2524. </simple-property-list>
  2525. <property name="aggregateFunction">SUM</property>
  2526. <list-property name="arguments">
  2527. <structure>
  2528. <property name="name">Expression</property>
  2529. <expression name="value" type="javascript">row["haberu"]</expression>
  2530. </structure>
  2531. </list-property>
  2532. <property name="allowExport">true</property>
  2533. </structure>
  2534. <structure>
  2535. <property name="name">sumcat4haberu</property>
  2536. <property name="dataType">float</property>
  2537. <simple-property-list name="aggregateOn">
  2538. <value>categoria4</value>
  2539. </simple-property-list>
  2540. <property name="aggregateFunction">SUM</property>
  2541. <list-property name="arguments">
  2542. <structure>
  2543. <property name="name">Expression</property>
  2544. <expression name="value" type="javascript">row["haberu"]</expression>
  2545. </structure>
  2546. </list-property>
  2547. <property name="allowExport">true</property>
  2548. </structure>
  2549. <structure>
  2550. <property name="name">sumcat5haberu</property>
  2551. <property name="dataType">float</property>
  2552. <simple-property-list name="aggregateOn">
  2553. <value>categoria5</value>
  2554. </simple-property-list>
  2555. <property name="aggregateFunction">SUM</property>
  2556. <list-property name="arguments">
  2557. <structure>
  2558. <property name="name">Expression</property>
  2559. <expression name="value" type="javascript">row["haberu"]</expression>
  2560. </structure>
  2561. </list-property>
  2562. <property name="allowExport">true</property>
  2563. </structure>
  2564. <structure>
  2565. <property name="name">sumcat3haberv</property>
  2566. <property name="dataType">float</property>
  2567. <simple-property-list name="aggregateOn">
  2568. <value>categoria3</value>
  2569. </simple-property-list>
  2570. <property name="aggregateFunction">SUM</property>
  2571. <list-property name="arguments">
  2572. <structure>
  2573. <property name="name">Expression</property>
  2574. <expression name="value" type="javascript">row["haberv"]</expression>
  2575. </structure>
  2576. </list-property>
  2577. <property name="allowExport">true</property>
  2578. </structure>
  2579. <structure>
  2580. <property name="name">sumcat4haberv</property>
  2581. <property name="dataType">float</property>
  2582. <simple-property-list name="aggregateOn">
  2583. <value>categoria4</value>
  2584. </simple-property-list>
  2585. <property name="aggregateFunction">SUM</property>
  2586. <list-property name="arguments">
  2587. <structure>
  2588. <property name="name">Expression</property>
  2589. <expression name="value" type="javascript">row["haberv"]</expression>
  2590. </structure>
  2591. </list-property>
  2592. <property name="allowExport">true</property>
  2593. </structure>
  2594. <structure>
  2595. <property name="name">sumcat5haberv</property>
  2596. <property name="dataType">float</property>
  2597. <simple-property-list name="aggregateOn">
  2598. <value>categoria5</value>
  2599. </simple-property-list>
  2600. <property name="aggregateFunction">SUM</property>
  2601. <list-property name="arguments">
  2602. <structure>
  2603. <property name="name">Expression</property>
  2604. <expression name="value" type="javascript">row["haberv"]</expression>
  2605. </structure>
  2606. </list-property>
  2607. <property name="allowExport">true</property>
  2608. </structure>
  2609. <structure>
  2610. <property name="name">id_14</property>
  2611. <text-property name="displayName">id_14</text-property>
  2612. <expression name="expression" type="javascript">dataSetRow["id_14"]</expression>
  2613. <property name="dataType">decimal</property>
  2614. </structure>
  2615. <structure>
  2616. <property name="name">nomfac</property>
  2617. <text-property name="displayName">nomfac</text-property>
  2618. <expression name="expression" type="javascript">dataSetRow["nomfac"]</expression>
  2619. <property name="dataType">string</property>
  2620. </structure>
  2621. <structure>
  2622. <property name="name">sumproductou</property>
  2623. <property name="dataType">float</property>
  2624. <simple-property-list name="aggregateOn">
  2625. <value>producto</value>
  2626. </simple-property-list>
  2627. <property name="aggregateFunction">SUM</property>
  2628. <list-property name="arguments">
  2629. <structure>
  2630. <property name="name">Expression</property>
  2631. <expression name="value" type="javascript">row["debeu"]</expression>
  2632. </structure>
  2633. </list-property>
  2634. <property name="allowExport">true</property>
  2635. </structure>
  2636. <structure>
  2637. <property name="name">sumproductodebec</property>
  2638. <text-property name="displayName">sumproductodebec</text-property>
  2639. <property name="dataType">float</property>
  2640. <simple-property-list name="aggregateOn">
  2641. <value>producto</value>
  2642. </simple-property-list>
  2643. <property name="aggregateFunction">SUM</property>
  2644. <list-property name="arguments">
  2645. <structure>
  2646. <property name="name">Expression</property>
  2647. <expression name="value" type="javascript">row["debec"]</expression>
  2648. </structure>
  2649. </list-property>
  2650. <property name="allowExport">true</property>
  2651. </structure>
  2652. <structure>
  2653. <property name="name">sumproductohaberu</property>
  2654. <property name="dataType">float</property>
  2655. <simple-property-list name="aggregateOn">
  2656. <value>producto</value>
  2657. </simple-property-list>
  2658. <property name="aggregateFunction">SUM</property>
  2659. <list-property name="arguments">
  2660. <structure>
  2661. <property name="name">Expression</property>
  2662. <expression name="value" type="javascript">row["haberu"]</expression>
  2663. </structure>
  2664. </list-property>
  2665. <property name="allowExport">true</property>
  2666. </structure>
  2667. <structure>
  2668. <property name="name">sumproductohaberv</property>
  2669. <property name="dataType">float</property>
  2670. <simple-property-list name="aggregateOn">
  2671. <value>producto</value>
  2672. </simple-property-list>
  2673. <property name="aggregateFunction">SUM</property>
  2674. <list-property name="arguments">
  2675. <structure>
  2676. <property name="name">Expression</property>
  2677. <expression name="value" type="javascript">row["haberv"]</expression>
  2678. </structure>
  2679. </list-property>
  2680. <property name="allowExport">true</property>
  2681. </structure>
  2682. <structure>
  2683. <property name="name">saldou</property>
  2684. <text-property name="displayName">saldou</text-property>
  2685. <expression name="expression" type="javascript">dataSetRow["saldou"]</expression>
  2686. <property name="dataType">decimal</property>
  2687. </structure>
  2688. <structure>
  2689. <property name="name">saldov</property>
  2690. <text-property name="displayName">saldov</text-property>
  2691. <expression name="expression" type="javascript">dataSetRow["saldov"]</expression>
  2692. <property name="dataType">decimal</property>
  2693. </structure>
  2694. <structure>
  2695. <property name="name">costoprom</property>
  2696. <text-property name="displayName">costoprom</text-property>
  2697. <expression name="expression" type="javascript">dataSetRow["costoprom"]</expression>
  2698. <property name="dataType">decimal</property>
  2699. </structure>
  2700. </list-property>
  2701. <property name="pageBreakInterval">50</property>
  2702. <column id="20">
  2703. <property name="width">1.2291666666666667in</property>
  2704. </column>
  2705. <column id="21">
  2706. <property name="width">0.9791666666666666in</property>
  2707. </column>
  2708. <column id="22">
  2709. <property name="width">0.9479166666666666in</property>
  2710. </column>
  2711. <column id="23">
  2712. <property name="width">1.0416666666666667in</property>
  2713. </column>
  2714. <column id="92">
  2715. <property name="width">1.0416666666666667in</property>
  2716. </column>
  2717. <column id="108">
  2718. <property name="width">1.1354166666666667in</property>
  2719. </column>
  2720. <column id="102">
  2721. <property name="width">1.0625in</property>
  2722. </column>
  2723. <column id="307">
  2724. <property name="width">1.1979166666666667in</property>
  2725. </column>
  2726. <column id="297">
  2727. <property name="width">1.1041666666666667in</property>
  2728. </column>
  2729. <column id="283">
  2730. <property name="width">1in</property>
  2731. <list-property name="visibility">
  2732. <structure>
  2733. <property name="format">all</property>
  2734. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  2735. fl[12]==0</expression>
  2736. </structure>
  2737. </list-property>
  2738. </column>
  2739. <column id="10806">
  2740. <property name="width">3.0104166666666665in</property>
  2741. </column>
  2742. <header>
  2743. <row id="315">
  2744. <property name="height">0.19791666666666666in</property>
  2745. <cell id="316"/>
  2746. <cell id="317"/>
  2747. <cell id="318"/>
  2748. <cell id="319">
  2749. <property name="colSpan">2</property>
  2750. <property name="rowSpan">1</property>
  2751. <property name="borderBottomColor">#000000</property>
  2752. <property name="borderBottomStyle">solid</property>
  2753. <property name="borderBottomWidth">thin</property>
  2754. <property name="borderLeftColor">#000000</property>
  2755. <property name="borderLeftStyle">solid</property>
  2756. <property name="borderLeftWidth">thin</property>
  2757. <property name="borderTopColor">#000000</property>
  2758. <property name="borderTopStyle">solid</property>
  2759. <property name="borderTopWidth">thin</property>
  2760. <label id="326">
  2761. <property name="textAlign">center</property>
  2762. <text-property name="text">ENTRADAS</text-property>
  2763. </label>
  2764. </cell>
  2765. <cell id="321">
  2766. <property name="colSpan">2</property>
  2767. <property name="rowSpan">1</property>
  2768. <property name="borderBottomColor">#000000</property>
  2769. <property name="borderBottomStyle">solid</property>
  2770. <property name="borderBottomWidth">thin</property>
  2771. <property name="borderLeftColor">#000000</property>
  2772. <property name="borderLeftStyle">solid</property>
  2773. <property name="borderLeftWidth">thin</property>
  2774. <property name="borderTopColor">#000000</property>
  2775. <property name="borderTopStyle">solid</property>
  2776. <property name="borderTopWidth">thin</property>
  2777. <label id="327">
  2778. <property name="textAlign">center</property>
  2779. <text-property name="text">SALIDAS</text-property>
  2780. </label>
  2781. </cell>
  2782. <cell id="323">
  2783. <property name="colSpan">2</property>
  2784. <property name="rowSpan">1</property>
  2785. <property name="borderBottomColor">#000000</property>
  2786. <property name="borderBottomStyle">solid</property>
  2787. <property name="borderBottomWidth">thin</property>
  2788. <property name="borderLeftColor">#000000</property>
  2789. <property name="borderLeftStyle">solid</property>
  2790. <property name="borderLeftWidth">thin</property>
  2791. <property name="borderRightColor">#000000</property>
  2792. <property name="borderRightStyle">solid</property>
  2793. <property name="borderRightWidth">thin</property>
  2794. <property name="borderTopColor">#000000</property>
  2795. <property name="borderTopStyle">solid</property>
  2796. <property name="borderTopWidth">thin</property>
  2797. <label id="328">
  2798. <property name="textAlign">center</property>
  2799. <text-property name="text">SALDOS</text-property>
  2800. </label>
  2801. </cell>
  2802. <cell id="325">
  2803. <property name="borderBottomColor">#000000</property>
  2804. <property name="borderBottomStyle">solid</property>
  2805. <property name="borderBottomWidth">thin</property>
  2806. </cell>
  2807. <cell id="10784">
  2808. <property name="borderBottomColor">#000000</property>
  2809. <property name="borderBottomStyle">solid</property>
  2810. <property name="borderBottomWidth">thin</property>
  2811. </cell>
  2812. </row>
  2813. <row id="5">
  2814. <property name="height">0.19791666666666666in</property>
  2815. <cell id="6">
  2816. <property name="borderBottomColor">#000000</property>
  2817. <property name="borderBottomStyle">solid</property>
  2818. <property name="borderBottomWidth">thin</property>
  2819. <property name="borderLeftColor">#000000</property>
  2820. <property name="borderLeftStyle">solid</property>
  2821. <property name="borderLeftWidth">thin</property>
  2822. <property name="borderRightColor">#000000</property>
  2823. <property name="borderRightStyle">solid</property>
  2824. <property name="borderRightWidth">thin</property>
  2825. <property name="borderTopColor">#000000</property>
  2826. <property name="borderTopStyle">solid</property>
  2827. <property name="borderTopWidth">thin</property>
  2828. <label id="82">
  2829. <text-property name="text">Fecha</text-property>
  2830. </label>
  2831. </cell>
  2832. <cell id="7">
  2833. <property name="borderBottomColor">#000000</property>
  2834. <property name="borderBottomStyle">solid</property>
  2835. <property name="borderBottomWidth">thin</property>
  2836. <property name="borderLeftColor">#000000</property>
  2837. <property name="borderLeftStyle">solid</property>
  2838. <property name="borderLeftWidth">thin</property>
  2839. <property name="borderRightColor">#000000</property>
  2840. <property name="borderRightStyle">solid</property>
  2841. <property name="borderRightWidth">thin</property>
  2842. <property name="borderTopColor">#000000</property>
  2843. <property name="borderTopStyle">solid</property>
  2844. <property name="borderTopWidth">thin</property>
  2845. <label id="114">
  2846. <text-property name="text">Documento</text-property>
  2847. </label>
  2848. </cell>
  2849. <cell id="8">
  2850. <property name="borderBottomColor">#000000</property>
  2851. <property name="borderBottomStyle">solid</property>
  2852. <property name="borderBottomWidth">thin</property>
  2853. <property name="borderLeftColor">#000000</property>
  2854. <property name="borderLeftStyle">solid</property>
  2855. <property name="borderLeftWidth">thin</property>
  2856. <property name="borderRightColor">#000000</property>
  2857. <property name="borderRightStyle">solid</property>
  2858. <property name="borderRightWidth">thin</property>
  2859. <property name="borderTopColor">#000000</property>
  2860. <property name="borderTopStyle">solid</property>
  2861. <property name="borderTopWidth">thin</property>
  2862. <label id="84">
  2863. <property name="textAlign">center</property>
  2864. <text-property name="text">Numero</text-property>
  2865. </label>
  2866. </cell>
  2867. <cell id="9">
  2868. <property name="borderBottomColor">#000000</property>
  2869. <property name="borderBottomStyle">solid</property>
  2870. <property name="borderBottomWidth">thin</property>
  2871. <property name="borderLeftColor">#000000</property>
  2872. <property name="borderLeftStyle">solid</property>
  2873. <property name="borderLeftWidth">thin</property>
  2874. <label id="93">
  2875. <property name="textAlign">center</property>
  2876. <text-property name="text">Unidades</text-property>
  2877. </label>
  2878. </cell>
  2879. <cell id="87">
  2880. <property name="borderBottomColor">#000000</property>
  2881. <property name="borderBottomStyle">solid</property>
  2882. <property name="borderBottomWidth">thin</property>
  2883. <property name="borderLeftColor">#000000</property>
  2884. <property name="borderLeftStyle">solid</property>
  2885. <property name="borderLeftWidth">thin</property>
  2886. <label id="95">
  2887. <property name="textAlign">center</property>
  2888. <list-property name="visibility">
  2889. <structure>
  2890. <property name="format">all</property>
  2891. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  2892. fl[12]==0</expression>
  2893. </structure>
  2894. </list-property>
  2895. <text-property name="text">Valores</text-property>
  2896. </label>
  2897. </cell>
  2898. <cell id="103">
  2899. <property name="borderBottomColor">#000000</property>
  2900. <property name="borderBottomStyle">solid</property>
  2901. <property name="borderBottomWidth">thin</property>
  2902. <property name="borderLeftColor">#000000</property>
  2903. <property name="borderLeftStyle">solid</property>
  2904. <property name="borderLeftWidth">thin</property>
  2905. <label id="110">
  2906. <property name="textAlign">center</property>
  2907. <text-property name="text">Unidades</text-property>
  2908. </label>
  2909. </cell>
  2910. <cell id="97">
  2911. <property name="borderBottomColor">#000000</property>
  2912. <property name="borderBottomStyle">solid</property>
  2913. <property name="borderBottomWidth">thin</property>
  2914. <property name="borderLeftColor">#000000</property>
  2915. <property name="borderLeftStyle">solid</property>
  2916. <property name="borderLeftWidth">thin</property>
  2917. <label id="112">
  2918. <property name="textAlign">center</property>
  2919. <list-property name="visibility">
  2920. <structure>
  2921. <property name="format">all</property>
  2922. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  2923. fl[12]==0</expression>
  2924. </structure>
  2925. </list-property>
  2926. <text-property name="text">Valores</text-property>
  2927. </label>
  2928. </cell>
  2929. <cell id="300">
  2930. <property name="borderBottomColor">#000000</property>
  2931. <property name="borderBottomStyle">solid</property>
  2932. <property name="borderBottomWidth">thin</property>
  2933. <property name="borderLeftColor">#000000</property>
  2934. <property name="borderLeftStyle">solid</property>
  2935. <property name="borderLeftWidth">thin</property>
  2936. <label id="308">
  2937. <property name="textAlign">center</property>
  2938. <text-property name="text">Unidades</text-property>
  2939. </label>
  2940. </cell>
  2941. <cell id="290">
  2942. <property name="borderBottomColor">#000000</property>
  2943. <property name="borderBottomStyle">solid</property>
  2944. <property name="borderBottomWidth">thin</property>
  2945. <property name="borderLeftColor">#000000</property>
  2946. <property name="borderLeftStyle">solid</property>
  2947. <property name="borderLeftWidth">thin</property>
  2948. <property name="borderRightColor">#000000</property>
  2949. <property name="borderRightStyle">solid</property>
  2950. <property name="borderRightWidth">thin</property>
  2951. <label id="309">
  2952. <property name="textAlign">center</property>
  2953. <list-property name="visibility">
  2954. <structure>
  2955. <property name="format">all</property>
  2956. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  2957. fl[12]==0</expression>
  2958. </structure>
  2959. </list-property>
  2960. <text-property name="text">Saldo V.</text-property>
  2961. </label>
  2962. </cell>
  2963. <cell id="276">
  2964. <property name="borderBottomColor">#000000</property>
  2965. <property name="borderBottomStyle">solid</property>
  2966. <property name="borderBottomWidth">thin</property>
  2967. <property name="borderLeftColor">#000000</property>
  2968. <property name="borderLeftStyle">solid</property>
  2969. <property name="borderLeftWidth">thin</property>
  2970. <property name="borderRightColor">#000000</property>
  2971. <property name="borderRightStyle">solid</property>
  2972. <property name="borderRightWidth">thin</property>
  2973. <property name="borderTopColor">#000000</property>
  2974. <property name="borderTopStyle">solid</property>
  2975. <property name="borderTopWidth">thin</property>
  2976. <label id="284">
  2977. <property name="textAlign">center</property>
  2978. <list-property name="visibility">
  2979. <structure>
  2980. <property name="format">all</property>
  2981. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  2982. fl[12]==0</expression>
  2983. </structure>
  2984. </list-property>
  2985. <text-property name="text">Costo P.</text-property>
  2986. </label>
  2987. </cell>
  2988. <cell id="10785">
  2989. <property name="borderBottomColor">#000000</property>
  2990. <property name="borderBottomStyle">solid</property>
  2991. <property name="borderBottomWidth">thin</property>
  2992. <property name="borderLeftColor">#000000</property>
  2993. <property name="borderLeftStyle">solid</property>
  2994. <property name="borderLeftWidth">thin</property>
  2995. <property name="borderRightColor">#000000</property>
  2996. <property name="borderRightStyle">solid</property>
  2997. <property name="borderRightWidth">thin</property>
  2998. <property name="borderTopColor">#000000</property>
  2999. <property name="borderTopStyle">solid</property>
  3000. <property name="borderTopWidth">thin</property>
  3001. </cell>
  3002. </row>
  3003. </header>
  3004. <group id="482">
  3005. <property name="groupName">sucursalGroup</property>
  3006. <expression name="keyExpr" type="javascript">row["sucursal"]</expression>
  3007. <structure name="toc">
  3008. <expression name="expressionValue" type="javascript">row["sucursal"]</expression>
  3009. </structure>
  3010. <property name="repeatHeader">false</property>
  3011. <property name="hideDetail">false</property>
  3012. <header>
  3013. <row id="483">
  3014. <list-property name="visibility">
  3015. <structure>
  3016. <property name="format">all</property>
  3017. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3018. fl[15]==1</expression>
  3019. </structure>
  3020. </list-property>
  3021. <cell id="485">
  3022. <property name="colSpan">10</property>
  3023. <property name="rowSpan">1</property>
  3024. <grid id="508">
  3025. <property name="width">10.375in</property>
  3026. <column id="509">
  3027. <property name="width">1in</property>
  3028. </column>
  3029. <column id="510">
  3030. <property name="width">9.375in</property>
  3031. </column>
  3032. <row id="511">
  3033. <cell id="512">
  3034. <property name="colSpan">2</property>
  3035. <property name="rowSpan">1</property>
  3036. <label id="257">
  3037. <property name="fontSize">10pt</property>
  3038. <property name="fontWeight">normal</property>
  3039. <property name="display">inline</property>
  3040. <text-property name="text">Sucursal</text-property>
  3041. </label>
  3042. <data id="507">
  3043. <property name="fontWeight">normal</property>
  3044. <property name="display">inline</property>
  3045. <method name="onCreate"><![CDATA[saldoUs = 0;
  3046. saldoVs = 0;]]></method>
  3047. <property name="resultSetColumn">sucursal</property>
  3048. </data>
  3049. </cell>
  3050. </row>
  3051. </grid>
  3052. </cell>
  3053. <cell id="10786"/>
  3054. </row>
  3055. </header>
  3056. <footer>
  3057. <row id="495">
  3058. <cell id="497">
  3059. <property name="colSpan">3</property>
  3060. <property name="rowSpan">1</property>
  3061. <property name="textAlign">right</property>
  3062. <label id="781">
  3063. <property name="fontWeight">bold</property>
  3064. <property name="textAlign">right</property>
  3065. <property name="display">inline</property>
  3066. <text-property name="text">Total Sucursal:</text-property>
  3067. </label>
  3068. <data id="782">
  3069. <property name="display">inline</property>
  3070. <property name="resultSetColumn">sucursal</property>
  3071. </data>
  3072. </cell>
  3073. <cell id="500">
  3074. <property name="fontWeight">bold</property>
  3075. <data id="784">
  3076. <structure name="numberFormat">
  3077. <property name="category">Fixed</property>
  3078. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3079. <property name="locale">es_GT</property>
  3080. </structure>
  3081. <property name="textAlign">right</property>
  3082. <property name="resultSetColumn">sucU</property>
  3083. </data>
  3084. </cell>
  3085. <cell id="501">
  3086. <data id="785">
  3087. <property name="fontWeight">bold</property>
  3088. <structure name="numberFormat">
  3089. <property name="category">Fixed</property>
  3090. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3091. <property name="locale">es_GT</property>
  3092. </structure>
  3093. <property name="textAlign">right</property>
  3094. <list-property name="visibility">
  3095. <structure>
  3096. <property name="format">all</property>
  3097. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3098. fl[12]==0</expression>
  3099. </structure>
  3100. </list-property>
  3101. <property name="resultSetColumn">sucD</property>
  3102. </data>
  3103. </cell>
  3104. <cell id="502">
  3105. <data id="787">
  3106. <property name="fontWeight">bold</property>
  3107. <structure name="numberFormat">
  3108. <property name="category">Fixed</property>
  3109. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3110. <property name="locale">es_GT</property>
  3111. </structure>
  3112. <property name="textAlign">right</property>
  3113. <property name="resultSetColumn">sucHaberU</property>
  3114. </data>
  3115. </cell>
  3116. <cell id="503">
  3117. <data id="788">
  3118. <property name="fontWeight">bold</property>
  3119. <structure name="numberFormat">
  3120. <property name="category">Fixed</property>
  3121. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3122. <property name="locale">es_GT</property>
  3123. </structure>
  3124. <property name="textAlign">right</property>
  3125. <list-property name="visibility">
  3126. <structure>
  3127. <property name="format">all</property>
  3128. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3129. fl[12]==0</expression>
  3130. </structure>
  3131. </list-property>
  3132. <property name="resultSetColumn">sucHaberC</property>
  3133. </data>
  3134. </cell>
  3135. <cell id="504">
  3136. <text-data id="10655">
  3137. <property name="fontWeight">bold</property>
  3138. <property name="textAlign">right</property>
  3139. <structure name="toc"/>
  3140. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3141. df.format(saldoUs);</expression>
  3142. <property name="contentType">html</property>
  3143. </text-data>
  3144. </cell>
  3145. <cell id="505">
  3146. <text-data id="10656">
  3147. <property name="fontWeight">bold</property>
  3148. <property name="textAlign">right</property>
  3149. <structure name="toc"/>
  3150. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3151. df.format(saldoVs);</expression>
  3152. <property name="contentType">html</property>
  3153. </text-data>
  3154. </cell>
  3155. <cell id="506"/>
  3156. <cell id="10804"/>
  3157. </row>
  3158. </footer>
  3159. </group>
  3160. <group id="432">
  3161. <property name="groupName">bodega</property>
  3162. <expression name="keyExpr" type="javascript">row["id"]</expression>
  3163. <structure name="toc">
  3164. <expression name="expressionValue" type="javascript">row["id"]</expression>
  3165. </structure>
  3166. <property name="repeatHeader">false</property>
  3167. <property name="hideDetail">false</property>
  3168. <header>
  3169. <row id="433">
  3170. <list-property name="visibility">
  3171. <structure>
  3172. <property name="format">all</property>
  3173. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3174. fl[15]==1</expression>
  3175. </structure>
  3176. </list-property>
  3177. <cell id="434">
  3178. <property name="colSpan">8</property>
  3179. <property name="rowSpan">1</property>
  3180. <label id="206">
  3181. <property name="fontWeight">normal</property>
  3182. <property name="display">inline</property>
  3183. <text-property name="text">Bodega</text-property>
  3184. </label>
  3185. <data id="552">
  3186. <property name="fontWeight">normal</property>
  3187. <property name="display">inline</property>
  3188. <method name="onCreate"><![CDATA[saldoUb=0;
  3189. saldoVb = 0;]]></method>
  3190. <property name="resultSetColumn">nombre</property>
  3191. </data>
  3192. </cell>
  3193. <cell id="442"/>
  3194. <cell id="443"/>
  3195. <cell id="10787"/>
  3196. </row>
  3197. </header>
  3198. <footer>
  3199. <row id="444">
  3200. <cell id="445">
  3201. <property name="colSpan">3</property>
  3202. <property name="rowSpan">1</property>
  3203. <property name="textAlign">right</property>
  3204. <label id="456">
  3205. <property name="fontWeight">bold</property>
  3206. <property name="textAlign">right</property>
  3207. <property name="display">inline</property>
  3208. <text-property name="text">Totales Bodega:</text-property>
  3209. </label>
  3210. <data id="455">
  3211. <property name="fontWeight">normal</property>
  3212. <property name="display">inline</property>
  3213. <property name="resultSetColumn">nombre</property>
  3214. </data>
  3215. </cell>
  3216. <cell id="448">
  3217. <data id="457">
  3218. <property name="fontWeight">bold</property>
  3219. <structure name="numberFormat">
  3220. <property name="category">Fixed</property>
  3221. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3222. <property name="locale">es_GT</property>
  3223. </structure>
  3224. <property name="textAlign">right</property>
  3225. <property name="resultSetColumn">bodDebeU</property>
  3226. </data>
  3227. </cell>
  3228. <cell id="449">
  3229. <data id="458">
  3230. <property name="fontWeight">bold</property>
  3231. <structure name="numberFormat">
  3232. <property name="category">Fixed</property>
  3233. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3234. <property name="locale">es_GT</property>
  3235. </structure>
  3236. <property name="textAlign">right</property>
  3237. <list-property name="visibility">
  3238. <structure>
  3239. <property name="format">all</property>
  3240. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3241. fl[12]==0</expression>
  3242. </structure>
  3243. </list-property>
  3244. <property name="resultSetColumn">bodDebeC</property>
  3245. </data>
  3246. </cell>
  3247. <cell id="450">
  3248. <data id="459">
  3249. <property name="fontWeight">bold</property>
  3250. <structure name="numberFormat">
  3251. <property name="category">Fixed</property>
  3252. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3253. <property name="locale">es_GT</property>
  3254. </structure>
  3255. <property name="textAlign">right</property>
  3256. <property name="resultSetColumn">bodHaberU</property>
  3257. </data>
  3258. </cell>
  3259. <cell id="451">
  3260. <data id="460">
  3261. <property name="fontWeight">bold</property>
  3262. <structure name="numberFormat">
  3263. <property name="category">Fixed</property>
  3264. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3265. <property name="locale">es_GT</property>
  3266. </structure>
  3267. <property name="textAlign">right</property>
  3268. <list-property name="visibility">
  3269. <structure>
  3270. <property name="format">all</property>
  3271. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3272. fl[12]==0</expression>
  3273. </structure>
  3274. </list-property>
  3275. <property name="resultSetColumn">bodHaberV</property>
  3276. </data>
  3277. </cell>
  3278. <cell id="452">
  3279. <text-data id="10653">
  3280. <property name="fontWeight">bold</property>
  3281. <property name="textAlign">right</property>
  3282. <structure name="toc"/>
  3283. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3284. df.format(saldoUb);</expression>
  3285. <property name="contentType">html</property>
  3286. </text-data>
  3287. </cell>
  3288. <cell id="453">
  3289. <text-data id="10654">
  3290. <property name="fontWeight">bold</property>
  3291. <property name="textAlign">right</property>
  3292. <structure name="toc"/>
  3293. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3294. df.format(saldoVb);</expression>
  3295. <property name="contentType">html</property>
  3296. </text-data>
  3297. </cell>
  3298. <cell id="454"/>
  3299. <cell id="10803"/>
  3300. </row>
  3301. </footer>
  3302. </group>
  3303. <group id="639">
  3304. <property name="groupName">linea</property>
  3305. <expression name="keyExpr" type="javascript">row["linea"]</expression>
  3306. <structure name="toc">
  3307. <expression name="expressionValue" type="javascript">row["linea"]</expression>
  3308. </structure>
  3309. <property name="repeatHeader">false</property>
  3310. <property name="hideDetail">false</property>
  3311. <header>
  3312. <row id="640">
  3313. <list-property name="visibility">
  3314. <structure>
  3315. <property name="format">all</property>
  3316. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3317. fl[15]==1</expression>
  3318. </structure>
  3319. </list-property>
  3320. <cell id="643">
  3321. <property name="colSpan">10</property>
  3322. <property name="rowSpan">1</property>
  3323. <property name="paddingLeft">45pt</property>
  3324. <label id="667">
  3325. <property name="fontWeight">normal</property>
  3326. <property name="display">inline</property>
  3327. <text-property name="text">Categoria</text-property>
  3328. </label>
  3329. <data id="666">
  3330. <property name="display">inline</property>
  3331. <method name="onCreate"><![CDATA[saldoUl=0;
  3332. saldoVl = 0;]]></method>
  3333. <property name="resultSetColumn">linea</property>
  3334. </data>
  3335. </cell>
  3336. <cell id="10788">
  3337. <property name="paddingLeft">45pt</property>
  3338. </cell>
  3339. </row>
  3340. </header>
  3341. <footer>
  3342. <row id="653">
  3343. <cell id="656">
  3344. <property name="colSpan">3</property>
  3345. <property name="rowSpan">1</property>
  3346. <property name="paddingLeft">45pt</property>
  3347. <property name="textAlign">left</property>
  3348. <label id="10783">
  3349. <property name="fontWeight">bold</property>
  3350. <property name="display">inline</property>
  3351. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3352. this.getStyle().display = "none";]]></method>
  3353. <text-property name="text">Total</text-property>
  3354. </label>
  3355. <data id="793">
  3356. <property name="fontWeight">bold</property>
  3357. <property name="textAlign">right</property>
  3358. <property name="display">inline</property>
  3359. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3360. this.getStyle().display = "none";]]></method>
  3361. <property name="resultSetColumn">linea</property>
  3362. </data>
  3363. </cell>
  3364. <cell id="659">
  3365. <data id="796">
  3366. <property name="fontWeight">bold</property>
  3367. <structure name="numberFormat">
  3368. <property name="category">Fixed</property>
  3369. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3370. <property name="locale">es_GT</property>
  3371. </structure>
  3372. <property name="textAlign">right</property>
  3373. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3374. this.getStyle().display = "none";]]></method>
  3375. <property name="resultSetColumn">lindebeu</property>
  3376. </data>
  3377. </cell>
  3378. <cell id="660">
  3379. <data id="797">
  3380. <property name="fontWeight">bold</property>
  3381. <structure name="numberFormat">
  3382. <property name="category">Fixed</property>
  3383. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3384. <property name="locale">es_GT</property>
  3385. </structure>
  3386. <property name="textAlign">right</property>
  3387. <list-property name="visibility">
  3388. <structure>
  3389. <property name="format">all</property>
  3390. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3391. fl[12]==0</expression>
  3392. </structure>
  3393. </list-property>
  3394. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3395. this.getStyle().display = "none";]]></method>
  3396. <property name="resultSetColumn">lindebev</property>
  3397. </data>
  3398. </cell>
  3399. <cell id="661">
  3400. <data id="798">
  3401. <property name="fontWeight">bold</property>
  3402. <structure name="numberFormat">
  3403. <property name="category">Fixed</property>
  3404. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3405. <property name="locale">es_GT</property>
  3406. </structure>
  3407. <property name="textAlign">right</property>
  3408. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3409. this.getStyle().display = "none";]]></method>
  3410. <property name="resultSetColumn">linhaberu</property>
  3411. </data>
  3412. </cell>
  3413. <cell id="662">
  3414. <data id="799">
  3415. <property name="fontWeight">bold</property>
  3416. <structure name="numberFormat">
  3417. <property name="category">Fixed</property>
  3418. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3419. <property name="locale">es_GT</property>
  3420. </structure>
  3421. <property name="textAlign">right</property>
  3422. <list-property name="visibility">
  3423. <structure>
  3424. <property name="format">all</property>
  3425. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3426. fl[12]==0</expression>
  3427. </structure>
  3428. </list-property>
  3429. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3430. this.getStyle().display = "none";]]></method>
  3431. <property name="resultSetColumn">linhaberv</property>
  3432. </data>
  3433. </cell>
  3434. <cell id="663">
  3435. <text-data id="10651">
  3436. <property name="fontWeight">bold</property>
  3437. <property name="textAlign">right</property>
  3438. <structure name="toc"/>
  3439. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3440. this.getStyle().display = "none";]]></method>
  3441. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3442. df.format(saldoUl);</expression>
  3443. <property name="contentType">html</property>
  3444. </text-data>
  3445. </cell>
  3446. <cell id="664">
  3447. <text-data id="10652">
  3448. <property name="fontWeight">bold</property>
  3449. <property name="textAlign">right</property>
  3450. <structure name="toc"/>
  3451. <method name="onCreate"><![CDATA[if( row["linea"] == "" )
  3452. this.getStyle().display = "none";]]></method>
  3453. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3454. df.format(saldoVl);</expression>
  3455. <property name="contentType">html</property>
  3456. </text-data>
  3457. </cell>
  3458. <cell id="665"/>
  3459. <cell id="10802"/>
  3460. </row>
  3461. </footer>
  3462. </group>
  3463. <group id="697">
  3464. <property name="groupName">marca</property>
  3465. <expression name="keyExpr" type="javascript">row["marca"]</expression>
  3466. <structure name="toc">
  3467. <expression name="expressionValue" type="javascript">row["marca"]</expression>
  3468. </structure>
  3469. <property name="repeatHeader">false</property>
  3470. <property name="hideDetail">false</property>
  3471. <header>
  3472. <row id="698">
  3473. <list-property name="visibility">
  3474. <structure>
  3475. <property name="format">all</property>
  3476. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3477. fl[15]==1</expression>
  3478. </structure>
  3479. </list-property>
  3480. <cell id="701">
  3481. <property name="colSpan">10</property>
  3482. <property name="rowSpan">1</property>
  3483. <property name="paddingLeft">65pt</property>
  3484. <label id="725">
  3485. <property name="fontWeight">normal</property>
  3486. <property name="display">inline</property>
  3487. <text-property name="text">Categoria</text-property>
  3488. </label>
  3489. <data id="724">
  3490. <property name="display">inline</property>
  3491. <method name="onCreate"><![CDATA[saldoUm=0;
  3492. saldoVm=0;]]></method>
  3493. <property name="resultSetColumn">marca</property>
  3494. </data>
  3495. </cell>
  3496. <cell id="10789">
  3497. <property name="paddingLeft">65pt</property>
  3498. </cell>
  3499. </row>
  3500. </header>
  3501. <footer>
  3502. <row id="711">
  3503. <cell id="714">
  3504. <property name="colSpan">3</property>
  3505. <property name="rowSpan">1</property>
  3506. <property name="paddingLeft">65pt</property>
  3507. <property name="textAlign">left</property>
  3508. <label id="10782">
  3509. <property name="fontWeight">bold</property>
  3510. <property name="display">inline</property>
  3511. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3512. this.getStyle().display = "none";]]></method>
  3513. <text-property name="text">Total</text-property>
  3514. </label>
  3515. <data id="794">
  3516. <property name="fontWeight">bold</property>
  3517. <property name="textAlign">right</property>
  3518. <property name="display">inline</property>
  3519. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3520. this.getStyle().display = "none";]]></method>
  3521. <property name="resultSetColumn">marca</property>
  3522. </data>
  3523. </cell>
  3524. <cell id="717">
  3525. <property name="fontWeight">bold</property>
  3526. <data id="802">
  3527. <structure name="numberFormat">
  3528. <property name="category">Fixed</property>
  3529. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3530. <property name="locale">es_GT</property>
  3531. </structure>
  3532. <property name="textAlign">right</property>
  3533. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3534. this.getStyle().display = "none";]]></method>
  3535. <property name="resultSetColumn">mardebeu</property>
  3536. </data>
  3537. </cell>
  3538. <cell id="718">
  3539. <property name="fontWeight">bold</property>
  3540. <data id="804">
  3541. <structure name="numberFormat">
  3542. <property name="category">Fixed</property>
  3543. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3544. <property name="locale">es_GT</property>
  3545. </structure>
  3546. <property name="textAlign">right</property>
  3547. <list-property name="visibility">
  3548. <structure>
  3549. <property name="format">all</property>
  3550. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3551. fl[12]==0</expression>
  3552. </structure>
  3553. </list-property>
  3554. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3555. this.getStyle().display = "none";]]></method>
  3556. <property name="resultSetColumn">mardebev</property>
  3557. </data>
  3558. </cell>
  3559. <cell id="719">
  3560. <property name="fontWeight">bold</property>
  3561. <data id="805">
  3562. <structure name="numberFormat">
  3563. <property name="category">Fixed</property>
  3564. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3565. <property name="locale">es_GT</property>
  3566. </structure>
  3567. <property name="textAlign">right</property>
  3568. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3569. this.getStyle().display = "none";]]></method>
  3570. <property name="resultSetColumn">marhaberu</property>
  3571. </data>
  3572. </cell>
  3573. <cell id="720">
  3574. <property name="fontWeight">bold</property>
  3575. <data id="806">
  3576. <structure name="numberFormat">
  3577. <property name="category">Fixed</property>
  3578. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3579. <property name="locale">es_GT</property>
  3580. </structure>
  3581. <property name="textAlign">right</property>
  3582. <list-property name="visibility">
  3583. <structure>
  3584. <property name="format">all</property>
  3585. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3586. fl[12]==0</expression>
  3587. </structure>
  3588. </list-property>
  3589. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3590. this.getStyle().display = "none";]]></method>
  3591. <property name="resultSetColumn">marhaberv</property>
  3592. </data>
  3593. </cell>
  3594. <cell id="721">
  3595. <text-data id="10649">
  3596. <property name="fontWeight">bold</property>
  3597. <property name="textAlign">right</property>
  3598. <structure name="toc"/>
  3599. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3600. this.getStyle().display = "none";]]></method>
  3601. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3602. df.format(saldoUm);</expression>
  3603. <property name="contentType">html</property>
  3604. </text-data>
  3605. </cell>
  3606. <cell id="722">
  3607. <text-data id="10650">
  3608. <property name="fontWeight">bold</property>
  3609. <property name="textAlign">right</property>
  3610. <structure name="toc"/>
  3611. <method name="onCreate"><![CDATA[if( row["marca"] == "" )
  3612. this.getStyle().display = "none";]]></method>
  3613. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3614. df.format(saldoVm);</expression>
  3615. <property name="contentType">html</property>
  3616. </text-data>
  3617. </cell>
  3618. <cell id="723"/>
  3619. <cell id="10801"/>
  3620. </row>
  3621. </footer>
  3622. </group>
  3623. <group id="10682">
  3624. <property name="groupName">categoria3</property>
  3625. <expression name="keyExpr" type="javascript">row["cat3"]</expression>
  3626. <structure name="toc">
  3627. <expression name="expressionValue" type="javascript">row["cat3"]</expression>
  3628. </structure>
  3629. <property name="repeatHeader">false</property>
  3630. <property name="hideDetail">false</property>
  3631. <header>
  3632. <row id="10683">
  3633. <list-property name="visibility">
  3634. <structure>
  3635. <property name="format">all</property>
  3636. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3637. fl[15]==1</expression>
  3638. </structure>
  3639. </list-property>
  3640. <cell id="10684">
  3641. <property name="colSpan">10</property>
  3642. <property name="rowSpan">1</property>
  3643. <property name="paddingLeft">85pt</property>
  3644. <label id="10754">
  3645. <property name="fontWeight">normal</property>
  3646. <property name="display">inline</property>
  3647. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3648. this.getStyle().display = "none";]]></method>
  3649. <text-property name="text">Categoria</text-property>
  3650. </label>
  3651. <data id="10705">
  3652. <property name="display">inline</property>
  3653. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3654. this.getStyle().display = "none";
  3655.  
  3656. saldoUcat3=0;
  3657. saldoVcat3 = 0; ]]></method>
  3658. <property name="resultSetColumn">cat3</property>
  3659. </data>
  3660. </cell>
  3661. <cell id="10790">
  3662. <property name="paddingLeft">85pt</property>
  3663. </cell>
  3664. </row>
  3665. </header>
  3666. <footer>
  3667. <row id="10694">
  3668. <cell id="10695">
  3669. <property name="colSpan">3</property>
  3670. <property name="rowSpan">1</property>
  3671. <property name="paddingLeft">85pt</property>
  3672. <property name="textAlign">left</property>
  3673. <label id="10781">
  3674. <property name="fontWeight">bold</property>
  3675. <property name="display">inline</property>
  3676. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3677. this.getStyle().display = "none";]]></method>
  3678. <text-property name="text">Total</text-property>
  3679. </label>
  3680. <data id="10758">
  3681. <property name="fontWeight">bold</property>
  3682. <property name="textAlign">right</property>
  3683. <property name="display">inline</property>
  3684. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3685. this.getStyle().display = "none";]]></method>
  3686. <property name="resultSetColumn">cat3</property>
  3687. </data>
  3688. </cell>
  3689. <cell id="10698">
  3690. <data id="10761">
  3691. <property name="fontWeight">bold</property>
  3692. <structure name="numberFormat">
  3693. <property name="category">Fixed</property>
  3694. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3695. <property name="locale">es_GT</property>
  3696. </structure>
  3697. <property name="textAlign">right</property>
  3698. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3699. this.getStyle().display = "none";]]></method>
  3700. <property name="resultSetColumn">sumcat3debeu</property>
  3701. </data>
  3702. </cell>
  3703. <cell id="10699">
  3704. <data id="10764">
  3705. <property name="fontWeight">bold</property>
  3706. <structure name="numberFormat">
  3707. <property name="category">Fixed</property>
  3708. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3709. <property name="locale">es_GT</property>
  3710. </structure>
  3711. <property name="textAlign">right</property>
  3712. <list-property name="visibility">
  3713. <structure>
  3714. <property name="format">all</property>
  3715. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3716. fl[12]==0</expression>
  3717. </structure>
  3718. </list-property>
  3719. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3720. this.getStyle().display = "none";]]></method>
  3721. <property name="resultSetColumn">sumcate3debec</property>
  3722. </data>
  3723. </cell>
  3724. <cell id="10700">
  3725. <data id="10767">
  3726. <property name="fontWeight">bold</property>
  3727. <structure name="numberFormat">
  3728. <property name="category">Fixed</property>
  3729. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3730. <property name="locale">es_GT</property>
  3731. </structure>
  3732. <property name="textAlign">right</property>
  3733. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3734. this.getStyle().display = "none";]]></method>
  3735. <property name="resultSetColumn">sumcat3haberu</property>
  3736. </data>
  3737. </cell>
  3738. <cell id="10701">
  3739. <data id="10770">
  3740. <property name="fontWeight">bold</property>
  3741. <structure name="numberFormat">
  3742. <property name="category">Fixed</property>
  3743. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3744. <property name="locale">es_GT</property>
  3745. </structure>
  3746. <property name="textAlign">right</property>
  3747. <list-property name="visibility">
  3748. <structure>
  3749. <property name="format">all</property>
  3750. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3751. fl[12]==0</expression>
  3752. </structure>
  3753. </list-property>
  3754. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3755. this.getStyle().display = "none";]]></method>
  3756. <property name="resultSetColumn">sumcat3haberv</property>
  3757. </data>
  3758. </cell>
  3759. <cell id="10702">
  3760. <text-data id="10773">
  3761. <property name="fontWeight">bold</property>
  3762. <property name="textAlign">right</property>
  3763. <structure name="toc"/>
  3764. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3765. this.getStyle().display = "none";]]></method>
  3766. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3767. df.format(saldoUcat3);</expression>
  3768. <property name="contentType">html</property>
  3769. </text-data>
  3770. </cell>
  3771. <cell id="10703">
  3772. <text-data id="10776">
  3773. <property name="fontWeight">bold</property>
  3774. <property name="textAlign">right</property>
  3775. <structure name="toc"/>
  3776. <method name="onCreate"><![CDATA[if( row["cat3"] == "" )
  3777. this.getStyle().display = "none";]]></method>
  3778. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3779. df.format(saldoVcat3);</expression>
  3780. <property name="contentType">html</property>
  3781. </text-data>
  3782. </cell>
  3783. <cell id="10704"/>
  3784. <cell id="10800"/>
  3785. </row>
  3786. </footer>
  3787. </group>
  3788. <group id="10706">
  3789. <property name="groupName">categoria4</property>
  3790. <expression name="keyExpr" type="javascript">row["cat4"]</expression>
  3791. <structure name="toc">
  3792. <expression name="expressionValue" type="javascript">row["cat4"]</expression>
  3793. </structure>
  3794. <property name="repeatHeader">false</property>
  3795. <property name="hideDetail">false</property>
  3796. <header>
  3797. <row id="10707">
  3798. <list-property name="visibility">
  3799. <structure>
  3800. <property name="format">all</property>
  3801. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3802. fl[15]==1</expression>
  3803. </structure>
  3804. </list-property>
  3805. <cell id="10708">
  3806. <property name="colSpan">10</property>
  3807. <property name="rowSpan">1</property>
  3808. <property name="paddingLeft">105pt</property>
  3809. <label id="10755">
  3810. <property name="fontWeight">normal</property>
  3811. <property name="display">inline</property>
  3812. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3813. this.getStyle().display = "none";]]></method>
  3814. <text-property name="text">Categoria</text-property>
  3815. </label>
  3816. <data id="10729">
  3817. <property name="display">inline</property>
  3818. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3819. this.getStyle().display = "none";
  3820.  
  3821. saldoUcat4=0;
  3822. saldoVcat4 = 0; ]]></method>
  3823. <property name="resultSetColumn">cat4</property>
  3824. </data>
  3825. </cell>
  3826. <cell id="10791">
  3827. <property name="paddingLeft">105pt</property>
  3828. </cell>
  3829. </row>
  3830. </header>
  3831. <footer>
  3832. <row id="10718">
  3833. <cell id="10719">
  3834. <property name="colSpan">3</property>
  3835. <property name="rowSpan">1</property>
  3836. <property name="paddingLeft">105pt</property>
  3837. <property name="textAlign">left</property>
  3838. <label id="10780">
  3839. <property name="fontWeight">bold</property>
  3840. <property name="display">inline</property>
  3841. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3842. this.getStyle().display = "none";]]></method>
  3843. <text-property name="text">Total</text-property>
  3844. </label>
  3845. <data id="10759">
  3846. <property name="fontWeight">bold</property>
  3847. <property name="textAlign">right</property>
  3848. <property name="display">inline</property>
  3849. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3850. this.getStyle().display = "none";]]></method>
  3851. <property name="resultSetColumn">cat4</property>
  3852. </data>
  3853. </cell>
  3854. <cell id="10722">
  3855. <data id="10762">
  3856. <property name="fontWeight">bold</property>
  3857. <structure name="numberFormat">
  3858. <property name="category">Fixed</property>
  3859. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3860. <property name="locale">es_GT</property>
  3861. </structure>
  3862. <property name="textAlign">right</property>
  3863. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3864. this.getStyle().display = "none";]]></method>
  3865. <property name="resultSetColumn">sumcat4debeu</property>
  3866. </data>
  3867. </cell>
  3868. <cell id="10723">
  3869. <data id="10765">
  3870. <property name="fontWeight">bold</property>
  3871. <structure name="numberFormat">
  3872. <property name="category">Fixed</property>
  3873. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3874. <property name="locale">es_GT</property>
  3875. </structure>
  3876. <property name="textAlign">right</property>
  3877. <list-property name="visibility">
  3878. <structure>
  3879. <property name="format">all</property>
  3880. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3881. fl[12]==0</expression>
  3882. </structure>
  3883. </list-property>
  3884. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3885. this.getStyle().display = "none";]]></method>
  3886. <property name="resultSetColumn">sumcat4debec</property>
  3887. </data>
  3888. </cell>
  3889. <cell id="10724">
  3890. <data id="10768">
  3891. <property name="fontWeight">bold</property>
  3892. <structure name="numberFormat">
  3893. <property name="category">Fixed</property>
  3894. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3895. <property name="locale">es_GT</property>
  3896. </structure>
  3897. <property name="textAlign">right</property>
  3898. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3899. this.getStyle().display = "none";]]></method>
  3900. <property name="resultSetColumn">sumcat4haberu</property>
  3901. </data>
  3902. </cell>
  3903. <cell id="10725">
  3904. <data id="10771">
  3905. <property name="fontWeight">bold</property>
  3906. <structure name="numberFormat">
  3907. <property name="category">Fixed</property>
  3908. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  3909. <property name="locale">es_GT</property>
  3910. </structure>
  3911. <property name="textAlign">right</property>
  3912. <list-property name="visibility">
  3913. <structure>
  3914. <property name="format">all</property>
  3915. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3916. fl[12]==0</expression>
  3917. </structure>
  3918. </list-property>
  3919. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3920. this.getStyle().display = "none";]]></method>
  3921. <property name="resultSetColumn">sumcat4haberv</property>
  3922. </data>
  3923. </cell>
  3924. <cell id="10726">
  3925. <text-data id="10774">
  3926. <property name="fontWeight">bold</property>
  3927. <property name="textAlign">right</property>
  3928. <structure name="toc"/>
  3929. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3930. this.getStyle().display = "none";]]></method>
  3931. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3932. df.format(saldoUcat4);</expression>
  3933. <property name="contentType">html</property>
  3934. </text-data>
  3935. </cell>
  3936. <cell id="10727">
  3937. <text-data id="10777">
  3938. <property name="fontWeight">bold</property>
  3939. <property name="textAlign">right</property>
  3940. <structure name="toc"/>
  3941. <method name="onCreate"><![CDATA[if( row["cat4"] == "" )
  3942. this.getStyle().display = "none";]]></method>
  3943. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  3944. df.format(saldoVcat4);</expression>
  3945. <property name="contentType">html</property>
  3946. </text-data>
  3947. </cell>
  3948. <cell id="10728"/>
  3949. <cell id="10799"/>
  3950. </row>
  3951. </footer>
  3952. </group>
  3953. <group id="10730">
  3954. <property name="groupName">categoria5</property>
  3955. <expression name="keyExpr" type="javascript">row["cat5"]</expression>
  3956. <structure name="toc">
  3957. <expression name="expressionValue" type="javascript">row["cat5"]</expression>
  3958. </structure>
  3959. <property name="repeatHeader">false</property>
  3960. <property name="hideDetail">false</property>
  3961. <header>
  3962. <row id="10731">
  3963. <list-property name="visibility">
  3964. <structure>
  3965. <property name="format">all</property>
  3966. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  3967. fl[15]==1</expression>
  3968. </structure>
  3969. </list-property>
  3970. <cell id="10732">
  3971. <property name="colSpan">10</property>
  3972. <property name="rowSpan">1</property>
  3973. <property name="paddingLeft">125pt</property>
  3974. <label id="10756">
  3975. <property name="fontWeight">normal</property>
  3976. <property name="display">inline</property>
  3977. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  3978. this.getStyle().display = "none";]]></method>
  3979. <text-property name="text">Categoria</text-property>
  3980. </label>
  3981. <data id="10753">
  3982. <property name="display">inline</property>
  3983. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  3984. this.getStyle().display = "none";
  3985.  
  3986. saldoUcat5=0;
  3987. saldoVcat5 = 0; ]]></method>
  3988. <property name="resultSetColumn">cat5</property>
  3989. </data>
  3990. </cell>
  3991. <cell id="10792">
  3992. <property name="paddingLeft">125pt</property>
  3993. </cell>
  3994. </row>
  3995. </header>
  3996. <footer>
  3997. <row id="10742">
  3998. <cell id="10743">
  3999. <property name="colSpan">3</property>
  4000. <property name="rowSpan">1</property>
  4001. <property name="paddingLeft">125pt</property>
  4002. <property name="textAlign">left</property>
  4003. <label id="10779">
  4004. <property name="fontWeight">bold</property>
  4005. <property name="display">inline</property>
  4006. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4007. this.getStyle().display = "none";]]></method>
  4008. <text-property name="text">Total</text-property>
  4009. </label>
  4010. <data id="10760">
  4011. <property name="fontWeight">bold</property>
  4012. <property name="textAlign">right</property>
  4013. <property name="display">inline</property>
  4014. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4015. this.getStyle().display = "none";]]></method>
  4016. <property name="resultSetColumn">cat5</property>
  4017. </data>
  4018. </cell>
  4019. <cell id="10746">
  4020. <property name="borderTopColor">#000000</property>
  4021. <property name="borderTopStyle">solid</property>
  4022. <property name="borderTopWidth">thin</property>
  4023. <data id="10763">
  4024. <property name="fontWeight">bold</property>
  4025. <structure name="numberFormat">
  4026. <property name="category">Fixed</property>
  4027. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4028. <property name="locale">es_GT</property>
  4029. </structure>
  4030. <property name="textAlign">right</property>
  4031. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4032. this.getStyle().display = "none";]]></method>
  4033. <property name="resultSetColumn">sumcat5debeu</property>
  4034. </data>
  4035. </cell>
  4036. <cell id="10747">
  4037. <property name="borderTopColor">#000000</property>
  4038. <property name="borderTopStyle">solid</property>
  4039. <property name="borderTopWidth">thin</property>
  4040. <data id="10766">
  4041. <property name="fontWeight">bold</property>
  4042. <structure name="numberFormat">
  4043. <property name="category">Fixed</property>
  4044. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4045. <property name="locale">es_GT</property>
  4046. </structure>
  4047. <property name="textAlign">right</property>
  4048. <list-property name="visibility">
  4049. <structure>
  4050. <property name="format">all</property>
  4051. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4052. fl[12]==0</expression>
  4053. </structure>
  4054. </list-property>
  4055. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4056. this.getStyle().display = "none";]]></method>
  4057. <property name="resultSetColumn">sumcat5debec</property>
  4058. </data>
  4059. </cell>
  4060. <cell id="10748">
  4061. <property name="borderTopColor">#000000</property>
  4062. <property name="borderTopStyle">solid</property>
  4063. <property name="borderTopWidth">thin</property>
  4064. <data id="10769">
  4065. <property name="fontWeight">bold</property>
  4066. <structure name="numberFormat">
  4067. <property name="category">Fixed</property>
  4068. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4069. <property name="locale">es_GT</property>
  4070. </structure>
  4071. <property name="textAlign">right</property>
  4072. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4073. this.getStyle().display = "none";]]></method>
  4074. <property name="resultSetColumn">sumcat5haberu</property>
  4075. </data>
  4076. </cell>
  4077. <cell id="10749">
  4078. <property name="borderTopColor">#000000</property>
  4079. <property name="borderTopStyle">solid</property>
  4080. <property name="borderTopWidth">thin</property>
  4081. <data id="10772">
  4082. <property name="fontWeight">bold</property>
  4083. <structure name="numberFormat">
  4084. <property name="category">Fixed</property>
  4085. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4086. <property name="locale">es_GT</property>
  4087. </structure>
  4088. <property name="textAlign">right</property>
  4089. <list-property name="visibility">
  4090. <structure>
  4091. <property name="format">all</property>
  4092. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4093. fl[12]==0</expression>
  4094. </structure>
  4095. </list-property>
  4096. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4097. this.getStyle().display = "none";]]></method>
  4098. <property name="resultSetColumn">sumcat5haberv</property>
  4099. </data>
  4100. </cell>
  4101. <cell id="10750">
  4102. <property name="borderTopColor">#000000</property>
  4103. <property name="borderTopStyle">solid</property>
  4104. <property name="borderTopWidth">thin</property>
  4105. <text-data id="10775">
  4106. <property name="fontWeight">bold</property>
  4107. <property name="textAlign">right</property>
  4108. <structure name="toc"/>
  4109. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4110. this.getStyle().display = "none";]]></method>
  4111. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  4112. df.format(saldoUcat5);</expression>
  4113. <property name="contentType">html</property>
  4114. </text-data>
  4115. </cell>
  4116. <cell id="10751">
  4117. <property name="borderTopColor">#000000</property>
  4118. <property name="borderTopStyle">solid</property>
  4119. <property name="borderTopWidth">thin</property>
  4120. <text-data id="10778">
  4121. <property name="fontWeight">bold</property>
  4122. <property name="textAlign">right</property>
  4123. <structure name="toc"/>
  4124. <method name="onCreate"><![CDATA[if( row["cat5"] == "" )
  4125. this.getStyle().display = "none";]]></method>
  4126. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  4127. df.format(saldoVcat5);</expression>
  4128. <property name="contentType">html</property>
  4129. </text-data>
  4130. </cell>
  4131. <cell id="10752"/>
  4132. <cell id="10798"/>
  4133. </row>
  4134. </footer>
  4135. </group>
  4136. <group id="68">
  4137. <property name="groupName">producto</property>
  4138. <property name="interval">none</property>
  4139. <property name="sortDirection">asc</property>
  4140. <expression name="keyExpr" type="javascript">row["producto_id"]</expression>
  4141. <structure name="toc">
  4142. <expression name="expressionValue" type="javascript">row["producto_id"]</expression>
  4143. </structure>
  4144. <property name="repeatHeader">false</property>
  4145. <property name="hideDetail">false</property>
  4146. <property name="pageBreakAfter">auto</property>
  4147. <property name="pageBreakBefore">auto</property>
  4148. <property name="pageBreakInside">auto</property>
  4149. <header>
  4150. <row id="69">
  4151. <property name="verticalAlign">bottom</property>
  4152. <list-property name="visibility">
  4153. <structure>
  4154. <property name="format">all</property>
  4155. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4156. fl[15]==1</expression>
  4157. </structure>
  4158. </list-property>
  4159. <cell id="70">
  4160. <property name="colSpan">3</property>
  4161. <property name="rowSpan">1</property>
  4162. <data id="80">
  4163. <property name="whiteSpace">nowrap</property>
  4164. <property name="display">inline</property>
  4165. <property name="resultSetColumn">sku</property>
  4166. </data>
  4167. <label id="516">
  4168. <property name="display">inline</property>
  4169. <text-property name="text"> -</text-property>
  4170. </label>
  4171. <data id="520">
  4172. <property name="display">inline</property>
  4173. <property name="resultSetColumn">cod_alterno</property>
  4174. </data>
  4175. </cell>
  4176. <cell id="339">
  4177. <property name="colSpan">4</property>
  4178. <property name="rowSpan">1</property>
  4179. <data id="81">
  4180. <property name="whiteSpace">nowrap</property>
  4181. <list-property name="visibility">
  4182. <structure>
  4183. <property name="format">all</property>
  4184. </structure>
  4185. </list-property>
  4186. <property name="resultSetColumn">descrip</property>
  4187. </data>
  4188. </cell>
  4189. <cell id="301"/>
  4190. <cell id="291"/>
  4191. <cell id="277"/>
  4192. <cell id="10793"/>
  4193. </row>
  4194. <row id="252">
  4195. <property name="verticalAlign">bottom</property>
  4196. <list-property name="visibility">
  4197. <structure>
  4198. <property name="format">all</property>
  4199. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4200. fl[15]==1</expression>
  4201. </structure>
  4202. </list-property>
  4203. <cell id="253">
  4204. <property name="colSpan">7</property>
  4205. <property name="rowSpan">1</property>
  4206. <label id="260">
  4207. <property name="fontWeight">normal</property>
  4208. <property name="textAlign">right</property>
  4209. <text-property name="text">Saldos Iniciales:</text-property>
  4210. </label>
  4211. </cell>
  4212. <cell id="302">
  4213. <data id="261">
  4214. <property name="fontWeight">normal</property>
  4215. <structure name="numberFormat">
  4216. <property name="category">Fixed</property>
  4217. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4218. <property name="locale">es_GT</property>
  4219. </structure>
  4220. <property name="textAlign">right</property>
  4221. <property name="whiteSpace">nowrap</property>
  4222. <method name="onCreate"><![CDATA[saldoU = this.getValue();
  4223. ]]></method>
  4224. <property name="resultSetColumn">ExistenciaUI</property>
  4225. </data>
  4226. </cell>
  4227. <cell id="292">
  4228. <data id="262">
  4229. <property name="fontWeight">normal</property>
  4230. <structure name="numberFormat">
  4231. <property name="category">Fixed</property>
  4232. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4233. <property name="locale">es_GT</property>
  4234. </structure>
  4235. <property name="textAlign">right</property>
  4236. <property name="whiteSpace">nowrap</property>
  4237. <list-property name="visibility">
  4238. <structure>
  4239. <property name="format">all</property>
  4240. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4241. fl[12]==0</expression>
  4242. </structure>
  4243. </list-property>
  4244. <method name="onCreate"><![CDATA[saldoV = this.getValue();
  4245.  
  4246. ]]></method>
  4247. <property name="resultSetColumn">ExistenciaVI</property>
  4248. </data>
  4249. </cell>
  4250. <cell id="278">
  4251. <data id="340">
  4252. <property name="fontWeight">normal</property>
  4253. <structure name="numberFormat">
  4254. <property name="category">Fixed</property>
  4255. <property name="pattern">#,##0.00000{RoundingMode=HALF_UP}</property>
  4256. <property name="locale">es_GT</property>
  4257. </structure>
  4258. <property name="textAlign">right</property>
  4259. <list-property name="visibility">
  4260. <structure>
  4261. <property name="format">all</property>
  4262. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4263. fl[12]==0</expression>
  4264. </structure>
  4265. </list-property>
  4266. <method name="onCreate"><![CDATA[costoP = this.getValue();]]></method>
  4267. <property name="resultSetColumn">CostoU</property>
  4268. </data>
  4269. </cell>
  4270. <cell id="10794"/>
  4271. </row>
  4272. </header>
  4273. <footer>
  4274. <row id="263">
  4275. <property name="height">0.2708333333333333in</property>
  4276. <list-property name="visibility">
  4277. <structure>
  4278. <property name="format">all</property>
  4279. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4280. fl[15]==1</expression>
  4281. </structure>
  4282. </list-property>
  4283. <cell id="264">
  4284. <property name="colSpan">1</property>
  4285. <property name="rowSpan">1</property>
  4286. </cell>
  4287. <cell id="10814"/>
  4288. <cell id="10815">
  4289. <label id="273">
  4290. <property name="fontWeight">bold</property>
  4291. <property name="textAlign">right</property>
  4292. <text-property name="text">Total:</text-property>
  4293. </label>
  4294. </cell>
  4295. <cell id="10816">
  4296. <data id="10820">
  4297. <property name="fontWeight">bold</property>
  4298. <structure name="numberFormat">
  4299. <property name="category">Fixed</property>
  4300. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4301. <property name="locale">es_GT</property>
  4302. </structure>
  4303. <property name="textAlign">right</property>
  4304. <property name="resultSetColumn">sumproductou</property>
  4305. </data>
  4306. </cell>
  4307. <cell id="10817">
  4308. <data id="10821">
  4309. <property name="fontWeight">bold</property>
  4310. <structure name="numberFormat">
  4311. <property name="category">Fixed</property>
  4312. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4313. <property name="locale">es_GT</property>
  4314. </structure>
  4315. <property name="textAlign">right</property>
  4316. <list-property name="visibility">
  4317. <structure>
  4318. <property name="format">all</property>
  4319. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4320. fl[12]==0</expression>
  4321. </structure>
  4322. </list-property>
  4323. <property name="resultSetColumn">sumproductodebec</property>
  4324. </data>
  4325. </cell>
  4326. <cell id="10818">
  4327. <data id="10822">
  4328. <property name="fontWeight">bold</property>
  4329. <structure name="numberFormat">
  4330. <property name="category">Fixed</property>
  4331. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4332. <property name="locale">es_GT</property>
  4333. </structure>
  4334. <property name="textAlign">right</property>
  4335. <property name="resultSetColumn">sumproductohaberu</property>
  4336. </data>
  4337. </cell>
  4338. <cell id="10819">
  4339. <data id="10823">
  4340. <property name="fontWeight">bold</property>
  4341. <structure name="numberFormat">
  4342. <property name="category">Fixed</property>
  4343. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4344. <property name="locale">es_GT</property>
  4345. </structure>
  4346. <property name="textAlign">right</property>
  4347. <list-property name="visibility">
  4348. <structure>
  4349. <property name="format">all</property>
  4350. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4351. fl[12]==0</expression>
  4352. </structure>
  4353. </list-property>
  4354. <property name="resultSetColumn">sumproductohaberv</property>
  4355. </data>
  4356. </cell>
  4357. <cell id="304">
  4358. <property name="borderTopColor">#000000</property>
  4359. <property name="borderTopStyle">solid</property>
  4360. <property name="borderTopWidth">thin</property>
  4361. <data id="271">
  4362. <property name="fontWeight">bold</property>
  4363. <structure name="numberFormat">
  4364. <property name="category">Fixed</property>
  4365. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4366. <property name="locale">es_GT</property>
  4367. </structure>
  4368. <property name="textAlign">right</property>
  4369. <property name="whiteSpace">nowrap</property>
  4370. <method name="onCreate"><![CDATA[saldoUt = saldoUt+row["ExistenciaUF"];
  4371. saldoUs = saldoUs+row["ExistenciaUF"];
  4372. saldoUb = saldoUb+row["ExistenciaUF"];
  4373. saldoUl = saldoUl+row["ExistenciaUF"];
  4374. saldoUm = saldoUm+row["ExistenciaUF"];
  4375. saldoUcat3 = saldoUcat3+row["ExistenciaUF"];
  4376. saldoUcat4 = saldoUcat4+row["ExistenciaUF"];
  4377. saldoUcat5 = saldoUcat5+row["ExistenciaUF"];]]></method>
  4378. <property name="resultSetColumn">ExistenciaUF</property>
  4379. </data>
  4380. </cell>
  4381. <cell id="294">
  4382. <property name="borderTopColor">#000000</property>
  4383. <property name="borderTopStyle">solid</property>
  4384. <property name="borderTopWidth">thin</property>
  4385. <data id="272">
  4386. <property name="fontWeight">bold</property>
  4387. <structure name="numberFormat">
  4388. <property name="category">Fixed</property>
  4389. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4390. <property name="locale">es_GT</property>
  4391. </structure>
  4392. <property name="textAlign">right</property>
  4393. <property name="whiteSpace">nowrap</property>
  4394. <list-property name="visibility">
  4395. <structure>
  4396. <property name="format">all</property>
  4397. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4398. fl[12]==0</expression>
  4399. </structure>
  4400. </list-property>
  4401. <method name="onCreate"><![CDATA[saldoVt = saldoVt+row["ExistenciaVF"];
  4402. saldoVs = saldoVs+row["ExistenciaVF"];
  4403. saldoVb = saldoVb+row["ExistenciaVF"];
  4404. saldoVl = saldoVl+row["ExistenciaVF"];
  4405. saldoVm = saldoVm+row["ExistenciaVF"];
  4406. saldoVcat3 = saldoVcat3+row["ExistenciaVF"];
  4407. saldoVcat4 = saldoVcat4+row["ExistenciaVF"];
  4408. saldoVcat5 = saldoVcat5+row["ExistenciaVF"];
  4409. ]]></method>
  4410. <property name="resultSetColumn">ExistenciaVF</property>
  4411. </data>
  4412. </cell>
  4413. <cell id="280">
  4414. <property name="borderTopColor">#000000</property>
  4415. <property name="borderTopStyle">solid</property>
  4416. <property name="borderTopWidth">thin</property>
  4417. </cell>
  4418. <cell id="10796">
  4419. <property name="borderTopColor">#000000</property>
  4420. <property name="borderTopStyle">solid</property>
  4421. <property name="borderTopWidth">thin</property>
  4422. </cell>
  4423. </row>
  4424. <row id="74">
  4425. <property name="height">0.010416666666666666in</property>
  4426. <cell id="75">
  4427. <property name="colSpan">3</property>
  4428. <property name="rowSpan">1</property>
  4429. </cell>
  4430. <cell id="78"/>
  4431. <cell id="90"/>
  4432. <cell id="106"/>
  4433. <cell id="100"/>
  4434. <cell id="305"/>
  4435. <cell id="295"/>
  4436. <cell id="281"/>
  4437. <cell id="10797"/>
  4438. </row>
  4439. </footer>
  4440. </group>
  4441. <detail>
  4442. <row id="10">
  4443. <list-property name="visibility">
  4444. <structure>
  4445. <property name="format">all</property>
  4446. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4447. fl[15]==1</expression>
  4448. </structure>
  4449. </list-property>
  4450. <cell id="11">
  4451. <data id="83">
  4452. <structure name="dateTimeFormat">
  4453. <property name="category">Custom</property>
  4454. <property name="pattern">dd/MM/yyyy</property>
  4455. <property name="locale">es_GT</property>
  4456. </structure>
  4457. <property name="whiteSpace">nowrap</property>
  4458. <property name="resultSetColumn">fecha</property>
  4459. </data>
  4460. </cell>
  4461. <cell id="12">
  4462. <data id="115">
  4463. <property name="whiteSpace">nowrap</property>
  4464. <property name="resultSetColumn">documento</property>
  4465. </data>
  4466. </cell>
  4467. <cell id="13">
  4468. <property name="textAlign">right</property>
  4469. <data id="85">
  4470. <property name="whiteSpace">nowrap</property>
  4471. <property name="resultSetColumn">numero</property>
  4472. <list-property name="action">
  4473. <structure>
  4474. <property name="linkType">hyperlink</property>
  4475. <property name="toolTip">- link al documento -</property>
  4476. <expression name="uri" type="javascript">if (row["tipo_documento"]==1 || row["tipo_documento"]==3 ){&#13;
  4477. "http://www.scafinext.com:8080/birt-viewer/frameset?__report=online/factura_compras.rptdesign&amp;emId="+params["emId"].value+"&amp;fac_id="+row["id_14"]+"&amp;sucId="+params["sucId"].value+"&amp;sucursalId="+params["sucursalId"].value&#13;
  4478. }&#13;
  4479. else if (row["tipo_documento"]==2 || row["tipo_documento"]==4 ){&#13;
  4480. "http://www.scafinext.com:8080/birt-viewer/frameset?__report=online/factura_ventas.rptdesign&amp;emId="+params["emId"].value+"&amp;fac_id="+row["id_14"]+"&amp;sucId="+params["sucId"].value+"&amp;sucursalId="+params["sucursalId"].value&#13;
  4481. }&#13;
  4482. else if (row["tipo_documento"]==5){&#13;
  4483. "http://www.scafinext.com:8080/birt-viewer/frameset?__report=online/ingreso_dev.rptdesign&amp;emId="+params["emId"].value+"&amp;dev_id="+row["id_14"]&#13;
  4484. }&#13;
  4485. else if (row["tipo_documento"]==6){&#13;
  4486. "http://www.scafinext.com:8080/birt-viewer/frameset?__report=online/egreso_dev.rptdesign&amp;emId="+params["emId"].value+"&amp;dev_id="+row["id_14"]&#13;
  4487. }&#13;
  4488. else if (row["tipo_documento"]==11){&#13;
  4489. "http://www.scafinext.com:8080/birt-viewer/frameset?__report=online/traslado.rptdesign&amp;emId="+params["emId"].value+"&amp;traslado_id="+row["id_14"]&#13;
  4490. }</expression>
  4491. <property name="targetWindow">_blank</property>
  4492. </structure>
  4493. </list-property>
  4494. </data>
  4495. </cell>
  4496. <cell id="14">
  4497. <data id="94">
  4498. <structure name="numberFormat">
  4499. <property name="category">Fixed</property>
  4500. <property name="pattern">#,##0.00{RoundingMode=UNNECESSARY}</property>
  4501. <property name="locale">es_GT</property>
  4502. </structure>
  4503. <property name="textAlign">right</property>
  4504. <property name="whiteSpace">nowrap</property>
  4505. <list-property name="visibility">
  4506. <structure>
  4507. <property name="format">all</property>
  4508. <expression name="valueExpr" type="javascript">row["debeu"]==0</expression>
  4509. </structure>
  4510. </list-property>
  4511. <method name="onCreate"><![CDATA[if (isNaN(parseFloat(saldoU)))
  4512. saldoU = 0;
  4513.  
  4514. if (isNaN(parseFloat(this.getValue())))
  4515. debeU = 0;
  4516. else
  4517. debeU = this.getValue();
  4518.  
  4519. saldoU = parseFloat(saldoU)+parseFloat(debeU);
  4520. ]]></method>
  4521. <property name="resultSetColumn">debeu</property>
  4522. </data>
  4523. </cell>
  4524. <cell id="89">
  4525. <data id="355">
  4526. <structure name="numberFormat">
  4527. <property name="category">Fixed</property>
  4528. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4529. <property name="locale">es_GT</property>
  4530. </structure>
  4531. <property name="textAlign">right</property>
  4532. <list-property name="visibility">
  4533. <structure>
  4534. <property name="format">all</property>
  4535. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4536. row["debeu"]==0 || fl[12]==0</expression>
  4537. </structure>
  4538. </list-property>
  4539. <method name="onCreate"><![CDATA[if (isNaN(parseFloat(saldoV)))
  4540. saldoV = 0;
  4541.  
  4542. if (isNaN(parseFloat(this.getValue())))
  4543. debeV = 0;
  4544. else
  4545. debeV = this.getValue();
  4546.  
  4547. saldoV = parseFloat(saldoV)+parseFloat(debeV);
  4548. ]]></method>
  4549. <property name="resultSetColumn">debec</property>
  4550. </data>
  4551. </cell>
  4552. <cell id="105">
  4553. <data id="111">
  4554. <structure name="numberFormat">
  4555. <property name="category">Fixed</property>
  4556. <property name="pattern">#,##0.00{RoundingMode=UNNECESSARY}</property>
  4557. <property name="locale">es_GT</property>
  4558. </structure>
  4559. <property name="textAlign">right</property>
  4560. <property name="whiteSpace">nowrap</property>
  4561. <list-property name="visibility">
  4562. <structure>
  4563. <property name="format">all</property>
  4564. <expression name="valueExpr" type="javascript">row["haberu"]==0</expression>
  4565. </structure>
  4566. </list-property>
  4567. <method name="onCreate"><![CDATA[if (isNaN(parseFloat(saldoU)))
  4568. saldoU = 0;
  4569.  
  4570. if (isNaN(parseFloat(this.getValue())))
  4571. haberU = 0;
  4572. else
  4573. haberU = this.getValue();
  4574.  
  4575. saldoU = parseFloat(saldoU)-parseFloat(haberU);]]></method>
  4576. <property name="resultSetColumn">haberu</property>
  4577. </data>
  4578. </cell>
  4579. <cell id="99">
  4580. <data id="113">
  4581. <structure name="numberFormat">
  4582. <property name="category">Fixed</property>
  4583. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4584. <property name="locale">es_GT</property>
  4585. </structure>
  4586. <property name="textAlign">right</property>
  4587. <property name="whiteSpace">nowrap</property>
  4588. <list-property name="visibility">
  4589. <structure>
  4590. <property name="format">all</property>
  4591. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4592. row["haberv"]==0 || fl[12]==0</expression>
  4593. </structure>
  4594. </list-property>
  4595. <method name="onCreate"><![CDATA[if (isNaN(parseFloat(saldoV)))
  4596. saldoV = 0;
  4597.  
  4598. if (isNaN(parseFloat(this.getValue())))
  4599. haberV = 0;
  4600. else
  4601. haberV = this.getValue();
  4602.  
  4603. saldoV = parseFloat(saldoV)-parseFloat(haberV);
  4604. ]]></method>
  4605. <property name="resultSetColumn">haberv</property>
  4606. </data>
  4607. </cell>
  4608. <cell id="303">
  4609. <text-data id="10646">
  4610. <property name="textAlign">right</property>
  4611. <structure name="toc"/>
  4612. <expression name="valueExpr" type="javascript">df = new Packages.java.text.DecimalFormat("#,###.00");
  4613. df.format(saldoU);</expression>
  4614. <property name="contentType">html</property>
  4615. </text-data>
  4616. </cell>
  4617. <cell id="293">
  4618. <text-data id="10828">
  4619. <property name="textAlign">right</property>
  4620. <structure name="toc"/>
  4621. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  4622. df.format(saldoV);</expression>
  4623. <property name="contentType">html</property>
  4624. </text-data>
  4625. </cell>
  4626. <cell id="279">
  4627. <data id="10827">
  4628. <structure name="numberFormat">
  4629. <property name="category">Fixed</property>
  4630. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4631. <property name="locale">es_GT</property>
  4632. </structure>
  4633. <property name="textAlign">right</property>
  4634. <property name="resultSetColumn">costoprom</property>
  4635. </data>
  4636. </cell>
  4637. <cell id="10795">
  4638. <property name="paddingLeft">5pt</property>
  4639. <data id="10812">
  4640. <property name="resultSetColumn">nomfac</property>
  4641. </data>
  4642. </cell>
  4643. </row>
  4644. </detail>
  4645. <footer>
  4646. <row id="15">
  4647. <cell id="16"/>
  4648. <cell id="17"/>
  4649. <cell id="18">
  4650. <label id="337">
  4651. <property name="fontWeight">bold</property>
  4652. <property name="textAlign">right</property>
  4653. <text-property name="text">Totales:</text-property>
  4654. </label>
  4655. </cell>
  4656. <cell id="19">
  4657. <property name="borderBottomColor">#000000</property>
  4658. <property name="borderBottomStyle">solid</property>
  4659. <property name="borderBottomWidth">thin</property>
  4660. <property name="borderTopColor">#000000</property>
  4661. <property name="borderTopStyle">solid</property>
  4662. <property name="borderTopWidth">thin</property>
  4663. <data id="351">
  4664. <property name="fontWeight">bold</property>
  4665. <structure name="numberFormat">
  4666. <property name="category">Fixed</property>
  4667. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4668. <property name="locale">es_GT</property>
  4669. </structure>
  4670. <property name="textAlign">right</property>
  4671. <property name="resultSetColumn">totDebeU</property>
  4672. </data>
  4673. </cell>
  4674. <cell id="91">
  4675. <property name="borderBottomColor">#000000</property>
  4676. <property name="borderBottomStyle">solid</property>
  4677. <property name="borderBottomWidth">thin</property>
  4678. <property name="borderTopColor">#000000</property>
  4679. <property name="borderTopStyle">solid</property>
  4680. <property name="borderTopWidth">thin</property>
  4681. <data id="356">
  4682. <property name="fontWeight">bold</property>
  4683. <structure name="numberFormat">
  4684. <property name="category">Fixed</property>
  4685. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4686. <property name="locale">es_GT</property>
  4687. </structure>
  4688. <property name="textAlign">right</property>
  4689. <list-property name="visibility">
  4690. <structure>
  4691. <property name="format">all</property>
  4692. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4693. fl[12]==0</expression>
  4694. </structure>
  4695. </list-property>
  4696. <property name="resultSetColumn">totDebeC</property>
  4697. </data>
  4698. </cell>
  4699. <cell id="107">
  4700. <property name="borderBottomColor">#000000</property>
  4701. <property name="borderBottomStyle">solid</property>
  4702. <property name="borderBottomWidth">thin</property>
  4703. <property name="borderTopColor">#000000</property>
  4704. <property name="borderTopStyle">solid</property>
  4705. <property name="borderTopWidth">thin</property>
  4706. <data id="357">
  4707. <property name="fontWeight">bold</property>
  4708. <structure name="numberFormat">
  4709. <property name="category">Fixed</property>
  4710. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4711. <property name="locale">es_GT</property>
  4712. </structure>
  4713. <property name="textAlign">right</property>
  4714. <property name="resultSetColumn">totHaberU</property>
  4715. </data>
  4716. </cell>
  4717. <cell id="101">
  4718. <property name="borderBottomColor">#000000</property>
  4719. <property name="borderBottomStyle">solid</property>
  4720. <property name="borderBottomWidth">thin</property>
  4721. <property name="borderTopColor">#000000</property>
  4722. <property name="borderTopStyle">solid</property>
  4723. <property name="borderTopWidth">thin</property>
  4724. <data id="358">
  4725. <property name="fontWeight">bold</property>
  4726. <structure name="numberFormat">
  4727. <property name="category">Fixed</property>
  4728. <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
  4729. <property name="locale">es_GT</property>
  4730. </structure>
  4731. <property name="textAlign">right</property>
  4732. <list-property name="visibility">
  4733. <structure>
  4734. <property name="format">all</property>
  4735. <expression name="valueExpr" type="javascript">var fl = params["flags"].value.split('|');&#13;
  4736. fl[12]==0</expression>
  4737. </structure>
  4738. </list-property>
  4739. <property name="resultSetColumn">totHaberV</property>
  4740. </data>
  4741. </cell>
  4742. <cell id="306">
  4743. <property name="borderBottomColor">#000000</property>
  4744. <property name="borderBottomStyle">solid</property>
  4745. <property name="borderBottomWidth">thin</property>
  4746. <property name="borderTopColor">#000000</property>
  4747. <property name="borderTopStyle">solid</property>
  4748. <property name="borderTopWidth">thin</property>
  4749. <text-data id="10657">
  4750. <property name="fontWeight">bold</property>
  4751. <property name="textAlign">right</property>
  4752. <structure name="toc"/>
  4753. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  4754. df.format(saldoUt);</expression>
  4755. <property name="contentType">html</property>
  4756. </text-data>
  4757. </cell>
  4758. <cell id="296">
  4759. <property name="borderBottomColor">#000000</property>
  4760. <property name="borderBottomStyle">solid</property>
  4761. <property name="borderBottomWidth">thin</property>
  4762. <property name="borderTopColor">#000000</property>
  4763. <property name="borderTopStyle">solid</property>
  4764. <property name="borderTopWidth">thin</property>
  4765. <text-data id="10658">
  4766. <property name="fontWeight">bold</property>
  4767. <property name="textAlign">right</property>
  4768. <structure name="toc"/>
  4769. <expression name="valueExpr">df = new Packages.java.text.DecimalFormat("#,###.00");
  4770. df.format(saldoVt);</expression>
  4771. <property name="contentType">html</property>
  4772. </text-data>
  4773. </cell>
  4774. <cell id="282"/>
  4775. <cell id="10805"/>
  4776. </row>
  4777. </footer>
  4778. </table>
  4779. </body>
  4780. </report>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!