How do I pass a Query Result set as a parameter? is this possible?

[wprussell]

I would like to pass the result set from 1 report to another as a paramater. and have the second report use the result set as the main data set. 

For example. 

Report 1

Main Dataset = Select City, State from City_State_Table. 

Report is run, Chart is created from main dataset, hyperlink to report 2 based on State and Parameter = (List of Cities, States) from main dataset

Report 2

Main Dataset  =  Instead of running the same query over again, it uses the dataset (not the query - the actual data) passed as a parameter from Report 1. 

Report is run, chart is created from passed parameter (Dataset from report 1)

 

Is this possible? or am I out of my head. 

 

 

 

 

[butlerc]

I think you could simplify this so you dont need to pass your query result via a param.

1 report only.

With 1 chart & 1 table element.

Use print when expression and a boolean param to determine which you would see and when and have the hyperlink just drill into itself as the report link and set the boolean expression statically.