Interested to Buy Any Domain ? << Click Here >> for more details...
HI i have a table with 4 columns in back end like sales id,
sales revenue, order id and order amt. Now i have created 2
prompts at query level 1st on sales id and 2nd on order id.
Now if i run the report for 1st prompt it has to display
sales id and sales revenue. Then if i run the report for 2nd
prompt then it has to overwrite the table with Order ID and
order amount. How you will handle this?
- 1 Answers
- 4147 Views
- I also Faced
- E-Mail Answers
Answer Posted / gowthami
Sub Query 1:
Result objects: sales id, sales revenue
Filter: sales id – prompt
Union
Sub Query 2:
Result objects: order id, order amount
Filter: order id – prompt
Now union logic will be applied at query. If you select value for order id it will display the data related to that id, if you select sales id in the filter then sales data will be displayed. Common filters will be displayed to select the data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the tables used in health care domain project and columns used in report?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
how get the grand total in master-detail report?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain about a tricky situation for which you found a very simple solution?
What is difference between webi and infoview?
How would you format some text using css to be verdana and bold?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain what are the steps to do to use alerts in bo?
Explain the difference between detect alias and detect context?
What is the difference between the public object&schema object?
How to schedule the report in b.o?
