My question is simple.
In Crystal Reports ,is it possible to have a dynamic LOV for the prompts when the report is based on universe? When ever the user chooses the drop down in prompt page, he should see only his values in LOV. This works in WebI.
I read from the forum that in crystal, this can only be possible with Business View. Is this true?
If i use Business view and the user opens the report in Infoview, does he needs DSN to use the connection i have created in Business View to refresh the LOV dynamically?
Please suggest a solution for dynamic LOV as this started as a simple issue and i’m breaking my head to solve this!!
When reporting off a secured Universe in Crystal Reports, the parameter
(Prompts) does not display a dynamic list of values. By default, Universe List of Values (LOV) are seen as static LOV in Crystal Reports, but it is possible to force the LOV to refresh by adding a registry key: AlwaysRefreshUniverseLOV. For information on how to set this option, consult
the SAP Note 1219958.
Thanks Gorthus.
I was excited on seeing your reply and it has a solution. But unfortunately that applies only for XI R2 it seems and we are using XI3.1. Is there a similar solution available for XI3.1 also?
Thanks in advance.
(BOB member since 2007-07-02)
(BOB member since 2004-11-10)
(BOB member since 2007-07-02)