Skip to Content
0

List of values parameter shows as Textbox

May 29, 2017 at 12:45 PM

87

avatar image

Hello,

Sorry if Im posting this in the wrong forum. Im new here.

Im using BOXI 4 sp5. I have a problem that I think it should be easy to solve, but I can't find a solution.

I have some CR reports with a list of values. This list takes the values from a query to an Oracle database (not sure if "list of values" is correct when we speak about a query, if not, please sorry).

When I log into the CMC or BI with the "Administrator" account and run the report, it works fine and shows the list.

When I log into the BI with a non administrator user and run the report, it shows a textbox instead of a list of values.

I think it is some kind of permissions issue, because, if I put the user in the "Administrators" group, the user can see the list of values. The point is, this is happening with all non-administrator users, and I can't put everyone in the group.

Any ideas?

Thank you and regards.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
May 29, 2017 at 08:27 PM
0

is there any data security implemented in Universe?

or Check in CMC->Report folder->usersecurity->select user->assign security->Advance->Add remove rights->content->Web Intelligence->grant "Refresh List of Values" option and try.

Share
10 |10000 characters needed characters left characters exceeded
JinChong Tsai May 30, 2017 at 10:06 PM
0

If what you are referring to as dynamic cascading prompt(s) that the LOV is fetched from a query in Crystal Report, and you are able to view the LOV in this dynamic cascading prompt but not anyone else, please open and login to the BI4.x Business View Manager as Administrator -> View -> Repository Explorer.

Then, right click on the dynamic cascading prompts used by this crystal report and assign user groups you want them to be able to view the LOV in Launch Pad when this crystal report is opened and refreshed.

Regards,

Jin-Chong

Share
10 |10000 characters needed characters left characters exceeded