[quoted text, click to view] On May 11, 2:39 pm, "John Wright" <riley_wrig...@hotmail.com> wrote:
> I want to create a horizontal table as follows:
>
> Ingot 12345 12345 12345
> Traveler 98786 87657 77675
> Pieces 15 20 12
>
> Step 1 x x x
> Step 2 x x x
> Step 3 x x x
> Step 4 x x x
> Step 5 x x x
> Step 6 x x
> Step 7 x x
> ...
> Step 19
>
> As you can see the columns for the steps are fixed. I know which step each
> traveler is on so I want to populate the table with x's until I get to the
> last step. As you can see from this report, the first and third travelers
> are about the same and the second is stuck on step 5. The managers can look
> at this and see that the second traveler will produce a hole later on. So
> how could I create this table in SSRS? Keep in mind the steps are
> predefined and will not change. So the information returned from the query
> would be similar to the following
>
> Ingot, Traveler, Pieces, Step
> 12345 98786 15 7
> 12345 87657 20 5
> 12345 77675 12 7
> ....
>
> Thanks.
You will most likely want to use a matrix report where the pivoted
column (say Column_x) can have values: Ingot, Traveler and Pieces and
then have a normal column called Step. So your stored procedure/query
that will be sourcing the report should have an output like the
following:
Column_x Value Step
-------------- --------- ------
Ingot 12345 7
Traveler 98786 7
Pieces 15 7
Ingot 12345 5
Traveler 87657 5
Pieces 20 5
Ingot 12345 7
Traveler 77675 7
Pieces 12 7
Where Column_x will be the pivot column (it will turn into 3 columns
in the report: Ingot, Traveler and Pieces). Value will be the details
displayed for the pivot column. And Step is the row value (amounting
to a column). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
