Three ways I can think of:
- Straight table (Presentation tab -> Dropdown Select)
I prefer straight table technique. PFA
DropDown_tres.qvw 146.2 K
Sounds like you want to conditionally display objects based on what 'Report' you've selected.
ie: Report A might have a couple of pie charts on things about A, Report B might have a bar chart on things to do with B
In the attached I've created a simple table and multibox that allows you to select between report A and B with two text boxes simulating your two separate report objects.
Then using an objects Conditional (Under the objects Properties -> Layout -> Conditional) I've set Text box A to display only when A is selected, Textbox B to display when only B is selected.
This Conditional Hide/Show can be applied to objects or whole sheets, depending on how far you want to go with it.
Test2.qvw 145.2 K
I'm not sure that I understand correctly, but I will try to help you .
So you can search for field where is unique for the each table. I don't mean unique key, I mean fields which are only in this tables.
If you don't have unique fields in each table, you can create fields like in the example:
Field1, Field2, New Field
..... ....... 0
..... ........ 0
Field3 , Field4. NewField2
...... , ...... , 1
........ , ...... , 1
Next, create two multiboxes with fields : NewField and NewField2.
You can rename them like Table A and Table B.
When you select Table A the information on the dashboard will be from Table A, when you select the information on the dashboard will be from Table B
I'm not sure that will work corectly for the left join, but you can try.
i would use a button or text box to toggle between A and B
create a variable to show or hide the reports and using conditional show in the layout you can achieve what you like. Watch the below you tube for clear explanations http://m.youtube.com/watch?v=PSRBtw7SYD8