Can I Generate a User-Defined Report Sent "directly" to an EXCEL File? (non-Report Builder)
BACKGROUND:
I have my user-defined "View" for my RDNG Requirements Module. From the Module's Triple-Bar icon, I'll invoke this RDNG feature:
"Generate a Report with This View"
This Feature allows me to generate a Report with these selected column headings:
"DOORS Id"
"Contents" that could be:
"Section" column: Paragraph Number & Verbiage
"System Requirement" verbiage
Artifact Type
Links From
Links To
The feature "Generate a Report with This View" sends above columns to one of these file formats:
PDF
MS-Word
HTML
XSL-FO
After selecting either Word or HTML, I'll manually copy the tabular data(systems requirements & section data)
out to an EXCEL spreadsheet, and format it accordingly.
QUESTION:
Is there a RDNG generate report feature(outside of the Report Builder and RPE), that allows me to generate
exactly the same Report as above, "but" have it Sent Directly Out to a EXCEL Spreadsheet?
NOTE:
1) Report Builder: I've learned it, used it. But my co-worker saw a demand to pull a Requirements
along with the Rqmt's Paragraph Number and Paragraph Verbiage. As many of you may know,
Report Builder can only pull the Paragraph verbiage(artifact "Heading").
2) RPE: As of this writing my work site did not employ RPE.
Any input would be appreciated
Thanks in Advance...
CarlosG
One answer
Hi Carlos -
- Lift code from a post like this (stackexchange).
- Save the module in your normal.dotm template - this code can now be accessed from all word docs OR Import the code into a different .dot / .dotm file and specify a template for RPE. All new docs should house the code you had saved.
- Execute your macro after document generation.
Comments
Thanks David,
I fear I left out a few points. Began learning RDNG since Feb. And started working last May
building projects and importing/linking documents. Prior experience was with DOORS Classic,
10 yrs as an End-User at my last work site. As a result...
1) Report Builder: I've learned it, used it. But my work site saw a demand to pull
Requirements and
Rqmt's Paragraph Number and Paragraph Verbiage.
As you may know, Report Builder can only pull the Paragraph verbiage(artifact "Heading").
2) RPE: As of this writing my work site did not employ RPE. I smiled when you mentioned RPE.
That was mentioned to me as a solution to another Blog question.
I guess the "search continues"...
Thanks!
Sorry, I missed that in your initial question. I see that now. Without RPE, this is difficult.. but not impossible. After all, RPE is just a wrapper for a complicated mechanism of REST calls, but not one that is impossible to approximate. You could take some inspiration from https://jazz.net/library/article/1482 -- but that's probably overkill.