Hi
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
Thanks
Sri1
