Maybe you can help explain something to me.
What is the difference between BAQ Parameters and dashboard trackers? When would you have to use parameters?
I used parameters because I thought that was needed for the BAQ because I have a couple of calculated fields that need the correct date range put in to make the calculations.
If the calculation in the BAQ occur after the dashboard tracker then I would definately switch that over and get rid of the parameters.
By using the Tracker and Query Prompts for the Date, or Dates, it uses those in the whereclause for the data being retrieved. You then Publish the Customer Num and the Date(s) fields. In the second BAQ you Filter using those published fields. Enter dates in the tracker query prompts, refresh, the first BAQ populates and the second query will immediately fire using those publish values in its whereclause to execute its query. Then as you click the rows in the first grid the second BAQ fires again, populates the second grid, using any updated values from that particular row.