Cross tab dynamic report

Question

Hi i have the following scenario we have a table named property with intPropertyId as pk

we have two more tables 1 is custom_tables custom_columns

custom_tables have table names

custom_columns columns have column names which are user defined column with property

and finally we have a custom_columns_values table as mapped table with custom_columns

so we have intPropertyid incolumnid varValue column as column value sql_variant against every property

now i have to create report which shows column names as column names and their values as values

i have tried pivot but its not working is there any way i can print dynamic or user defined columns as columns and their values as rows

Answer 1

try to create cross table report , report will do this automatically for you.

Answer 2

Here you can find very nice article with example about - Pivots with Dynamic Columns in SQL Server 2005.

Thanks,

 

---

Kapil Khalas - Database Developer

Answer 3

Check out FIFTH EXAMPLE - dynamic pivot crosstab query
at the following page: http://www.sqlusa.com/bestpractices/training/scripts/dynamicsql/ 

---

Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM