Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Current CE User Name - Session data Post Reply Post New Topic
Author Message
Colonel45
Newbie
Newbie


Joined: 10 May 2011
Location: United States
Online Status: Offline
Posts: 35
Quote Colonel45 Replybullet Topic: Current CE User Name - Session data
    Posted: 28 Jun 2011 at 6:36am

Our current crystal reports are run via a web application called Clarity. I am looking for a way to grab session based values and use them to filter the data in my reports.

How do I go about using the Current CE User Name or Current CE User ID special fields or to display the current user's info, the user that ran the report not the internal user we use to connect to the database.

 
Is it possible to display and user the current user's name?
 
Thanks,
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 28 Jun 2011 at 7:59am
not that I am aware of.  If you place the user in data table or in something that CR can read, it is possible...
 
CR, to the best of my knowledge (which is limited in this area), doesn't have the ability to access anything outside of CR.  You could programatically set a parameter or a value somewhere to let CR know what the value is, but it doesn't know how to go out and query a variable somewhere.
 
HTH
IP IP Logged
Colonel45
Newbie
Newbie


Joined: 10 May 2011
Location: United States
Online Status: Offline
Posts: 35
Quote Colonel45 Replybullet Posted: 28 Jun 2011 at 8:04am

Ok. So there's not really a way to pass session data directly into Crystal?

What about from the server side, does the info get passed there at all?
 
I just need a way to only show certain records to a user that has the rights to see those records based on a table in SQL...
 
So Crystal Reports has no security features at all? Or do I need to do something with BI Universe?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 28 Jun 2011 at 10:39am
I don't know anything about BI.
 
No CR doesn't know who the user is and so cannot set security. 
 
We get around this by having a wizard from our app gather the parameters...the app can be used to select data both for parameters and to set who the user is.
 
HTH
IP IP Logged
sa-user
Groupie
Groupie


Joined: 29 Jun 2011
Online Status: Offline
Posts: 65
Quote sa-user Replybullet Posted: 11 Jul 2011 at 12:14pm
Was there a solution for this?
We are looking for something similar
 
Thanks
IP IP Logged
Colonel45
Newbie
Newbie


Joined: 10 May 2011
Location: United States
Online Status: Offline
Posts: 35
Quote Colonel45 Replybullet Posted: 12 Jul 2011 at 4:05am
Nope there was no solution to this exact problem. I am exploring the option of Business Objects Universes, which allow for database security.
 
 
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.030 seconds.