Guest User

Untitled

a guest
Nov 8th, 2019
72
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. OBJECT Report 50000 tmp Header
  2. {
  3. OBJECT-PROPERTIES
  4. {
  5. Date=08.11.19;
  6. Time=13:09:48;
  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>0.25in</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. </TextRun>
  195. </TextRuns>
  196. <Style />
  197. </Paragraph>
  198. </Paragraphs>
  199. <rd:DefaultName>Textbox5</rd:DefaultName>
  200. <Top>0in</Top>
  201. <Left>2.10292in</Left>
  202. <Height>0.25in</Height>
  203. <Width>1in</Width>
  204. <ZIndex>1</ZIndex>
  205. <Style>
  206. <Border>
  207. <Color>LightGrey</Color>
  208. <Style>Solid</Style>
  209. </Border>
  210. <PaddingLeft>2pt</PaddingLeft>
  211. <PaddingRight>2pt</PaddingRight>
  212. <PaddingTop>2pt</PaddingTop>
  213. <PaddingBottom>2pt</PaddingBottom>
  214. </Style>
  215. </Textbox>
  216. <Textbox Name="Textbox9">
  217. <CanGrow>true</CanGrow>
  218. <KeepTogether>true</KeepTogether>
  219. <Paragraphs>
  220. <Paragraph>
  221. <TextRuns>
  222. <TextRun>
  223. <Value EvaluationMode="Auto">="Page1"</Value>
  224. <Style />
  225. </TextRun>
  226. </TextRuns>
  227. <Style />
  228. </Paragraph>
  229. </Paragraphs>
  230. <rd:DefaultName>Textbox5</rd:DefaultName>
  231. <Top>0in</Top>
  232. <Left>3.10292in</Left>
  233. <Height>0.25in</Height>
  234. <Width>1in</Width>
  235. <ZIndex>2</ZIndex>
  236. <Style>
  237. <Border>
  238. <Color>LightGrey</Color>
  239. <Style>Solid</Style>
  240. </Border>
  241. <PaddingLeft>2pt</PaddingLeft>
  242. <PaddingRight>2pt</PaddingRight>
  243. <PaddingTop>2pt</PaddingTop>
  244. <PaddingBottom>2pt</PaddingBottom>
  245. </Style>
  246. </Textbox>
  247. </ReportItems>
  248. <Height>1.29042in</Height>
  249. <Style />
  250. </Body>
  251. <Width>8.33209in</Width>
  252. <Page>
  253. <PageHeader>
  254. <Height>0.25in</Height>
  255. <PrintOnFirstPage>true</PrintOnFirstPage>
  256. <PrintOnLastPage>true</PrintOnLastPage>
  257. <ReportItems>
  258. <Textbox Name="Textbox5">
  259. <CanGrow>true</CanGrow>
  260. <KeepTogether>true</KeepTogether>
  261. <Paragraphs>
  262. <Paragraph>
  263. <TextRuns>
  264. <TextRun>
  265. <Value EvaluationMode="Auto">=IIF(Globals!PageNumber = 1,"Page 1","Page after 1")</Value>
  266. <Style />
  267. </TextRun>
  268. </TextRuns>
  269. <Style />
  270. </Paragraph>
  271. </Paragraphs>
  272. <rd:DefaultName>Textbox5</rd:DefaultName>
  273. <Top>0in</Top>
  274. <Left>2.10292in</Left>
  275. <Height>0.25in</Height>
  276. <Width>1in</Width>
  277. <Style>
  278. <Border>
  279. <Color>LightGrey</Color>
  280. <Style>Solid</Style>
  281. </Border>
  282. <PaddingLeft>2pt</PaddingLeft>
  283. <PaddingRight>2pt</PaddingRight>
  284. <PaddingTop>2pt</PaddingTop>
  285. <PaddingBottom>2pt</PaddingBottom>
  286. </Style>
  287. </Textbox>
  288. <Textbox Name="Textbox6">
  289. <CanGrow>true</CanGrow>
  290. <KeepTogether>true</KeepTogether>
  291. <Paragraphs>
  292. <Paragraph>
  293. <TextRuns>
  294. <TextRun>
  295. <Value EvaluationMode="Auto">=IIF(Globals!PageNumber = 1,"Page 1","Page after 1")</Value>
  296. <Style />
  297. </TextRun>
  298. </TextRuns>
  299. <Style />
  300. </Paragraph>
  301. </Paragraphs>
  302. <rd:DefaultName>Textbox5</rd:DefaultName>
  303. <Top>0in</Top>
  304. <Left>3.10292in</Left>
  305. <Height>0.25in</Height>
  306. <Width>1in</Width>
  307. <ZIndex>1</ZIndex>
  308. <Style>
  309. <Border>
  310. <Color>LightGrey</Color>
  311. <Style>Solid</Style>
  312. </Border>
  313. <PaddingLeft>2pt</PaddingLeft>
  314. <PaddingRight>2pt</PaddingRight>
  315. <PaddingTop>2pt</PaddingTop>
  316. <PaddingBottom>2pt</PaddingBottom>
  317. </Style>
  318. </Textbox>
  319. </ReportItems>
  320. <Style>
  321. <Border>
  322. <Style>None</Style>
  323. </Border>
  324. </Style>
  325. </PageHeader>
  326. <LeftMargin>0in</LeftMargin>
  327. <RightMargin>0in</RightMargin>
  328. <TopMargin>0in</TopMargin>
  329. <BottomMargin>0in</BottomMargin>
  330. <Style />
  331. </Page>
  332. </ReportSection>
  333. </ReportSections>
  334. <Code>Public Function BlankZero(ByVal Value As Decimal)
  335. if Value = 0 then
  336. Return ""
  337. end if
  338. Return Value
  339. End Function
  340.  
  341. Public Function BlankPos(ByVal Value As Decimal)
  342. if Value &gt; 0 then
  343. Return ""
  344. end if
  345. Return Value
  346. End Function
  347.  
  348. Public Function BlankZeroAndPos(ByVal Value As Decimal)
  349. if Value &gt;= 0 then
  350. Return ""
  351. end if
  352. Return Value
  353. End Function
  354.  
  355. Public Function BlankNeg(ByVal Value As Decimal)
  356. if Value &lt; 0 then
  357. Return ""
  358. end if
  359. Return Value
  360. End Function
  361.  
  362. Public Function BlankNegAndZero(ByVal Value As Decimal)
  363. if Value &lt;= 0 then
  364. Return ""
  365. end if
  366. Return Value
  367. End Function
  368.  
  369. Shared TotalAmountPageFlag As Integer
  370. Public Function SetTotalAmountAlreadyShown(ByVal val As Integer)
  371. if val = 1 then
  372. TotalAmountPageFlag=val
  373. end if
  374. Return TotalAmountPageFlag
  375. End Function
  376.  
  377. Public Function GetTotalAmountAlreadyShown() As Integer
  378. Return TotalAmountPageFlag
  379. End Function</Code>
  380. <Language>=User!Language</Language>
  381. <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
  382. <rd:ReportUnitType>Inch</rd:ReportUnitType>
  383. <rd:ReportID>0eeb6585-38ae-40f1-885b-8d50088d51b4</rd:ReportID>
  384. </Report>
  385. END_OF_RDLDATA
  386. }
  387. }
RAW Paste Data