September 4, 2008 at 2:56 am
Dear Experts,
I created Extended Properties for tables and columns in SQL Server 2005 database and am thinking is there any possiblity to access this information in Crystal Reports 2008 while creating reports.
The whole idea is to simplify the creation reports without exposing the technical layer of a database instead expose the meaningful business names of tables and columns.
For example:
tb1 is a technical name for a table "Table1" and c1 is a technical name for a column "Column1". In Crystal reports while accessing this database I would like to see Table1 and Column1 instead of tb1 and c1.
Please guide me on possible best practices in doing this so that my customers need not understand the technical names like tb1, c1?
Your views and help in this regard would be of great help to me.
Please also guide me "What are the inteded usage of Extended Properties".
Thanks & Regards
Satish
September 4, 2008 at 7:01 am
You can use the sys.extended_properties view to get the information from extended properties. I believe the idea around extended properties is to give the database designer/developer a place to put information/metadata about the database.
One way to find out how the data should/could be queried is to start a profiler session and then use SSMS to open a table for design and see how MS is querying the data.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply