Timothy.Rybak@gmail.com wrote:
> Hello all,
>
> I am new to SQL and reporting services, so be gentle. I am working
> with SQL Server 2000 SP3a. I have a report that returns a list of part
> numbers, and the number those part numbers produced in a given day.
> The parts fall in to 4 distinct groups, Front Right, Front Left, Rear
> Right and Rear Left. The only field in the database that I have to
> work with is the part number field, which integrates abbreviations for
> these distinctions. A Sample of the part numbers is as follows:
>
> 82470-3K000FLHB
> 82470-3K000FRHB
> 82470-3K000RLHB
> 82470-3K000RRHB
>
> The 12th and 13th place characters are the abbreviations. There are
> about 48 total part numbers. Currently, the report just has one column
> of data with all the part numbers produced jumbled up in it.
>
> I would like to have 4 columns of data presented to the user, one for
> each of the distinct groups. The only way that I can think to do this
> is to use 4 different queries, using a Like %FL% or Like %RR% to
> separate out the different groups.
>
> Can this be done? Is there an easier way to do this? The database was
> provided by a 3rd party, so I cannot modify the structure of the db.
>
> Any help is appreciated. If you need more info, please ask.
>
> Tim