Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Who is running the report?? Post Reply Post New Topic
Author Message
pmcm
Newbie
Newbie


Joined: 27 Aug 2010
Location: United Kingdom
Online Status: Offline
Posts: 15
Quote pmcm Replybullet Topic: Who is running the report??
     Posted: 04 Jan 2011 at 2:51am
Hi All - happy new year!

I have a Stored Procedure in database A which is on Server A. It is called by a CR8.5 report file that a user runs via a hosted web page on the same server – is it possible to amend this CR to capture the IP address or machine name (or user id) of the person who runs the report?

Thanks in advance
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 04 Jan 2011 at 8:33am
It probably depends on how you are gathering the parameters for the stored proc.
 
If the web page  gets the parameters it could set the values that you want in CR as parameters to the stored proc, then have the stored proc pass them back to the report.
 
If the user is entering the parameters for the report, and these parameters feed the stored proc, then I don't think that it is possible. As far as I know, CR doesn't look at / care about those things.
 
HTH
IP IP Logged
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