Cross tab dynamic report RRS feed

  • 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

    Friday, October 15, 2010 10:49 AM


All replies