satinsilhouette
Instructor
- Feb 21, 2006
- 625
I am working with BOEXI R2, Designer and Crystal Reports XI R2. I have built LOV's in the universe and am trying to pull them up into Crystal. The tricky thing is I have security set up on the objects in the classes per a self join on a hierarchy table.
It appears that security is working on the objects, but does not apply to a lov list?
Does anyone know how to get the most current lov list (yes refresh is set) and still have security set?
When I put security on the object that has the lov, the lov lists will not generate in Crystal. If I leave the @bouser variable off the object then the list is generated.
So it seems that you cannot apply security to a lov list? has anyone come across this or have a work around?
Thanks so much!
satinsilhouette
It appears that security is working on the objects, but does not apply to a lov list?
Does anyone know how to get the most current lov list (yes refresh is set) and still have security set?
When I put security on the object that has the lov, the lov lists will not generate in Crystal. If I leave the @bouser variable off the object then the list is generated.
So it seems that you cannot apply security to a lov list? has anyone come across this or have a work around?
Thanks so much!
satinsilhouette