Skip to main content

We have a Lobby Element that summarizes orders by status for 4 date periods.

Now we want drill-down capabilities so when they click on any of the Status rows they see the detail behind it- Order#, Status, Date, Quantity, Price.

 

I couldn’t find any documentation on this- does some exist?

I didn’t see an Element that has this; Link looks like it just drills down into a screen, not a report.

Would it/could it drill down into the Customer Order screen with parms to restrict results?

 

Yes, you will need to use the navigation part of the element. Looking at your data, think you might need a bit of clever implementation in the where logic to correctly navigate to the applicable customer orders.

 


thx, I will try that...


Would my url be something like:

ifsapf:frmCustomerOrder_Cust?ORDER_NO=1859186

 


Trying to figure out the AddressBar url to load customer order lines for customer_no = 122273:

ifsapf:tbwOverviewCustOrdLine?CUSTOMER_NO=122273&COMPANY=1

 

then, if this is our Lobby Element, all we have to pass as a parm for the drill-down is OrderStatus:

 

 


Filled out info on the Nav section, lobbys is now “Clickable” for drill-down, however when I click it does open the CustomerOrderLines screen (:grin: ) but I get this error:

So the question is:

how to map the parms?

how to code the AddressBar url?

 

 

 

 


ok, I got the CustomerOrder State parm working and it loads blocked orders when I click on Blocked in the lobby. :smiley:

last thing to do is add other parms- date range…

 

 

 


fyi, I was able to get it  working.

I basically didn’t use an IAL and coded everything in the DataSource Designer.

Then when I click on a Status row, it opens CusomerOrders for just those detail orders from the underlying SQL.

thx to everyone for your replies and encouragement!


thx. I found that to be true and have designed new lobbies that way.

Then I did a pie chart which turned out looking really sharp.


Reply