Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Display the user ID iin report headings
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
TomV
Past 24 Hours:
1
Prev. 24 Hours:
2
Overall:
5186
People Online:
Visitors:
324
Members:
0
Total:
324
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Display the user ID iin report headings
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
mikeP
Veteran Member
Posts: 151
6/11/2010 2:46 PM
Does anyone know a way to display the user's Lawson acount name in reports run from an LBI server? This can be handy in a report heading when you're trying to determine the origins of a printed page at a later date.
There a CR function called CurrentCEUserName, but it only works with Crystal Enterprise, which our provider doesn't have. I was hoping someone else may have developed a workaround for this.
Thanks,
Mike
.
Char
Veteran Member
Posts: 62
6/11/2010 5:05 PM
Mike:
The function is called @CurrentUser and you can create a parameter in crystal and make it hidden and not prompted and put @CurrentUser in the value then drop the paramter in the header.
Char
mikeP
Veteran Member
Posts: 151
6/11/2010 5:29 PM
Thanks Char.
I created a test report in CR 2008, ver 12.3.0.601 with a single parameter and placed it on the report. I don't see an option in CR Edit Parameters or the LBI Maintain Parameters page to hide it, other than an option in the CR Edit Parameters form to prevent it from displaying on the Viewer panel
In CR, I tried a defailt value of @CurrentUser, but that just prints "@CurrentUser" on the report.
Can you tell me a bit mpre about how to set this up?
Thanks,
Mike
.
Char
Veteran Member
Posts: 62
6/11/2010 5:44 PM
In LBI, you edit the parameter on the maintain parameters screen -( I'm not VPN'd to a client with LBI at the moment so forgive me if my wording is a litttle off). There are two settings you need to change, one is hidden and one is prompt - set these to hidden = true and always prompt = false. In the Default Value on this screen, you put @CurrentUser. I use it to control row level security within all of their reports..
mikeP
Veteran Member
Posts: 151
6/11/2010 7:06 PM
Thanks Char, got it working.
It turns out that this technique only appears to work if you do not check the "Use Crystal Parameter Page" box on the report's Maintain Parameters form in LBI. We do check that box for a couple reasons, but primarily because if we don't, default parm values from the report don't appear, only defaults configured in LBI.
The main problem is those LBI defaults disappear when a report is republished, and need to be set again in LBI after each republish operation. Some of our reports have many parms with defaults for various account number segments and range limits, and it would be a huge PITA to try to have to recreate the defaults exactly after every republish.
Has this been an issue for you, and have you found any way around it?
Thanks,
Mike
.
Char
Veteran Member
Posts: 62
6/11/2010 7:29 PM
What I do is to delete the parameters from the LBI maintain parameters screen except for the one parameter that is hidden that passes the UID to the report so the user then get's the Crystal prompted parameters for the others.
mikeP
Veteran Member
Posts: 151
6/11/2010 7:40 PM
I would not have thought of that in 1K years!
Thank you very much for your help.
Mike
.
Donna
Veteran Member
Posts: 110
9/29/2010 4:36 AM
Char,
I read your post on @currentuser in the select statement. I have the field populating in the page header but I would appreciate an example of select statement with @CurrentUser. What bursting option would you choose from the LBI list?
This will save many hours if I can get it to work.
Thank you.
Char
Veteran Member
Posts: 62
9/29/2010 7:41 AM
I chose not to use LBI "bursting" - this client is quite large and the amount of effort required to maintain the security schema within LBI would have required a lot more work than what I implemented. In their case, they secure reports by cost center and I created a script that runs each night an populates a table that draws the correlation to a User ID and the cost center(s) they see. I join this table to the other reporting tables and in LBI, I create a parameter called user ID, set it to not prompt and be hidden with the default @CurrentUser. On the maintain parameters screen, I append {Table.Field} = ?UserID.
Donna
Veteran Member
Posts: 110
9/29/2010 2:51 PM
You are so generous to help me with this.
Thank you very much.
You are not authorized to post a reply.