Hmm...you should be able to create a command that will select your applications.
for the most flexibility, I would say create a stored proc that takes a parameter.
It looks like you are using the Command function to select the data for your report. In which case what you are looking to do is going to be difficult. While no one has denied it, no one has confirmed it either, but I don't believe that the Command object was intended to gather data directly for the report. I believe that it was created to gather dynamic data from the database to be used in the selection of parameters for a report. As such, a stored proc is the way to go.
If you want to use the report as structured, I would create a command that selects all applications and place them in a parameter. Then in the Report/Select Formulas/Records I would place a filter on the data for the application selected as a parameter.
HTH
IP Logged
