Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Using Table Primary Keys Post Reply Post New Topic
Author Message
cbaldwin
Groupie
Groupie


Joined: 09 Apr 2014
Online Status: Offline
Posts: 81
Quote cbaldwin Replybullet 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?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.