Using System Parameters for Ginesys Web Reports
A Parameter may be defined as a numerical or other measurable factor forming one of a set that defines a system or sets the conditions of its operation. In GINESYS Reports, a parameter can be used to gain pre-defined values.
Conditions for defining Parameter Names:
- Parameters are case sensitive (pageNumber is not the same as pagenumber).
- Parameter names can not contain the '@' symbol.
Full Description of Parameters
| Parameter Name | Description | Example |
|---|---|---|
| pageNumber: | Returns the number of the current page. For RTF output, pageNumber cannot be used with other formulas. NOTE: Does not work with chained reports. | Example =@pageNumber@ will display the current page number for all output types. ='pg. ' & @pageNumber@ will display 'pg.' followed by the page number for default and PDF outputs. |
| reportName: | Returns the name of the report. | |
| reportFullName: | Returns the file path of the report. | Example For a report named Transcripts in a Folder named Student Documents, @reportFullName@ would return Student Documents/Transcripts. |
The following System parameters can be used by the GINESYS Reports module users.
Note: Parameter can be used in any report in any section, using the form @ExactParametername@. Parameter name is case-sensitive. | |
| Parameter Name | Description |
| AmountDisplayFormat | This will show all the amount in desired format, to be used in conjunction with FormatAmount() custom function. |
| BaseCurrencySymbol | This will show the currency symbol of base currency mentioned in currency master |
| BaseCurrencyShortCode | This will show the currency short code of base currency mentioned in currency master |
| BaseCurrencyDecimalSymbol | This will show the currency decimal symbol of base currency mentioned in currency master. i.e paise |
| BaseCurrencyName | This will show the currency name of base currency mentioned in currency master |
| CurrentWorkDate | This will show the Working Date, in which user is logged in |
| CurrentFiscalYear | This will show the Fiscal year name as specified in Accounting Period Master |
| LoginUser | This will show the Full Name of the Logged in user |
| DTFR | This will show the Begin Date of Current Fiscal Year |
| DTTO | This will show the Working Date, in which user is logged in |
| ConnSiteCode | This will show the internal code of Connected Site |
| ConnSiteName | This will show the Name of Connected Site |
| ConnSiteShortName | This will show the Short Name of Connected Site |
| ConnSiteAddress | This will show the Address of Connected Site |
| ConnSiteCity | This will show the City Name of Connected Site |
| ConnSitePin | This will show the PIN of Connected Site |
| ConnSiteContactPerson | This will show the Contact Person of Connected Site |
| ConnSiteMobile | This will show the Mobile of Connected Site |
| ConnSitePhone1 | This will show the Phone1 of Connected Site |
| ConnSitePhone2 | This will show the Phone2 of Connected Site |
| ConnSitePhone3 | This will show the Phone3 of Connected Site |
| ConnSiteEmail | This will show the Email of Connected Site |
| ConnSiteWebsite | This will show the Website of Connected Site |
| ConnSiteLSTNo | This will show the LST Number of Connected Site |
| ConnSiteLSTDate | This will show the LST Date of Connected Site |
| ConnSiteCSTNo | This will show the CST Number of Connected Site |
| ConnSiteCSTDate | This will show the CST Date of Connected Site |
| OrgName | This will show the Name of the Organization Group |
| OrgShortName | This will show the Short Name of the Organization Group |
| OrgAddress | This will show the Address of the Organization Group |
| OrgCity | This will show the City Name of the Organization Group |
| OrgPin | This will show the PIN of the Organization Group |
| OrgPhone1 | This will show the Phone1 of the Organization Group |
| OrgPhone2 | This will show the Phone2 of the Organization Group |
| OrgPhone3 | This will show the Phone3 of the Organization Group |
| OrgEmail | This will show the Email of the Organization Group |
| OrgWebsite | This will show the Website of the Organization Group |
| OrgLSTNo | This will show the LST Number of the Organization Group |
| OrgCSTNo | This will show the CST Number of the Organization Group |
| OrgCINNo | This will show the CIN Number of the Organization Group |
| OrgITNo | This will show the IT Number of the Organization Group |
| OrgTANNo | This will show the TAN Number of the Organization Group |
| OrgTANWard | This will show the TAN Ward of the Organization Group |
| OrgTLNo | This will show the TL Number of the Organization Group |
| OrgServiceTaxNo | This will show the Service Tax Number of the Organization Group |
| OrgServiceTaxDate | This will show the Service Tax Date of the Organization Group |
| CompanyLogoPath | Internal Hidden System Parameter. Not to be used in any report |
| OrgId | This will show the internal code of Organization Group |
| ConnOUCode | This will show the internal code of Organization Unit |
| ConnOUName | This will show the Name of the Organization Unit |
| ConnOUShortName | This will show the Short Name of the Organization Unit |
| ConnOUAddress | This will show the Address of the Organization Unit |
| ConnOUCity | This will show the City Name of the Organization Unit |
| ConnOUPin | This will show the PIN of the Organization Unit |
| ConnOUPhone1 | This will show the Phone1 of the Organization Unit |
| ConnOUPhone2 | This will show the Phone2 of the Organization Unit |
| ConnOUPhone3 | This will show the Phone3 of the Organization Unit |
| ConnOUMobile | This will show the Mobile of the Organization Unit |
| ConnOUEmail | This will show the Email of the Organization Unit |
| ConnOUWebsite | This will show the Website of the Organization Unit |
| ConnOULSTNo | This will show the LST Number of the Organization Unit |
| ConnOUCSTNo | This will show the CST Number of the Organization Unit |
| ExecutingSQL | This will show the currently executed SQL query for the report. |
| ImageURL | This will show the configured path in GINESYS Application Server for showing Images. [Check IIS : GinesysImage App Pool] |
| ReportTitle | This will show the user defined Report title specified in Report Template association with Menu |
| ReportHeader | This will show the user defined Report Header specified in Report Template association with Menu |
| ReportFooter | This will show the user defined Report Footer specified in Report Template association with Menu |
| DocumentId | Internal Hidden System Parameter. Not to be used in any report |
| executeFromApp | Internal Hidden System Parameter. Not to be used in any report |
| IncludeUnpostedRecords | Internal Hidden System Parameter. Not to be used in any report |
| IncludeZeroBalanceRecords | Internal Hidden System Parameter. Not to be used in any report |
| OpeningOnly | Internal Hidden System Parameter. Not to be used in any report |
| roleId | Internal Hidden System Parameter. Not to be used in any report |
| userId | Internal Hidden System Parameter. Not to be used in any report |
| yearList | Internal Hidden System Parameter. Not to be used in any report |