ReportBuilder Miscellaneous

From Team Developer SqlWindows Wiki
Revision as of 10:08, 4 September 2013 by DaveRabelink (Talk | contribs)

Jump to: navigation, search

Report Builder


Pointer2.png How to insert Word/Excel objects into QRP reports Pointer.png

When you have a table in Excel or a formatted copyright text in Word for example and would like to re-use that
in a QRP report, one way to do this is to create a screenshot of the part in Excel or Word, save this as an image and show it
as a picture object in the QRP report.
The quality is not really great inside the QRP though. It is not crisp and could be blurry.

With this trick you are able to insert parts of Word/Excel into a QRP.
This is not only easier to do, but the result has a great quality.

Example of some formatted text in Word and in Excel:


Select the part in Word or Excel you want to use in the QRP.
Copy this to clipboard (CTRL-C)


In Report Builder, drop a picture object in the report


Select the picture object and paste (CTRL-V) the clipboard contents into the report.
Then you will get the part pasted into the report. The original picture object is still there which you
can reuse to paste other stuff from Word or Excel.
Remove the original picture object from the report, the pasted ones are new objects.


Resizing the pasted objects will result in a much better quality compared to image resizing.

Pointer2.png ReportWindows RoundUp formula Pointer.png

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)) ,
   (NumberTruncate(nInput,0)) + 1)

Pointer2.png Report Builder can not find SQL.ini Pointer.png

When starting Report Builder, it could happen that this error message pops up:

RB SqlIni NotFoundError.png

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:

RB Registry SqlIniPath.png

Report Builder then closes.

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).

Pointer2.png Report Builder Enterprise setup (EDP) Pointer.png

When installing Report Builder, it asks for the PMC code and needs activation over internet.
For single installations, this is not a great issue. But in some organizations, which create own setups and need
to install multiple Report Builder instances on several workstations this may become an issue.

A problem can be that the installation should be silent and after installation ready to go, without any registration.
Or the workstations do not have a live internet connection, which makes it impossible to activate Report Builder.

Gupta has a solution for this : Report Builder Enterprise (EDP) setup.

It can be ordered through the resellers in packs of multiple Report Builder licenses.
There is a minimum number of seats you have to order.

When having the EDP, the setup allows you to distribute Report Builder with a valid EDP license which can be
integrated into custom setups or even with manual copy.
The need for PMC and activation is not needed in this case.

For more info, contact Gupta or the reseller about Report Builder EDP solution.