Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.59 KB | None | 0 0
  1. OBJECT Report 50000 tmp Header
  2. {
  3. OBJECT-PROPERTIES
  4. {
  5. Date=18.11.19;
  6. Time=12:58:28;
  7. Modified=Yes;
  8. Version List=;
  9. }
  10. PROPERTIES
  11. {
  12. PreviewMode=PrintLayout;
  13. }
  14. DATASET
  15. {
  16. { 1000000000;;DataItem;Loop ;
  17. DataItemTable=Table2000000026;
  18. DataItemTableView=SORTING(Number);
  19. OnPreDataItem=BEGIN
  20. SETRANGE(Number,1,300);
  21. END;
  22. }
  23.  
  24. { 1000000001;1;Column;Number ;
  25. SourceExpr=Number }
  26.  
  27. }
  28. REQUESTPAGE
  29. {
  30. PROPERTIES
  31. {
  32. }
  33. CONTROLS
  34. {
  35. }
  36. }
  37. LABELS
  38. {
  39. }
  40. CODE
  41. {
  42.  
  43. BEGIN
  44. END.
  45. }
  46. RDLDATA
  47. {
  48. <?xml version="1.0" encoding="utf-8"?>
  49. <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
  50. <AutoRefresh>0</AutoRefresh>
  51. <DataSources>
  52. <DataSource Name="DataSource">
  53. <ConnectionProperties>
  54. <DataProvider>SQL</DataProvider>
  55. <ConnectString />
  56. </ConnectionProperties>
  57. <rd:SecurityType>None</rd:SecurityType>
  58. <rd:DataSourceID>45159f8d-aa21-4c1c-bee7-e05acc7fd953</rd:DataSourceID>
  59. </DataSource>
  60. </DataSources>
  61. <DataSets>
  62. <DataSet Name="DataSet_Result">
  63. <Query>
  64. <DataSourceName>DataSource</DataSourceName>
  65. <CommandText />
  66. </Query>
  67. <Fields>
  68. <Field Name="Number">
  69. <DataField>Number</DataField>
  70. </Field>
  71. </Fields>
  72. <rd:DataSetInfo>
  73. <rd:DataSetName>DataSet</rd:DataSetName>
  74. <rd:SchemaPath>Report.xsd</rd:SchemaPath>
  75. <rd:TableName>Result</rd:TableName>
  76. </rd:DataSetInfo>
  77. </DataSet>
  78. </DataSets>
  79. <ReportSections>
  80. <ReportSection>
  81. <Body>
  82. <ReportItems>
  83. <Tablix Name="Tablix1">
  84. <TablixBody>
  85. <TablixColumns>
  86. <TablixColumn>
  87. <Width>1in</Width>
  88. </TablixColumn>
  89. <TablixColumn>
  90. <Width>1in</Width>
  91. </TablixColumn>
  92. </TablixColumns>
  93. <TablixRows>
  94. <TablixRow>
  95. <Height>0.16667in</Height>
  96. <TablixCells>
  97. <TablixCell>
  98. <CellContents>
  99. <Textbox Name="Number">
  100. <CanGrow>true</CanGrow>
  101. <KeepTogether>true</KeepTogether>
  102. <Paragraphs>
  103. <Paragraph>
  104. <TextRuns>
  105. <TextRun>
  106. <Value EvaluationMode="Auto">=Fields!Number.Value</Value>
  107. <Style />
  108. </TextRun>
  109. </TextRuns>
  110. <Style />
  111. </Paragraph>
  112. </Paragraphs>
  113. <rd:DefaultName>Number</rd:DefaultName>
  114. <Style>
  115. <Border>
  116. <Color>LightGrey</Color>
  117. <Style>Solid</Style>
  118. </Border>
  119. <PaddingLeft>2pt</PaddingLeft>
  120. <PaddingRight>2pt</PaddingRight>
  121. <PaddingTop>2pt</PaddingTop>
  122. <PaddingBottom>2pt</PaddingBottom>
  123. </Style>
  124. </Textbox>
  125. </CellContents>
  126. </TablixCell>
  127. <TablixCell>
  128. <CellContents>
  129. <Textbox Name="Textbox7">
  130. <CanGrow>true</CanGrow>
  131. <KeepTogether>true</KeepTogether>
  132. <Paragraphs>
  133. <Paragraph>
  134. <TextRuns>
  135. <TextRun>
  136. <Value EvaluationMode="Auto">="Example Text"</Value>
  137. <Style />
  138. </TextRun>
  139. </TextRuns>
  140. <Style />
  141. </Paragraph>
  142. </Paragraphs>
  143. <rd:DefaultName>Textbox7</rd:DefaultName>
  144. <Style>
  145. <Border>
  146. <Color>LightGrey</Color>
  147. <Style>Solid</Style>
  148. </Border>
  149. <PaddingLeft>2pt</PaddingLeft>
  150. <PaddingRight>2pt</PaddingRight>
  151. <PaddingTop>2pt</PaddingTop>
  152. <PaddingBottom>2pt</PaddingBottom>
  153. </Style>
  154. </Textbox>
  155. </CellContents>
  156. </TablixCell>
  157. </TablixCells>
  158. </TablixRow>
  159. </TablixRows>
  160. </TablixBody>
  161. <TablixColumnHierarchy>
  162. <TablixMembers>
  163. <TablixMember />
  164. <TablixMember />
  165. </TablixMembers>
  166. </TablixColumnHierarchy>
  167. <TablixRowHierarchy>
  168. <TablixMembers>
  169. <TablixMember>
  170. <Group Name="Details" />
  171. </TablixMember>
  172. </TablixMembers>
  173. </TablixRowHierarchy>
  174. <DataSetName>DataSet_Result</DataSetName>
  175. <Top>1.04167in</Top>
  176. <Left>2.10292in</Left>
  177. <Height>0.16667in</Height>
  178. <Width>2in</Width>
  179. <Style>
  180. <Border>
  181. <Style>None</Style>
  182. </Border>
  183. </Style>
  184. </Tablix>
  185. <Textbox Name="Textbox8">
  186. <CanGrow>true</CanGrow>
  187. <KeepTogether>true</KeepTogether>
  188. <Paragraphs>
  189. <Paragraph>
  190. <TextRuns>
  191. <TextRun>
  192. <Value EvaluationMode="Auto">="Page1"</Value>
  193. <Style>
  194. <FontWeight>Bold</FontWeight>
  195. </Style>
  196. </TextRun>
  197. </TextRuns>
  198. <Style />
  199. </Paragraph>
  200. </Paragraphs>
  201. <rd:DefaultName>Textbox5</rd:DefaultName>
  202. <Top>0in</Top>
  203. <Left>2.10292in</Left>
  204. <Height>0.25in</Height>
  205. <Width>1in</Width>
  206. <ZIndex>1</ZIndex>
  207. <Style>
  208. <Border>
  209. <Color>LightGrey</Color>
  210. <Style>Solid</Style>
  211. </Border>
  212. <PaddingLeft>2pt</PaddingLeft>
  213. <PaddingRight>2pt</PaddingRight>
  214. <PaddingTop>2pt</PaddingTop>
  215. <PaddingBottom>2pt</PaddingBottom>
  216. </Style>
  217. </Textbox>
  218. <Textbox Name="Textbox9">
  219. <CanGrow>true</CanGrow>
  220. <KeepTogether>true</KeepTogether>
  221. <Paragraphs>
  222. <Paragraph>
  223. <TextRuns>
  224. <TextRun>
  225. <Value EvaluationMode="Auto">="Page1"</Value>
  226. <Style>
  227. <FontWeight>Bold</FontWeight>
  228. </Style>
  229. </TextRun>
  230. </TextRuns>
  231. <Style />
  232. </Paragraph>
  233. </Paragraphs>
  234. <rd:DefaultName>Textbox5</rd:DefaultName>
  235. <Top>0in</Top>
  236. <Left>3.10292in</Left>
  237. <Height>0.25in</Height>
  238. <Width>1in</Width>
  239. <ZIndex>2</ZIndex>
  240. <Style>
  241. <Border>
  242. <Color>LightGrey</Color>
  243. <Style>Solid</Style>
  244. </Border>
  245. <PaddingLeft>2pt</PaddingLeft>
  246. <PaddingRight>2pt</PaddingRight>
  247. <PaddingTop>2pt</PaddingTop>
  248. <PaddingBottom>2pt</PaddingBottom>
  249. </Style>
  250. </Textbox>
  251. <Textbox Name="Textbox10">
  252. <CanGrow>true</CanGrow>
  253. <KeepTogether>true</KeepTogether>
  254. <Paragraphs>
  255. <Paragraph>
  256. <TextRuns>
  257. <TextRun>
  258. <Value EvaluationMode="Auto">="Page1"</Value>
  259. <Style>
  260. <FontWeight>Bold</FontWeight>
  261. </Style>
  262. </TextRun>
  263. </TextRuns>
  264. <Style />
  265. </Paragraph>
  266. </Paragraphs>
  267. <rd:DefaultName>Textbox5</rd:DefaultName>
  268. <Top>0.26389in</Top>
  269. <Left>2.10292in</Left>
  270. <Height>0.25in</Height>
  271. <Width>1in</Width>
  272. <ZIndex>3</ZIndex>
  273. <Style>
  274. <Border>
  275. <Color>LightGrey</Color>
  276. <Style>Solid</Style>
  277. </Border>
  278. <PaddingLeft>2pt</PaddingLeft>
  279. <PaddingRight>2pt</PaddingRight>
  280. <PaddingTop>2pt</PaddingTop>
  281. <PaddingBottom>2pt</PaddingBottom>
  282. </Style>
  283. </Textbox>
  284. <Textbox Name="Textbox11">
  285. <CanGrow>true</CanGrow>
  286. <KeepTogether>true</KeepTogether>
  287. <Paragraphs>
  288. <Paragraph>
  289. <TextRuns>
  290. <TextRun>
  291. <Value EvaluationMode="Auto">="Page1"</Value>
  292. <Style>
  293. <FontWeight>Bold</FontWeight>
  294. </Style>
  295. </TextRun>
  296. </TextRuns>
  297. <Style />
  298. </Paragraph>
  299. </Paragraphs>
  300. <rd:DefaultName>Textbox5</rd:DefaultName>
  301. <Top>0.26389in</Top>
  302. <Left>3.10292in</Left>
  303. <Height>0.25in</Height>
  304. <Width>1in</Width>
  305. <ZIndex>4</ZIndex>
  306. <Style>
  307. <Border>
  308. <Color>LightGrey</Color>
  309. <Style>Solid</Style>
  310. </Border>
  311. <PaddingLeft>2pt</PaddingLeft>
  312. <PaddingRight>2pt</PaddingRight>
  313. <PaddingTop>2pt</PaddingTop>
  314. <PaddingBottom>2pt</PaddingBottom>
  315. </Style>
  316. </Textbox>
  317. <Textbox Name="Textbox12">
  318. <CanGrow>true</CanGrow>
  319. <KeepTogether>true</KeepTogether>
  320. <Paragraphs>
  321. <Paragraph>
  322. <TextRuns>
  323. <TextRun>
  324. <Value EvaluationMode="Auto">="Page1"</Value>
  325. <Style>
  326. <FontWeight>Bold</FontWeight>
  327. </Style>
  328. </TextRun>
  329. </TextRuns>
  330. <Style />
  331. </Paragraph>
  332. </Paragraphs>
  333. <rd:DefaultName>Textbox5</rd:DefaultName>
  334. <Top>0.52778in</Top>
  335. <Left>2.10292in</Left>
  336. <Height>0.25in</Height>
  337. <Width>1in</Width>
  338. <ZIndex>5</ZIndex>
  339. <Style>
  340. <Border>
  341. <Color>LightGrey</Color>
  342. <Style>Solid</Style>
  343. </Border>
  344. <PaddingLeft>2pt</PaddingLeft>
  345. <PaddingRight>2pt</PaddingRight>
  346. <PaddingTop>2pt</PaddingTop>
  347. <PaddingBottom>2pt</PaddingBottom>
  348. </Style>
  349. </Textbox>
  350. <Textbox Name="Textbox13">
  351. <CanGrow>true</CanGrow>
  352. <KeepTogether>true</KeepTogether>
  353. <Paragraphs>
  354. <Paragraph>
  355. <TextRuns>
  356. <TextRun>
  357. <Value EvaluationMode="Auto">="Page1"</Value>
  358. <Style>
  359. <FontWeight>Bold</FontWeight>
  360. </Style>
  361. </TextRun>
  362. </TextRuns>
  363. <Style />
  364. </Paragraph>
  365. </Paragraphs>
  366. <rd:DefaultName>Textbox5</rd:DefaultName>
  367. <Top>0.52778in</Top>
  368. <Left>3.10292in</Left>
  369. <Height>0.25in</Height>
  370. <Width>1in</Width>
  371. <ZIndex>6</ZIndex>
  372. <Style>
  373. <Border>
  374. <Color>LightGrey</Color>
  375. <Style>Solid</Style>
  376. </Border>
  377. <PaddingLeft>2pt</PaddingLeft>
  378. <PaddingRight>2pt</PaddingRight>
  379. <PaddingTop>2pt</PaddingTop>
  380. <PaddingBottom>2pt</PaddingBottom>
  381. </Style>
  382. </Textbox>
  383. <Textbox Name="Textbox14">
  384. <CanGrow>true</CanGrow>
  385. <KeepTogether>true</KeepTogether>
  386. <Paragraphs>
  387. <Paragraph>
  388. <TextRuns>
  389. <TextRun>
  390. <Value EvaluationMode="Auto">="Page1"</Value>
  391. <Style>
  392. <FontWeight>Bold</FontWeight>
  393. </Style>
  394. </TextRun>
  395. </TextRuns>
  396. <Style />
  397. </Paragraph>
  398. </Paragraphs>
  399. <rd:DefaultName>Textbox5</rd:DefaultName>
  400. <Top>0.79167in</Top>
  401. <Left>2.10292in</Left>
  402. <Height>0.25in</Height>
  403. <Width>1in</Width>
  404. <ZIndex>7</ZIndex>
  405. <Style>
  406. <Border>
  407. <Color>LightGrey</Color>
  408. <Style>Solid</Style>
  409. </Border>
  410. <PaddingLeft>2pt</PaddingLeft>
  411. <PaddingRight>2pt</PaddingRight>
  412. <PaddingTop>2pt</PaddingTop>
  413. <PaddingBottom>2pt</PaddingBottom>
  414. </Style>
  415. </Textbox>
  416. <Textbox Name="Textbox15">
  417. <CanGrow>true</CanGrow>
  418. <KeepTogether>true</KeepTogether>
  419. <Paragraphs>
  420. <Paragraph>
  421. <TextRuns>
  422. <TextRun>
  423. <Value EvaluationMode="Auto">="Page1"</Value>
  424. <Style>
  425. <FontWeight>Bold</FontWeight>
  426. </Style>
  427. </TextRun>
  428. </TextRuns>
  429. <Style />
  430. </Paragraph>
  431. </Paragraphs>
  432. <rd:DefaultName>Textbox5</rd:DefaultName>
  433. <Top>0.79167in</Top>
  434. <Left>3.10292in</Left>
  435. <Height>0.25in</Height>
  436. <Width>1in</Width>
  437. <ZIndex>8</ZIndex>
  438. <Style>
  439. <Border>
  440. <Color>LightGrey</Color>
  441. <Style>Solid</Style>
  442. </Border>
  443. <PaddingLeft>2pt</PaddingLeft>
  444. <PaddingRight>2pt</PaddingRight>
  445. <PaddingTop>2pt</PaddingTop>
  446. <PaddingBottom>2pt</PaddingBottom>
  447. </Style>
  448. </Textbox>
  449. </ReportItems>
  450. <Height>1.20834in</Height>
  451. <Style />
  452. </Body>
  453. <Width>8.33209in</Width>
  454. <Page>
  455. <PageHeader>
  456. <Height>0.25in</Height>
  457. <PrintOnFirstPage>true</PrintOnFirstPage>
  458. <PrintOnLastPage>true</PrintOnLastPage>
  459. <ReportItems>
  460. <Textbox Name="Textbox5">
  461. <CanGrow>true</CanGrow>
  462. <KeepTogether>true</KeepTogether>
  463. <Paragraphs>
  464. <Paragraph>
  465. <TextRuns>
  466. <TextRun>
  467. <Value EvaluationMode="Auto">=IIF(Globals!PageNumber = 1,"Page 1","Page after 1")</Value>
  468. <Style>
  469. <FontWeight>Bold</FontWeight>
  470. </Style>
  471. </TextRun>
  472. </TextRuns>
  473. <Style />
  474. </Paragraph>
  475. </Paragraphs>
  476. <rd:DefaultName>Textbox5</rd:DefaultName>
  477. <Top>0in</Top>
  478. <Left>2.10292in</Left>
  479. <Height>0.25in</Height>
  480. <Width>1in</Width>
  481. <Style>
  482. <Border>
  483. <Color>LightGrey</Color>
  484. <Style>Solid</Style>
  485. </Border>
  486. <PaddingLeft>2pt</PaddingLeft>
  487. <PaddingRight>2pt</PaddingRight>
  488. <PaddingTop>2pt</PaddingTop>
  489. <PaddingBottom>2pt</PaddingBottom>
  490. </Style>
  491. </Textbox>
  492. <Textbox Name="Textbox6">
  493. <CanGrow>true</CanGrow>
  494. <KeepTogether>true</KeepTogether>
  495. <Paragraphs>
  496. <Paragraph>
  497. <TextRuns>
  498. <TextRun>
  499. <Value EvaluationMode="Auto">=IIF(Globals!PageNumber = 1,"Page 1","Page after 1")</Value>
  500. <Style>
  501. <FontWeight>Bold</FontWeight>
  502. </Style>
  503. </TextRun>
  504. </TextRuns>
  505. <Style />
  506. </Paragraph>
  507. </Paragraphs>
  508. <rd:DefaultName>Textbox5</rd:DefaultName>
  509. <Top>0in</Top>
  510. <Left>3.10292in</Left>
  511. <Height>0.25in</Height>
  512. <Width>1in</Width>
  513. <ZIndex>1</ZIndex>
  514. <Style>
  515. <Border>
  516. <Color>LightGrey</Color>
  517. <Style>Solid</Style>
  518. </Border>
  519. <PaddingLeft>2pt</PaddingLeft>
  520. <PaddingRight>2pt</PaddingRight>
  521. <PaddingTop>2pt</PaddingTop>
  522. <PaddingBottom>2pt</PaddingBottom>
  523. </Style>
  524. </Textbox>
  525. </ReportItems>
  526. <Style>
  527. <Border>
  528. <Style>None</Style>
  529. </Border>
  530. </Style>
  531. </PageHeader>
  532. <LeftMargin>0in</LeftMargin>
  533. <RightMargin>0in</RightMargin>
  534. <TopMargin>0in</TopMargin>
  535. <BottomMargin>0in</BottomMargin>
  536. <Style />
  537. </Page>
  538. </ReportSection>
  539. </ReportSections>
  540. <Code>Public Function BlankZero(ByVal Value As Decimal)
  541. if Value = 0 then
  542. Return ""
  543. end if
  544. Return Value
  545. End Function
  546.  
  547. Public Function BlankPos(ByVal Value As Decimal)
  548. if Value &gt; 0 then
  549. Return ""
  550. end if
  551. Return Value
  552. End Function
  553.  
  554. Public Function BlankZeroAndPos(ByVal Value As Decimal)
  555. if Value &gt;= 0 then
  556. Return ""
  557. end if
  558. Return Value
  559. End Function
  560.  
  561. Public Function BlankNeg(ByVal Value As Decimal)
  562. if Value &lt; 0 then
  563. Return ""
  564. end if
  565. Return Value
  566. End Function
  567.  
  568. Public Function BlankNegAndZero(ByVal Value As Decimal)
  569. if Value &lt;= 0 then
  570. Return ""
  571. end if
  572. Return Value
  573. End Function
  574.  
  575. Shared TotalAmountPageFlag As Integer
  576. Public Function SetTotalAmountAlreadyShown(ByVal val As Integer)
  577. if val = 1 then
  578. TotalAmountPageFlag=val
  579. end if
  580. Return TotalAmountPageFlag
  581. End Function
  582.  
  583. Public Function GetTotalAmountAlreadyShown() As Integer
  584. Return TotalAmountPageFlag
  585. End Function</Code>
  586. <Language>=User!Language</Language>
  587. <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
  588. <rd:ReportUnitType>Inch</rd:ReportUnitType>
  589. <rd:ReportID>0eeb6585-38ae-40f1-885b-8d50088d51b4</rd:ReportID>
  590. </Report>
  591. END_OF_RDLDATA
  592. }
  593. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement