BusinessObjects Board

How to visualize user's prompt response with no data?

building reports desktopintelligence
#1

For exemple, the users select conutries ‘France’, ‘US’, ‘Italy’ in the prompt but there’s only data for ‘France’ and ‘US’.
I would like to see in the report the countries for which there’s no data.

Thanks in advance

aureo (BOB member since 2004-11-09)

#2

How can a query return stuff that doesn’t exist?

You have a few choices.

  1. You can do outer joins in your universe.
  2. You can do multiple data providers to return the master list of countries
  3. You can do a union query to make sure you return something for each country.

I like options 2 and 3.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

For Steve’s #2 suggestion, see this entry from our Reporter: FAQ (Frequently Asked Questions). While the example is about getting all months in a crosstab, the same technique applies.

Anita Craig :us: (BOB member since 2002-06-17)

#4

An alternate solution is to display the user response in a cell in the header or footer.

b_demann :us: (BOB member since 2003-03-20)