Wednesday, September 19, 2012

CR2008 hanging

There was a case when my Crystal Reports 2008 was hanging after opening (can't even open a file or do any other thing), so here's what you can do to fix it.

Go to Registry (Start -> Run -> Regedit)
Locate: HKEY_LOCAL_MACHINE\SOFTWARE\business objects\suite12.0\crystal reports
and look for DisableCheckForUpdates and change it to a "1".

It works for me!
Source: here

Tuesday, September 11, 2012

Control-M Variables

To set date -x  in control-M  variable to be in DD/MM/YYYY format

%%SET %%PREVDD = -1
%%SET %%YEST = %%$CALCDATE %%$DATE %%PREVDD
%%SET %%YYYY=%%SUBSTR %%YEST 1 4
%%SET %%MM=%%SUBSTR %%YEST 5 2
%%SET %%DD=%%SUBSTR %%YEST 7 2
%%SET %%YESTERDAY=%%DD/%%MM/%%YYYY

This will give today's date in DD/MM/YYYY format
%%SET %%TODAY = %%DAY/%%MONTH/%%$YEAR

For more default variable click here.