Topic: Using Table Primary Keys Posted: 10 Dec 2014 at 5:37am
I am trying to write a report to display changes to data in a variable group of tables. My program that I am using has an Auditor and keeps track of changes for me.
My problem is that I would like my report to display the Primary Keys of the Table edits that have been made.
Since my report detail will display edits to a variable group of tables that have variable Primary Keys, I would like to determine if there is a way to make crystal determine a tables primary keys and list them in a report if it is supplied with the table name?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 17 Dec 2014 at 11:24am
thinking about this...you would probably need a stored procedure and then you could ask the database about the schema of the table and then you could go from there.
as long as it returns as a column of names and column of attributes, life shouldn't be too hard.
There is nothing inherent in CR that I know of that will do this.
HTH
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum