Rookie question on LOV's and Crystal 2008

[Former Member]

Hi,

I need to create some cascading LOVs, we can use the typical Country->State->Region example you see often, but here are the twists.

1. I need to use this LOV in both webi documents and crystal reports.

2. I need the LOV to stay dynamic, I'm under the impression that when it is put into a crystal report, it becomes a static list, but this could be old/erroneous information.

3. I'm using BOE 3.1 and Crystal 2008. I'd like to only design the LOV once, preferably as a Universe LOV, but I understand I may have to design it again as a Business View (or whatever that is called).

4. Finally, the SQL that i use will have security restrictions on the user, so I need to pass in the %BO_USER% to either the universe or business view to restrict the rows that come back. It doesn't have to be a parameter, but it does need to be in the SQL generated.

Sorry for all the questions, but I'm swimming in documentation and I can't find a solid answer to this issue.

Matthew

[Former Member]

You have to create both in Universe and BusinessView.

For WebI you will be using Universe, and for Crystal Reports you will be using Cascading Prompts from Business View.

Hope that helps.