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:
Object: Type Grant, Id Grant, Budget Grant, Title Grant, Award, Cofin
Object: Type Proc, Id Proc, Budget Proc, Title Proc, Framework Contract, Duration
Object: Type Other, Id Other, Budget Other, Title Other
I created in the report several queries:
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