Print Page | Close Window

Current CE User Name - Session data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13616
Printed Date: 29 Apr 2024 at 2:10am


Topic: Current CE User Name - Session data
Posted By: Colonel45
Subject: Current CE User Name - Session data
Date 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,


Replies:
Posted By: lockwelle
Date 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

Posted By: Colonel45
Date 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?

Posted By: lockwelle
Date 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

Posted By: sa-user
Date Posted: 11 Jul 2011 at 12:14pm
Was there a solution for this?
We are looking for something similar
 
Thanks

Posted By: Colonel45
Date 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.
 
 


Print Page | Close Window