I have made a simple utility, that formats all reports in a folder (and) sub-folders as well. The purpose of this command line utility is to make the report width adjusted for printing.
It is written on VB .NET 2008 using express (Free) edition.
The BORF (Business Objects Report Formater :-) ) is taking 3 arguments
1. Target Path (e.g C:\Business Objects Pubication\ )
2. File pattern (e.g *.xls )
3. Include Sub-directories (Y/N)
Arguments are separated by space e.g:
BORF C:\temp *.xls Y
In the particular project we have a publication of around 1000 reports as XLS. Managers wanted the reports ready for printing. That is one button print without any modifications at the provided excel files.
Codding its not my forte so don't be harsh on me :roll:
Feel free to check it and provide changes.
Download From BOB Forums
p.s: I have combined the above with an excellent renaming utility in order to get rid of the instance ID on the published documents name. The command line utility BRC its free and can be found here http://www.bulkrenameutility.co.uk/Command.php
It is written on VB .NET 2008 using express (Free) edition.
The BORF (Business Objects Report Formater :-) ) is taking 3 arguments
1. Target Path (e.g C:\Business Objects Pubication\ )
2. File pattern (e.g *.xls )
3. Include Sub-directories (Y/N)
Arguments are separated by space e.g:
BORF C:\temp *.xls Y
In the particular project we have a publication of around 1000 reports as XLS. Managers wanted the reports ready for printing. That is one button print without any modifications at the provided excel files.
Codding its not my forte so don't be harsh on me :roll:
Feel free to check it and provide changes.
Download From BOB Forums
p.s: I have combined the above with an excellent renaming utility in order to get rid of the instance ID on the published documents name. The command line utility BRC its free and can be found here http://www.bulkrenameutility.co.uk/Command.php
No comments:
Post a Comment