I am a relative newbie and was wondering if this can be done in Zoho reports. I have two tables, one with two columns listing a unique id and question name and another table which lists each of the question name as a column and some more variables to perform slice and dice. I want the first table to be a drop down so when a user selects a question in the drop down that particular question is shown as a column in the report with the data obviously coming from the second table. Does that make sense? I am listing the outline of the table below

Table 1

ID               Question 

1                 Q1

2                 Q2

3                 Q3

..

Table 2

Q1      Q2        Q3          Gender      Location ....

...       ...          ...

Combo box will have the following values

Q1

Q2

Q3

...

When a user selects the question i want the corresponding column from Table 2 to show up in the report