Displaying data depending upon selecting a specific criteria

Hello Forum,

I have a specific scenario in a cross tab report where i need to allow the user to select either hours OR percentages from a prompt. Based on the user selection i need to show the data in either hours OR percentages. An object by name “Display Prompt - Hours or Percentages” is available in the universe. Any ideas?

eg:if i select hours
Resource| Actual Effort in hours | Define | Test | Deploy
ABC | 66 | 21 | 4 | 41
XYZ | 17 | 16 | 1

eg:if i select percentages

Resource|Actual Effort in hours| Define|Test |Deploy
ABC |66 | 32% | 8% | 62%|
XYZ | 17 | 90% | 10%

Thanks
Ram


Ram (BOB member since 2002-09-20)

This may be a “DIRTY” way of doing it but it works…

You can define a constant object in your universe whose definition will jus be a prompt and take any value… May be you can restrict this value to have “Y” or “N” only… And have two table clocks in your report… Based on the entry for this prompt, hide one table and show the other…

Mohan


cpmohanraj :australia: (BOB member since 2002-09-23)

For starters take a look at Integra Solutions’ website and the presentations by Dave Rathbun centered around variables (Even More Variables… etc.), see here.


Andreas :de: (BOB member since 2002-06-20)