Group By Row

I am looking for a way to group on a row. I am not sure that this can
be done, but here is what I have.
My dataset looks like the following:
JobNumber Invoice Code Property PropertyValue Cost
071201 61556 Area
101 10.00
071201 61556 Cost Center
1101020 10.00
071201 61556 Equipment #
23R05 10.00
I want my report to look like this:
071201
61556
Area
Cost Center
Equipment #
Cost
Is there a way?Maybe you can use the case function but I'm not sure.
SELECT JobNumber, Invoice Code,
CASE Property
WHEN 'Area'
THEN 'Area' AS Area
WHEN 'Cost Center'
THEN 'Cost Center' AS CC
WHEN 'Equipment #'
THEN 'Equipment #' AS EQUIP
ELSE
etc...
END
So you gonna have different ALIAS FLD from the same physical fld.
I repeat that I didn't test it.
If not maybe using crosstable may solve ur problem.
Let me know if it works
Julien
"TCogan" <tcogan@.starcon.org> wrote in message
news:1174668240.221027.226060@.b75g2000hsg.googlegroups.com...
>I am looking for a way to group on a row. I am not sure that this can
> be done, but here is what I have.
> My dataset looks like the following:
> JobNumber Invoice Code Property PropertyValue Cost
> 071201 61556 Area
> 101 10.00
> 071201 61556 Cost Center
> 1101020 10.00
> 071201 61556 Equipment #
> 23R05 10.00
>
> I want my report to look like this:
> 071201
> 61556
> Area
> Cost Center
> Equipment #
> Cost
> Is there a way?
>|||Grouping by row can be done with toggling and visible which uses a + sign to
expand and contract , the same method can be used to display all at once.
Amarnath, MCTS
"TCogan" wrote:
> I am looking for a way to group on a row. I am not sure that this can
> be done, but here is what I have.
> My dataset looks like the following:
> JobNumber Invoice Code Property PropertyValue Cost
> 071201 61556 Area
> 101 10.00
> 071201 61556 Cost Center
> 1101020 10.00
> 071201 61556 Equipment #
> 23R05 10.00
>
> I want my report to look like this:
> 071201
> 61556
> Area
> Cost Center
> Equipment #
> Cost
> Is there a way?
>