List of all column names in the report.

[system]

Is it a way to read all report column name variables names through VBA?

What I am trying to do is:

1. get let of all columns in my report.
2. get type of each variable
3. create comma delimited string with data for each record
4. save it in a text file.

I have no problem with number 3) and 4), but stuck with first two items.

Any suggestion?

Thank you in advance.

---

amargovsky (BOB member since 2002-09-03)

[system]

I assume you are talking about full client reports. Use these as a place to start …[list]List report level variables in full client reports
List objects used in a series of reports[/list]

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

Dwayne,

Thank you for quick reply and yes, I am in DeskI for XIr2.
I was able to read all variables, as well as DP objects, as described in your code.
And I have few questions here:

1. is it a way to know if variable(object) is visible in report block?
2. is it a way to know the order objects appeared in my report block?
3. How could I know type of variable(object)

Thank you for help as always.

Alex

---

amargovsky (BOB member since 2002-09-03)

[system]

Replies below …

@amargovsky

1. is it a way to know if variable(object) is visible in report block? Included, yes (but it’s tricky) … visible, not possible
2. is it a way to know the order objects appeared in my report block? Are you familiar with the “pivot” tab of the Format, Table… dialog? You can get to that via VBA (again, tricky) but I’m not sure the order used in the collection.
3. How could I know type of variable(object). If by type you mean whether it is directly from a data provider or a report-level variable, the answer is yes.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)