{"id":351,"date":"2007-12-30T21:46:28","date_gmt":"2007-12-31T04:46:28","guid":{"rendered":"http:\/\/members.crystalreportsbook.com\/crystal-reports-xi\/b-2-data-types-and-variables\/"},"modified":"2007-12-30T21:46:28","modified_gmt":"2007-12-31T04:46:28","slug":"b-2-data-types-and-variables","status":"publish","type":"post","link":"http:\/\/www.crystalreportsonlinetraining.com\/training\/b-2-data-types-and-variables\/","title":{"rendered":"B. 2 Data Types and Variables"},"content":{"rendered":"

Simple Data Types<\/h2>\n

Basic syntax uses the same data types as Crystal syntax. However, the naming convention varies slightly. In Crystal syntax all data type have “Var” at the end (e.g. NumberVar, StringVar, etc.) Basic syntax doesn’t use the “Var” suffix after each data type. It simple uses the data type name by itself: Boolean, Number, Currency, String, DateTime, Date, and Time.<\/p>\n

Declaring Variables<\/h2>\n

To use a variable in a formula, you first have to declare it. This consists of giving it a name and specifying its data type. Declaring a variable follows the format of declaring the variable using the Dim keyword followed by the variable name. Use the As keyword to specify the data type.<\/p>\n

Dim var As dataype<\/code_Single><\/p>\n

Just like Crystal syntax, there are three keywords for setting a variable’s scope (whether other formulas can reference it): Dim, Global, and Shared.<\/p>\n

Dim: The variable can only be seen within the current formula. The variable is private to that formula and can’t be used anywhere else in the report. This is the default scope if you don’t specify it.<\/p>\n

Global: The variable can be seen within any formula inside the same report. Sub-reports do not have access to the variable.<\/p>\n

Shared: Similar to Global, but the variable can also be seen within sub-reports.<\/p>\n

Dim HireDate As Date<\/code_Single>
\n Shared AffiliateCities() As String<\/code_Single><\/p>\n

Variable Assignment<\/h2>\n

In Basic syntax, to assign a value constant to a variable use the equal sign.<\/p>\n

X = 5<\/code_Single>
\n Y = “Mr. ” & {Customer.Last Name}<\/code_Single><\/p>\n","protected":false},"excerpt":{"rendered":"

Simple Data Types Basic syntax uses the same data types as Crystal syntax. However, the naming convention varies slightly. In Crystal syntax all data type have “Var” at the end (e.g. NumberVar, StringVar, etc.) Basic syntax doesn’t use the “Var” suffix after each data type. It simple uses the data type name by itself: Boolean, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,1],"tags":[],"class_list":["post-351","post","type-post","status-publish","format-standard","hentry","category-appendix-b-basic-syntax-reference","category-crystal-reports-xi","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":0,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}