Report with two pages - Page Two dependent upon a record selected in Page One? possible?

[PBInonpro]

I would like to have a report to where a record selected in Table one populates the entire data view of Page 2. 

Example, Page one is a table of ['date', 'sales orders', 'revenue']. 

On the table (or any other method) you select a record, and page two will show the details of that record. 'sales orders' will show the items ordered, customer, store #, etc for the purpose of being able to print PDF the report from page two. Is this possible?

(Very rough screenshot)