2. PHPRunner General questions
  3. Link on summary
This topic is locked

Link on summary

 		11/9/2007 6:15:08 AM
PHPRunner General questions
J
 joesjnr author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6769&image=1&table=forumtopics' class='bbc_emoticon' alt=':ph34r:' />
Dear Forumers,
How do I make Drill Down feature? Some call it Waterfall effect...
For example:
When user log in, a summary page is displayed like
Sale confirmed --- 30 orders

Sale pending approval of Credit Card --- 10 orders

Sale Cancelled --- 5 orders
Then when he or she clicked on, e.g. Sale Cancelled, a detailed list of sale cancelled is shown.
I'm using COUNT on the summary (report) which count the number record is accordance to each status and then display it.
FYI, I am not good at all in PHP.
Thanks in advance.
J
 		JColtro 11/10/2007

I solve this problem using views (created in the MySQL Database):

  • First, I create the most detailed view (level 3);
  • Next, I group the data and create a intermediary view (level 2);
  • Last, I group the data again and create a summary view (level 1).
    In PHPRunner:
  • Create a Menu item to list the view LEVEL 1;
  • Using master x detail between LEVEL 1 and LEVEL 2, create a list page to the LEVEL 2;
  • Again, using master x detail between LEVEL 2 and LEVEL 3, create a list page to the LEVEL 3;
    Ready! I have a drill-down!
    Regards!
    Coltro
J
 		joesjnr author 11/15/2007

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=23387&image=1&table=forumreplies' class='bbc_emoticon' alt=':ph34r:' />

Thank you!

Although I'm yet to try.

It's a workaround, yeah?

Meaning PHPRunner not yet able to that.

Drill Down is decades old concept. It should have been incorporated.

Thanks again, Coltro.