By using this website, you agree to our Terms of Use (click here)
I'm trying to set up a pair of linked generic inquiries with a drill down. The first inquiry will show invoiced qty and revenue grouped by sales rep with date from and date to as parameters to filter the underlying data. I wan to then have the option to drilldown into a sales rep that would open the second inquiry showing the same data for only the sales rep you click on and now grouped by customer. The issue I am having is how to get the date fields input in the paramter of the original GI to copy over into the drilldown result of the second GI. Has anyone done this before?
Can't you create Parameters in the 2nd inquiry to receive those dates, then add the Parameters to the NAVIGATION tab so they get populated when you drill down?
I set up the Parameters in the 2nd inquiry to receive the dates and am able to add the parameters on the Navigation tab. The issue I'm running into is how to get the data of what dates are input into the parameters on the initial inquiry.
Ah, now I see what you mean. I assumed that you could pass a parameter on the NAVIGATION tab, but it doesn't look like that's the case. I can't think of a workaround for this.