Skip to Content
0
Aug 21, 2015 at 08:22 AM

WEBI - Universe XI - Prompt on field value from several tables

16 Views

Hi Expert,

I would like to create a report with several queries. The report context is the management of contracts (a contract can be of various type: grant, procurement, other,...) and can be linked to contacts, activities, modules.

In the universe there are several class: one for each type with different objects for each of them. For instance:

Class: Grant

Object: Type Grant, Id Grant, Budget Grant, Title Grant, Award, Cofin

Class:Procurement

Object: Type Proc, Id Proc, Budget Proc, Title Proc, Framework Contract, Duration

Class:Other

Object: Type Other, Id Other, Budget Other, Title Other

I created in the report several queries:

  • one for the general information about Grant
  • one for the general information about Procurement
  • one for the general information about Other
  • one for the contacts (Union on Grant, procurement, other)
  • one for the activities (Union on Grant, procurement, other)
  • one for the modules(Union on Grant, procurement, other)

During the launch of the report a prompt should appear for asking the value of the type and all queries should be launched with this filter. I'm trying to do that but I do not know which is the best solution.

Could you please help me?

Thanks in advance