Issues Report

[greygor]

We had to issue an Open Issues report as part of our project and found this script useful to strip out the closed ones.  If anyone elese wishes to use it feel free.

P.S. Would be nice to have tis option via EA.



Sub delclosed()
'
' delclosed Macro
' Macro recorded 11/03/02 by Joe Otten
'
   Do
   
   Selection.Find.ClearFormatting
   With Selection.Find
       .Text = "Closed:"
       .Replacement.Text = ""
       .Forward = True
       .Wrap = wdFindContinue
       .Format = False
       .MatchCase = True
       .MatchWholeWord = True
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
   End With
   Found = Selection.Find.Execute
   If Found Then
     Selection.Rows.Delete
   End If
   
   Loop While Found
   
   
   
End Sub

[Steve_Straley]

Hi,

Just FYI, I'm building an add-on toolkit for EA that will report out several types of reports including Issues, To Do's, Defects, Changes, Acceptance, Integration, and Unit reports.  This can be done for the entire project or by Object type.   These reports go to CSV, Ascii, HTML, or printer.

In addition, we've created an "alert" mechanism.  This allows you to set a green, yellow, or red alert level for each of the above reports, to calculate the status against that level, and to generate dynamic web pages (with associated links) for each.

There are a few other goodies that I'm adding as time goes on.  I'm just trying to get to a foundational-point whereby I can make it available for everyone.   I hope to get to that point next week.

Just FYI...

Steve

[greygor]

If you can automate Word and produce a *.doc then you have a winner.  

[Steve_Straley]

Greyor,

I thought about this, including RTF format, and may do it in the future.   What I think is just as easy to do is to print out in HTML format, open the HTML document in WORD and then save out as .DOC file.

The trick, IMO, with .DOC output is to include .DOT output and to include templates and formats.   I'm just trying to get good web pages and output from the tool as the base point from which to build all others.

HTH,

Steve