Displaying Names in Cross Tab report

[mtepfer]

Am using CRXI. Have a database in Sql 2008 , have 2 tables, The first table (Data) has a column for counselors - this column is an integer that ties back to our user table where the actual name is stored. Example in the Data table counselor = 2. In the User table then 2 is the PK with a column with this counselors name associated, say Joe Smith.

In the cross tab I have the rows currently set to the counselor, which will total each row but returns there number instead of their name. If I try adding the name field it is blank.

How do I get it to group by rows and show the name from the other table.

Sorry if this is not entirely clear just ask for more detail if you need it. Thanks


Fail Pass Pass w/Co Total Percent
13 0 1 0 1 100.00%
15 0 4 0 4 100.00%
17 0 1 0 1 100.00%
18 0 1 1 2 100.00%
19 0 0 1 1 100.00%
22 0 1 0 1 100.00%
24 0 1 1 2 100.00%
25 1 1 0 2 50.00%
26 0 0 1 1 100.00%
27 0 1 1 2 100.00%
30 0 1 0 1 100.00%
31 1 3 1 5 80.00%
32 1 2 0 3 66.67%
33 1 0 1 2 50.00%
Total 4 17 7 28 85.71%

 

[IanWaterman]

In data expert link the two tables by the ID fields

In Cross tab expert, remove the ID filed and replace with name field from counselor table.

Ian

 

[mtepfer]

Never mind on this, figured it out, basically was an error with my view on the sql side that was not allowing the name to display.