We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!
We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!
Using System Parameters for Ginesys Web Reports
- Aparajita Basu Roy
- Subhasree Banerjee (Unlicensed)
Owned by Aparajita Basu Roy
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 |