Crystal using @variable('BOUSER')
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16757
Printed Date: 02 May 2024 at 1:33am
Topic: Crystal using @variable('BOUSER')
Posted By: Cameron
Subject: Crystal using @variable('BOUSER')
Date Posted: 15 Jun 2012 at 5:17am
|
I am very new to both Crystal Reports and BO. I would appreciate any and all suggestions to help with my issue. I have created my report (stacked bar chart) in Crystal. I would now like to restrict the person's view that will be running the report so they are only allowed to see what applies to them. I know that I need to connect to a Universe and use the @variable('BOUSER') in BO, but I am not able to get Crystal to recognize this.
Thank you in advance!!
-------------
Cameron
|
Replies:
Posted By: rkrowland
Date Posted: 15 Jun 2012 at 5:43am
|
Try using currentceusername instead, I filter alot of my reports based on who is currently logged in using this method.
Regards,
Ryan.
|
Posted By: Cameron
Date Posted: 18 Jun 2012 at 3:01am
|
Ryan,
Thanks for the help. I am trying to use the currentceusername instead but I am still having some issues. I am connected to the BO Universe through Crystal and I would like to use custom SQL within the Business Objects Query Panel but it will not give me that option. (It allows me to do this when using BO only, but not in the Universe through Crystal Reports. Any thoughts or suggestions?
Thanks again for the help,
Cam
-------------
Cameron
|
Posted By: hilfy
Date Posted: 18 Jun 2012 at 4:03am
|
You can't use custom SQL in Crystal when connecting to a Universe. You could, however, connect directly to the database and enter your SQL in a Command and run your report that way. You don't mention which version of Crystal you're using, but if you're using Crystal for Enterprise 4.0, this will not work as that version will only connect to the database through a universe. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|