Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

In CaliberRM SDK can I produce a statistical report using MS Word and VBA?

In CaliberRM SDK can I produce a statistical report using MS Word and VBA?

Problem:

In CaliberRM SDK can I produce a statistical report using MS Word and VBA?

Resolution:


  • Product Name: CaliberRM
  • Product Version: CaliberRM 2005 R2 SP1
  • Product Component: SDK
  • Platform/OS Version: Windows

Yes, preoviding you have the following:

  1. CaliberRM SDK installed
  2. Microsoft Word / Office installed
  3. Basic understanding of Object Orientated Programming and Visual Basic for Applications (VBA)
  4. KB Article 5624: CaliberRM: Visual Basic for Applications (VBA) , setting up a Microsoft Word VBA application. http://support.borland.com/entry.jspa?categoryID=435&externalID=5623

The attached word document uses VBA (Visual Basic for applications) to produce a report that:

  • Prints out Project name
  • Prints out baselines in that project
  • Prints out the number of requirement types in that baseline
  • Prints out the number of requirements in that requirement type
  • Print out the total number of Requirements and Requirement Types in baseline
  • Print out grand total.

Find below an example of the output for the "Automated Teller Machine" in the Sample Database

Statistical Report For Project: Automated Teller Machine

Baseline: Current Baseline

Requirements Type:1. Business Requirements : 19

Requirements Type:3. Functional Requirements : 26

Requirements Type:2. User Requirements : 2

Number of Requirement Types 3

Number of Requirements 47

Baseline: Deleted View

Requirements Type: :� 0

Number of Requirement Types 0

Number of Requirements 0

Baseline: Version 1.0

Requirements Type:1. Business Requirements :� 18

Number of Requirement Types 1

Number of Requirements 18

Grand Requirement Type Total: 4

Grand Requirement Total: 65


Related documents:


Old KB# 15855

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:26
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.