How can I pass a parameter in Excel reports to allow it’s use in post processing scripts in ALM?

  • Questions
  • How can I pass a parameter in Excel reports to allow it's use in post processing scripts in ALM?
Question ID: 105469
0
0

HI,
As the above title describes, is there a way that I can pass a parameter through to the post processing script I am using in my Excel report? I have tried through creating the parameter and defining it as global, but i can not get it to pass through to the post processing scripts, which uses VB scripting, so it does not work?

Thanks for any help

Marked as spam
Posted by (Questions: 314, Answers: 12)
Asked on July 8, 2014 11:02 am
6 views
Answers (1)
1
Private answer

HI HOmerJ,
The only way that I have found to do this is to set the parameters within the main query using the @@ within the select statement. This will set the parameter to a column within the excel report, then within the post processing section,, you can access that column through the (Cells(1,'''').Value) designator. After which if you would not like that to appear within the excel report you can run a deletion of that column at the end of your post processing script, such as the following command:

Cells(1,'''').EntireColumn.Delete

Hope this helps,
Dan

Marked as spam
Posted by (Questions: 0, Answers: 709)
Answered on July 8, 2014 11:07 am
Thanks for your assistance.
( at July 8, 2014 11:08 am)