Interface design with main, summary, detailed tables

370 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


I am trying to create report on problem tickets using interface designer. The requirement is as below

Clients table - List of clients (company name)

Ticket Summary Table - Summary of tickets logged, solved, pending etc at quarter level (Q1, Q2, Q3, Q4), Year

Tickets details table - List of tickets logged including Client name, staff name, date logged, problem area etc

Ticket details connected to summary and client tables

Ticket summary connected to client table

I am trying to create a report where a supervisor would

->Select a client name 

->Select a Quarter, Year

Then Summary table fields (say total tickets logged, total tickets resolved for the selected client in selected quarter) should be displayed in separate box fields with different color codes

Along with this ticket details should be displayed in a gird or list form showing details 

I tried to get this to most of the extent but, I am not able to get the detail table showing only the specific quarter related tickets. Currently it showing for all quarters which means the quarter filter coming from ticket summary table is not connected 

Please suggest how this could be resolved




1 Reply 1

Could you provide a base with example data set up?  That would enable people to assist you without having to recreate everything themselves