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!

show matching dimension values in a cross table

Status
Not open for further replies.

ostfeld

IS-IT--Management
May 8, 2001
3
GI
hallo,
anyone able to help on the following request.

I have a query result delivering records 4:
usernames, lastname
www huber
xxx mayer
yyy huber
zzz fischer

I want to display them in the report in the following cross table composed of the same dimension (username), that shows a match (=1) in case lastnames are similar otherwise 0. for sample data it would look like below:

www xxx yyy zzz
www 1 0 1 0
xxx 0 1 0 0
yyy 1 0 1 0
zzz 0 0 0 1

I tried around a lot with contextes... but never found the right solution, anyone able to help?

tx in advance!
steff

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top