Several connections from one package

[Hannibal]

Hello,  Thank you in advance for your help.

I have a package that contains large amounts of data.  The data is fragmented into different 'connections' split by time period. 

When I run a report on the package, after my prompts, Cognos prompts me to select a connection.  I know that you can have a SQL query to pull from different packages, however i cannot find a way to specify pulling from two or more connections in the same package.  Anyone have a trick for this?

Alternatively, if the above is not possible, When i repormpt my report i can enter new prompt data, but it will not reprompt the connection.  Can I set the report to reprompt the connection and keep the prompt data that I had already selected.

Again thank you for your help