By using this website, you agree to our Terms of Use (click here)
Hey Tim,
Have you come across report where Customer would like to see Total sales at Company/Branch level and then drill down to see by Sales person total amt per Company/branch and then click the sales person it further drill down and shows all customers who paid/sold.
It's more like P&L drill down but I want to see if you or others have done something like this in a single/sub-report concept, any ideas?
- Harsha
I haven't done it, but I would probably start with a Generic Inquiry just because Report Designer is a lot more time-consuming to work with. You could either do one Generic Inquiry with a Pivot Table for the drilldown or multiple Generic Inquiries aggregated differently and using the Navigation feature to accomplish drill down / drill up between them.
I agree, client is on Ver 6 so decided to do report but unable to do drill down concept yet .... I tried using GI even if it opens new tab that's still ok i guess but I have a problem now how do you pass parameters. I'm accepting From and To period on GI-1 it needs to pass those dates along with what I clicked "Company" which forms the parameter for 2nd GI and then continue to pass to GI-3 ...
Have you been able to pass the dates from "form filter" to another GI as parameter?
It should just be a matter of populating the NAVIGATION tab on the Generic Inquiry (SM208000) screen, then selecting that navigation entry in the Navigate To column on the RESULTS GRID tab. Is that not working?
Online Members
