Link to home
Start Free TrialLog in
Avatar of allio
allio

asked on

Cross tab report in reporting services 2005

Hi Experts,
was wondering if it's possible to create a cross tab report in reporting services with no aggregates
kinda look like this

Officer            Status            id              description
___________________________________________
+Head1          |   Approved  |   1002   |   Houston Change
+Head2          |   Approved  |   1002   |   Texas Change
-Head3           |   Approved  |   1001   |   Dallas Change
   approver1   |   Approved |    1001   |   Dallas Change
   approver2   |   Pending    |     1001   |   Dallas Change
   approver3   |   Approved |    1001   |   Dallas Change

they have repeating values, only the status differs, can I do this
Thanks in advance

ALLi
Avatar of chapmandew
chapmandew
Flag of United States of America image

What does your source data look like?
Avatar of allio
allio

ASKER

hi,
It's like this

Ian       Approve      10954    TELCO
Scotti      Pending      10954    TELCO
Rayl      Approve      10954    TELCO
George      Approve      10954    TELCO
Ian      Approve      10980    DESKTOP
John      Approve      10980    DESKTOP
Donna      Approve      10980    DESKTOP
William      Approve      10980    DESKTOP
Martyn      Approve      10980    DESKTOP

thanks


What about the other data?  Your initial question had data such as Officer, Status, id, description but I don't see any data like that in the data you provided...
Avatar of allio

ASKER

they have the same number of columns
approver status, id, description
Avatar of allio

ASKER

to ellaborate,
ian is the head approver, the rest are sub approver,
the sample data I gave involves only 2 ID's , but as you can see, it keeps on repeating,
with the approver and status the only thing that changes .

Thanks for your time
Ok.  What about the head data?  Where does the logic for Head1, Head2, Head3 come from?
Avatar of allio

ASKER

for now Ian is head1
there can be other head approvers so they will be head 2 and so on

ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of allio

ASKER

Yeah I guess it's just a drill down function

sorry for that
Avatar of allio

ASKER

Hi again,

it's a drill down, but I still want to display the data on the + row
like on the link you sent,
I want to display product name and color on the row with NORTHEAST, SOUTH EAST
Doesn't the link show you how?
Avatar of allio

ASKER

the link displays
a row with + sign on the left side , but it doesn't display any other data on that row