Enable ‘Create a new Excel report’ option in HP-ALM

Excel Reports in Quality Center or HP-ALM have always been quite useful in extracting various reports. One of the many advantages has been to export test cases from ALM to excel sheet for convenient use and reporting

From HP-ALM version 12, the option to ‘Create New Excel Report’ is disabled by default. It means, the user cannot create new excel report, but can view, edit and run existing reports (if any) from previous versions.

ALM: Create New Excel Report Option Missing
ALM: Create New Excel Report Option Missing
ALM: Existing Excel Reports
ALM: Existing Excel Reports
 However, the option to ‘Create New Excel Report’ can be enabled by site configuration parameter – ‘ENABLE_CREATE_LEGACY_EXCEL_REPORT’. Following are the steps to do so:
  1. Login to ALM site administration.
  2. Navigate to ‘Site Configuration’ tab.
    ALM: Site Admin Site Configuration
    ALM: Site Admin Site Configuration
  3. Look for the parameter – ‘ENABLE_CREATE_LEGACY_EXCEL_REPORT’. Double click to configure it.
  4. If the above parameter is not found, the site admin can create it by clicking ‘New’. Enter the details as below.
    ALM: Site Admin Site Configuration New Parameter
    ALM: Site Admin Site Configuration New Parameter

  5. Please note that the parameter name is case sensitive and must be entered in all Capital letters.
  6. Click Ok.
ALM: Site Admin Site Configuration Excel Report Parameter
ALM: Site Admin Site Configuration Excel Report Parameter

The users must log off and login again in order to see the changes being effective.
ALM: Create New Excel Report Option Enabled
ALM: Create New Excel Report Option Enabled

Quality Center QC Error : ACCESS VIOLATION AT ADDRESS IN MODULE abc.ocx . Read of address

Some times, we get access violation error at some address on some of the functions in quality center.

 99% of cases when i got this error was when i tried copy and paste in quality center. The copy paste would work fine for some time and suddenly, it would stop working.

The solution i have found to resolve it is as below:-

I recommend that our users follow this procedure to make sure that IE has a clean startup.

1. Close all instances of IE and all instances of Windows Explorer.
2. Open task manager and kill the explorer.exe process (don’t close task manager at this point….otherwise use ctrl-alt-del to get back to Task Manager). Click File –> New Task (run)  –>  type explorer.exe and hit enter.
3. Open a new browser and try to access Quality Center again.

IE and Windows explorer and the desktop explorer.exe process are intertwined and can hold onto certain session parameters and not get cleaned up if you don’t restart all of them at the same time.

I know it is a pain…..but it seems to clear up the problem.

For a shortcut, you may also just close the window in which QC has been opened and start a new session.