Crosstab and tabular data

rajiv1107

Hi,

We have two tables with following structures:
T1: Count_Customers, Date
T2: Count_Requests, Date, Application

User want to view the data from both the tables in a single view as date wise grouping and application wise grouping as:


Date Count_Cust Application-1 Application-2

D1 10 <Count_requests for App-1> <Count_requests for App-2>

So he wants to view the date wise data from first table and corresponding date data from second table but grouped by Application. The grouping on application need to be shown in columns as App-1,App-2 and so on...



Please let me know if this is possible?

Regards,
Rajiv

rajiv1107

please update me on the same.