|
|
You're in the
sql server reporting services
group:Displaying data in Columns based on Criteria
sql server reporting services:
each row. Here's an example of the data: Employee ID Type Code Amount 123 PAY BONUS 1,000 123 PAY SALARY 5,000 123 DED INS 500 123 DED DENTAL 100 123 DED FLEX 50 Here's how I'd like to display the data: EMPLOYEE CODE AMOUNT CODE AMOUNT 123 BONUS 1,000 INS 500 123 SALARY 5,000 DENTAL 100 123 FLEX 50 My problem is understanding how to display the items in each column starting at the top. Thanks for any help. -- Charles Allen, MVP
[quoted text, click to view]
On Sep 30, 9:20 am, Charles Allen <cal...@nospam-bkd.com> wrote: > I have data in rows that I want to display in columns based on a value in > each row. > > Here's an example of the data: > Employee ID Type Code Amount > 123 PAY BONUS 1,000 > 123 PAY SALARY 5,000 > 123 DED INS 500 > 123 DED DENTAL 100 > 123 DED FLEX 50 > > Here's how I'd like to display the data: > > EMPLOYEE CODE AMOUNT CODE AMOUNT > 123 BONUS 1,000 INS 500 > 123 SALARY 5,000 DENTAL 100 > 123 FLEX 50 > > My problem is understanding how to display the items in each column starting > at the top. > > Thanks for any help. > -- > Charles Allen, MVP The best way to produce this type of layout is to create a matrix report where your pivot column (the column that gets split into multiple columns based on distinct values) is Type. Hope this helps. Regards, Enrique Martinez Sr. Software Consultant
I'll give it a shot. Thanks
-- Charles Allen, MVP [quoted text, click to view] "EMartinez" wrote:
> On Sep 30, 9:20 am, Charles Allen <cal...@nospam-bkd.com> wrote: > > I have data in rows that I want to display in columns based on a value in > > each row. > > > > Here's an example of the data: > > Employee ID Type Code Amount > > 123 PAY BONUS 1,000 > > 123 PAY SALARY 5,000 > > 123 DED INS 500 > > 123 DED DENTAL 100 > > 123 DED FLEX 50 > > > > Here's how I'd like to display the data: > > > > EMPLOYEE CODE AMOUNT CODE AMOUNT > > 123 BONUS 1,000 INS 500 > > 123 SALARY 5,000 DENTAL 100 > > 123 FLEX 50 > > > > My problem is understanding how to display the items in each column starting > > at the top. > > > > Thanks for any help. > > -- > > Charles Allen, MVP > > > The best way to produce this type of layout is to create a matrix > report where your pivot column (the column that gets split into > multiple columns based on distinct values) is Type. Hope this helps. > > Regards, > > Enrique Martinez > Sr. Software Consultant >
Please do suggest me on the below requirement in addition to what Charles
Allen has asked for: How can I add another column that shows the difference between first CODE column value and second CODE column value? Thanks in advance! [quoted text, click to view] "Charles Allen" <callen@nospam-bkd.com> wrote in message news:AD136641-F3A8-42B3-A900-92E78174D443@microsoft.com... > I'll give it a shot. Thanks > -- > Charles Allen, MVP > > > > "EMartinez" wrote: > >> On Sep 30, 9:20 am, Charles Allen <cal...@nospam-bkd.com> wrote: >> > I have data in rows that I want to display in columns based on a value >> > in >> > each row. >> > >> > Here's an example of the data: >> > Employee ID Type Code Amount >> > 123 PAY BONUS 1,000 >> > 123 PAY SALARY 5,000 >> > 123 DED INS 500 >> > 123 DED DENTAL 100 >> > 123 DED FLEX 50 >> > >> > Here's how I'd like to display the data: >> > >> > EMPLOYEE CODE AMOUNT CODE AMOUNT >> > 123 BONUS 1,000 INS 500 >> > 123 SALARY 5,000 DENTAL 100 >> > 123 FLEX >> > 50 >> > >> > My problem is understanding how to display the items in each column >> > starting >> > at the top. >> > >> > Thanks for any help. >> > -- >> > Charles Allen, MVP >> >> >> The best way to produce this type of layout is to create a matrix >> report where your pivot column (the column that gets split into >> multiple columns based on distinct values) is Type. Hope this helps. >> >> Regards, >> >> Enrique Martinez >> Sr. Software Consultant >> >>
[quoted text, click to view]
On Sep 30, 11:20 pm, Charles Allen <cal...@nospam-bkd.com> wrote: > I'll give it a shot. Thanks > -- > Charles Allen, MVP > > "EMartinez" wrote: > > On Sep 30, 9:20 am, Charles Allen <cal...@nospam-bkd.com> wrote: > > > I have data in rows that I want to display in columns based on a value in > > > each row. > > > > Here's an example of the data: > > > Employee ID Type Code Amount > > > 123 PAY BONUS 1,000 > > > 123 PAY SALARY 5,000 > > > 123 DED INS 500 > > > 123 DED DENTAL 100 > > > 123 DED FLEX 50 > > > > Here's how I'd like to display the data: > > > > EMPLOYEE CODE AMOUNT CODE AMOUNT > > > 123 BONUS 1,000 INS 500 > > > 123 SALARY 5,000 DENTAL 100 > > > 123 FLEX 50 > > > > My problem is understanding how to display the items in each column starting > > > at the top. > > > > Thanks for any help. > > > -- > > > Charles Allen, MVP > > > The best way to produce this type of layout is to create a matrix > > report where your pivot column (the column that gets split into > > multiple columns based on distinct values) is Type. Hope this helps. > > > Regards, > > > Enrique Martinez > > Sr. Software Consultant You're welcome. Let me know if I can be of further assistance. Regards, Enrique Martinez Sr. Software Consultant
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |