Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Access row headers in a BO crosstab?

Status
Not open for further replies.

hansver

Technical User
Feb 14, 2006
1
BE
I'm wondering if you're able access the row heading names in a crosstab table.

We have a "freeform" Products table that contains entries ProductNumber, ProductProperty, ProductPropertyValue as follows:

table products

** ProductNumber
>>> 1,2,3,4, ...

** ProductProperty
>>> "property1", "property2", ... (max 100) like height, width

** ProductPropertyValue
>>> value1, value2, ...

I would like to be able to access the value ProductProperty:
ProductPropertyValue of "property1", so you could use <property1> as a Dimension or Measure. MS-Access offers this functionality (crosstab Row and Column heading).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top