Plan for failures, hope for success!
Posts tagged BI4

How to Change PlaceHolder values in Crystal Reports Server 2011 / BI4
6 years ago
by pinchii
in Technology
I needed to update the placeholders in crystal reports server 2011 for the FRS services. In CRS2008 I changed them using placeholders.bat, but the current PlaceHolders.bat file is outdated and meant to be used on XI 3 I think. So first I had to take it upon myself to make placeholder.bat compatible with CRS2011 / BI4. (Because WE ALL KNOW SAP wont do it for us)
Here is the modified placeholders.bat script:
1 2 3 4 5 6 7 8 9 |
@echo off FOR /F "tokens=2* delims= " %%A IN ('Reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Config Manager" /v INSTALLDIR') DO SET BOHOME=%%B\ FOR /F "tokens=2* delims= " %%A IN ('Reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Config Manager" /v JAVAHOMEDIR') DO SET JAVA_HOME=%%B\.. FOR /F "tokens=2* delims= " %%A IN ('Reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Config Manager" /v SHAREDCLASSESINSTALLDIR') DO SET BOCLASSDIR=%%B\ FOR /F "tokens=2* delims= " %%A IN ('Reg QUERY "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\default" /v BINDIR') DO SET PATH=%%B\jdk\bin;%PATH% set CLASSPATH=.;%BOCLASSDIR%\* java Placeholders %1 %2 %3 %4 %5 %6 %7 %8 %9 |
Combine it with Placeholders.class from the placeholders.zip (SAP Note 1449399) and now you can change any pleaceholder
First lets test out the command
1 |
Placeholders.bat -cms @CMSCluster -pass $$password -allsia -display |
Now Lets update the 2 FRS Placeholders DefaultInputFRSDir and DefaultOutputFRSDir
1 |
Placeholders.bat -cms @CMSCluster -pass $$password -allsia -update DefaultInputFRSDir \\mycustompath\FileStore\Input |
1 |
Placeholders.bat -cms @CMSCluster -pass $$password -allsia -update DefaultOutputFRSDir \\mycustompath\FileStore\Output |
and the after
Enjoy!!