Another Question

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.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