Difference between revisions of "ReportBuilder Miscellaneous"
DaveRabelink (Talk | contribs) (Added tip on Report Builder can not find SQL.ini) |
|||
| Line 1: | Line 1: | ||
| − | + | {{PageHeader|Report Builder}} | |
| + | |||
__TOC__ | __TOC__ | ||
| − | + | ||
<!------------------------------------------------------------------------------------------------------------------------------> | <!------------------------------------------------------------------------------------------------------------------------------> | ||
| Line 8: | Line 9: | ||
| − | Returns any decimalised number rounded UP to the nearest whole. | + | Returns any decimalised number rounded UP to the nearest whole.<br> |
| − | UnDecimalised input is returned un-rounded. | + | UnDecimalised input is returned un-rounded.<br> |
| − | Allocates no memory for efficiency. | + | Allocates no memory for efficiency.<br> |
eg 2.2 becomes 3, 2.9 becomes 3 , 2 stays as 2 | eg 2.2 becomes 3, 2.9 becomes 3 , 2 stays as 2 | ||
| − | + | <pre> | |
| − | NumberIFF( nInput - (NumberTruncate(nInput,0)) , | + | NumberIFF( nInput - (NumberTruncate(nInput,0)) , |
| − | nInput, | + | nInput, |
| − | nInput, | + | nInput, |
| − | (NumberTruncate(nInput,0)) + 1) | + | (NumberTruncate(nInput,0)) + 1) |
</pre> | </pre> | ||
| + | |||
| + | |||
| + | <!------------------------------------------------------------------------------------------------------------------------------> | ||
| + | {{TipHeader|Report Builder can not find SQL.ini}} | ||
| + | When starting Report Builder, it could happen that this error message pops up:<br> | ||
| + | |||
| + | |||
| + | [[image:RB_SqlIni_NotFoundError.png]] | ||
| + | |||
| + | |||
| + | When checking the location of the SQL.ini, there seems nothing wrong.<br> | ||
| + | The file is located in the same folder Report Builder is installed in or in a folder<br> | ||
| + | which is part of the PATH environment variable.<br> | ||
| + | |||
| + | |||
| + | A reason you can check:<br> | ||
| + | |||
| + | |||
| + | When Report Builder is installed, it creates entries in the registry.<br> | ||
| + | Below a screenshot of the registry which holds the clue:<br> | ||
| + | |||
| + | |||
| + | [[image:RB_Registry_SqlIniPath.png]] | ||
| + | |||
| + | |||
| + | In the registry (location = <b>"HKEY_CURRENT_USER\Software\Unify\ReportBuilder 6.1\"</b>) there is a setting<br> | ||
| + | for the SQL.ini. When this setting is present, Report Builder does not look for the SQL.ini in the PATH or current install folder<br> | ||
| + | but it looks in the folder defined with this key:<br> | ||
| + | |||
| + | <pre> | ||
| + | HKEY_CURRENT_USER\Software\Unify\ReportBuilder 6.1\Settings\INIFilePath | ||
| + | </pre> | ||
| + | |||
| + | |||
| + | When you remove this key (or rename it, eg to INIFilePath_OLD) Report Builder will look in the current install folder or PATH<br> | ||
| + | for the SQL.ini. You can also change manually the path to SQL.ini in the registry key when you need a fixed location.<br> | ||
| + | |||
| + | |||
| + | Look for the right location in the registry. The example above is for TD 6.1. So for other TD versions, use the corresponding TD version number.<br> | ||
| + | (Also the subfolder could be Gupta instead of Unify, depending on the TD version).<br> | ||
| + | <br> | ||
Revision as of 14:53, 12 July 2013
Report Builder
Contents |
ReportWindows RoundUp formula 
Returns any decimalised number rounded UP to the nearest whole.
UnDecimalised input is returned un-rounded.
Allocates no memory for efficiency.
eg 2.2 becomes 3, 2.9 becomes 3 , 2 stays as 2
NumberIFF( nInput - (NumberTruncate(nInput,0)) , nInput, nInput, (NumberTruncate(nInput,0)) + 1)
Report Builder can not find SQL.ini
When starting Report Builder, it could happen that this error message pops up:
When checking the location of the SQL.ini, there seems nothing wrong.
The file is located in the same folder Report Builder is installed in or in a folder
which is part of the PATH environment variable.
A reason you can check:
When Report Builder is installed, it creates entries in the registry.
Below a screenshot of the registry which holds the clue:
In the registry (location = "HKEY_CURRENT_USER\Software\Unify\ReportBuilder 6.1\") there is a setting
for the SQL.ini. When this setting is present, Report Builder does not look for the SQL.ini in the PATH or current install folder
but it looks in the folder defined with this key:
HKEY_CURRENT_USER\Software\Unify\ReportBuilder 6.1\Settings\INIFilePath
When you remove this key (or rename it, eg to INIFilePath_OLD) Report Builder will look in the current install folder or PATH
for the SQL.ini. You can also change manually the path to SQL.ini in the registry key when you need a fixed location.
Look for the right location in the registry. The example above is for TD 6.1. So for other TD versions, use the corresponding TD version number.
(Also the subfolder could be Gupta instead of Unify, depending on the TD version).
