Cross tab with distinct count

[grandlynx]

Hello,

 

I have an SQL query like this :

SELECT user_name, task_type, take_name FROM task;

 

I want to make a cross tab with the result of this query formatting with user_name in row, task_type in column an number of different task_name by type by user in cell.

 

I thik it's a standard cross tab but my cells contains the first take name concerned by crosselling and not the dictinct count.

 

Can you help me please ?

 

Sorry if my post is dummy :(

[n0n00b]

Hi

 

i think u should try to do this with your query and not with iReport.

 

what about a select like this:

SELECT user_name, task_type, count(distinct(take_name)) FROM task group by user_name, task_type