Guest User

Untitled

a guest
Nov 6th, 2019
99
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=06.11.19;
  6. Time=12:00:00;
  7. Version List=;
  8. }
  9. PROPERTIES
  10. {
  11. PreviewMode=PrintLayout;
  12. }
  13. DATASET
  14. {
  15. { 1000000000;;DataItem;Loop ;
  16. DataItemTable=Table2000000026;
  17. DataItemTableView=SORTING(Number);
  18. OnPreDataItem=BEGIN
  19. SETRANGE(Number,1,300);
  20. END;
  21. }
  22.  
  23. { 1000000001;1;Column;Number ;
  24. SourceExpr=Number }
  25.  
  26. }
  27. REQUESTPAGE
  28. {
  29. PROPERTIES
  30. {
  31. }
  32. CONTROLS
  33. {
  34. }
  35. }
  36. LABELS
  37. {
  38. }
  39. CODE
  40. {
  41.  
  42. BEGIN
  43. END.
  44. }
  45. RDLDATA
  46. {
  47. <?xml version="1.0" encoding="utf-8"?>
  48. <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">
  49. <AutoRefresh>0</AutoRefresh>
  50. <DataSources>
  51. <DataSource Name="DataSource">
  52. <ConnectionProperties>
  53. <DataProvider>SQL</DataProvider>
  54. <ConnectString />
  55. </ConnectionProperties>
  56. <rd:SecurityType>None</rd:SecurityType>
  57. <rd:DataSourceID>45159f8d-aa21-4c1c-bee7-e05acc7fd953</rd:DataSourceID>
  58. </DataSource>
  59. </DataSources>
  60. <DataSets>
  61. <DataSet Name="DataSet_Result">
  62. <Query>
  63. <DataSourceName>DataSource</DataSourceName>
  64. <CommandText />
  65. </Query>
  66. <Fields>
  67. <Field Name="Number">
  68. <DataField>Number</DataField>
  69. </Field>
  70. </Fields>
  71. <rd:DataSetInfo>
  72. <rd:DataSetName>DataSet</rd:DataSetName>
  73. <rd:SchemaPath>Report.xsd</rd:SchemaPath>
  74. <rd:TableName>Result</rd:TableName>
  75. </rd:DataSetInfo>
  76. </DataSet>
  77. </DataSets>
  78. <ReportSections>
  79. <ReportSection>
  80. <Body>
  81. <ReportItems>
  82. <Tablix Name="Tablix1">
  83. <TablixBody>
  84. <TablixColumns>
  85. <TablixColumn>
  86. <Width>1in</Width>
  87. </TablixColumn>
  88. <TablixColumn>
  89. <Width>1in</Width>
  90. </TablixColumn>
  91. </TablixColumns>
  92. <TablixRows>
  93. <TablixRow>
  94. <Height>0.16667in</Height>
  95. <TablixCells>
  96. <TablixCell>
  97. <CellContents>
  98. <Textbox Name="Number">
  99. <CanGrow>true</CanGrow>
  100. <KeepTogether>true</KeepTogether>
  101. <Paragraphs>
  102. <Paragraph>
  103. <TextRuns>
  104. <TextRun>
  105. <Value EvaluationMode="Auto">=Fields!Number.Value</Value>
  106. <Style />
  107. </TextRun>
  108. </TextRuns>
  109. <Style />
  110. </Paragraph>
  111. </Paragraphs>
  112. <rd:DefaultName>Number</rd:DefaultName>
  113. <Style>
  114. <Border>
  115. <Color>LightGrey</Color>
  116. <Style>Solid</Style>
  117. </Border>
  118. <PaddingLeft>2pt</PaddingLeft>
  119. <PaddingRight>2pt</PaddingRight>
  120. <PaddingTop>2pt</PaddingTop>
  121. <PaddingBottom>2pt</PaddingBottom>
  122. </Style>
  123. </Textbox>
  124. </CellContents>
  125. </TablixCell>
  126. <TablixCell>
  127. <CellContents>
  128. <Textbox Name="Textbox7">
  129. <CanGrow>true</CanGrow>
  130. <KeepTogether>true</KeepTogether>
  131. <Paragraphs>
  132. <Paragraph>
  133. <TextRuns>
  134. <TextRun>
  135. <Value EvaluationMode="Auto">="Example Text"</Value>
  136. <Style />
  137. </TextRun>
  138. </TextRuns>
  139. <Style />
  140. </Paragraph>
  141. </Paragraphs>
  142. <rd:DefaultName>Textbox7</rd:DefaultName>
  143. <Style>
  144. <Border>
  145. <Color>LightGrey</Color>
  146. <Style>Solid</Style>
  147. </Border>
  148. <PaddingLeft>2pt</PaddingLeft>
  149. <PaddingRight>2pt</PaddingRight>
  150. <PaddingTop>2pt</PaddingTop>
  151. <PaddingBottom>2pt</PaddingBottom>
  152. </Style>
  153. </Textbox>
  154. </CellContents>
  155. </TablixCell>
  156. </TablixCells>
  157. </TablixRow>
  158. </TablixRows>
  159. </TablixBody>
  160. <TablixColumnHierarchy>
  161. <TablixMembers>
  162. <TablixMember />
  163. <TablixMember />
  164. </TablixMembers>
  165. </TablixColumnHierarchy>
  166. <TablixRowHierarchy>
  167. <TablixMembers>
  168. <TablixMember>
  169. <Group Name="Details" />
  170. </TablixMember>
  171. </TablixMembers>
  172. </TablixRowHierarchy>
  173. <DataSetName>DataSet_Result</DataSetName>
  174. <Top>0in</Top>
  175. <Left>2.10292in</Left>
  176. <Height>0.16667in</Height>
  177. <Width>2in</Width>
  178. <Style>
  179. <Border>
  180. <Style>None</Style>
  181. </Border>
  182. </Style>
  183. </Tablix>
  184. </ReportItems>
  185. <Height>1.29042in</Height>
  186. <Style />
  187. </Body>
  188. <Width>8.33209in</Width>
  189. <Page>
  190. <PageHeader>
  191. <Height>0.25in</Height>
  192. <PrintOnFirstPage>true</PrintOnFirstPage>
  193. <PrintOnLastPage>true</PrintOnLastPage>
  194. <ReportItems>
  195. <Textbox Name="Textbox5">
  196. <CanGrow>true</CanGrow>
  197. <KeepTogether>true</KeepTogether>
  198. <Paragraphs>
  199. <Paragraph>
  200. <TextRuns>
  201. <TextRun>
  202. <Value EvaluationMode="Auto">=IIF(Globals!PageNumber = 1,"Page 1","Page after 1")</Value>
  203. <Style />
  204. </TextRun>
  205. </TextRuns>
  206. <Style />
  207. </Paragraph>
  208. </Paragraphs>
  209. <rd:DefaultName>Textbox5</rd:DefaultName>
  210. <Top>0in</Top>
  211. <Left>2.10292in</Left>
  212. <Height>0.25in</Height>
  213. <Width>1in</Width>
  214. <Style>
  215. <Border>
  216. <Color>LightGrey</Color>
  217. <Style>Solid</Style>
  218. </Border>
  219. <PaddingLeft>2pt</PaddingLeft>
  220. <PaddingRight>2pt</PaddingRight>
  221. <PaddingTop>2pt</PaddingTop>
  222. <PaddingBottom>2pt</PaddingBottom>
  223. </Style>
  224. </Textbox>
  225. <Textbox Name="Textbox6">
  226. <CanGrow>true</CanGrow>
  227. <KeepTogether>true</KeepTogether>
  228. <Paragraphs>
  229. <Paragraph>
  230. <TextRuns>
  231. <TextRun>
  232. <Value EvaluationMode="Auto">=IIF(Globals!PageNumber = 1,"Page 1","Page after 1")</Value>
  233. <Style />
  234. </TextRun>
  235. </TextRuns>
  236. <Style />
  237. </Paragraph>
  238. </Paragraphs>
  239. <rd:DefaultName>Textbox5</rd:DefaultName>
  240. <Top>0in</Top>
  241. <Left>3.10292in</Left>
  242. <Height>0.25in</Height>
  243. <Width>1in</Width>
  244. <ZIndex>1</ZIndex>
  245. <Style>
  246. <Border>
  247. <Color>LightGrey</Color>
  248. <Style>Solid</Style>
  249. </Border>
  250. <PaddingLeft>2pt</PaddingLeft>
  251. <PaddingRight>2pt</PaddingRight>
  252. <PaddingTop>2pt</PaddingTop>
  253. <PaddingBottom>2pt</PaddingBottom>
  254. </Style>
  255. </Textbox>
  256. </ReportItems>
  257. <Style>
  258. <Border>
  259. <Style>None</Style>
  260. </Border>
  261. </Style>
  262. </PageHeader>
  263. <LeftMargin>0in</LeftMargin>
  264. <RightMargin>0in</RightMargin>
  265. <TopMargin>0in</TopMargin>
  266. <BottomMargin>0in</BottomMargin>
  267. <Style />
  268. </Page>
  269. </ReportSection>
  270. </ReportSections>
  271. <Code>Public Function BlankZero(ByVal Value As Decimal)
  272. if Value = 0 then
  273. Return ""
  274. end if
  275. Return Value
  276. End Function
  277.  
  278. Public Function BlankPos(ByVal Value As Decimal)
  279. if Value &gt; 0 then
  280. Return ""
  281. end if
  282. Return Value
  283. End Function
  284.  
  285. Public Function BlankZeroAndPos(ByVal Value As Decimal)
  286. if Value &gt;= 0 then
  287. Return ""
  288. end if
  289. Return Value
  290. End Function
  291.  
  292. Public Function BlankNeg(ByVal Value As Decimal)
  293. if Value &lt; 0 then
  294. Return ""
  295. end if
  296. Return Value
  297. End Function
  298.  
  299. Public Function BlankNegAndZero(ByVal Value As Decimal)
  300. if Value &lt;= 0 then
  301. Return ""
  302. end if
  303. Return Value
  304. End Function
  305.  
  306. Shared TotalAmountPageFlag As Integer
  307. Public Function SetTotalAmountAlreadyShown(ByVal val As Integer)
  308. if val = 1 then
  309. TotalAmountPageFlag=val
  310. end if
  311. Return TotalAmountPageFlag
  312. End Function
  313.  
  314. Public Function GetTotalAmountAlreadyShown() As Integer
  315. Return TotalAmountPageFlag
  316. End Function</Code>
  317. <Language>=User!Language</Language>
  318. <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
  319. <rd:ReportUnitType>Inch</rd:ReportUnitType>
  320. <rd:ReportID>0eeb6585-38ae-40f1-885b-8d50088d51b4</rd:ReportID>
  321. </Report>
  322. END_OF_RDLDATA
  323. }
  324. }
RAW Paste Data