February 27, 2014 at 7:08 am
We are trying to setup a reporting services report using the following data, (the last three values are just numerical data):
productcode, group, price, finish, weight, length, unit
001AMIL, 001, 10, AMIL, 0.50, 12, 5
001BSVR, 001, 20, BSVR, 0.50, 12, 5
001CBRZ, 001, 20, CBRZ, 0.50, 12, 5
001EWHT, 001, 24, EWHT, 0.50, 12, 5
001ZZZZ, 001, 21, ZZZZ, 0.50, 12, 5
002AMIL, 002, 10, AMIL, 0.50, 12, 5
002CBRZ, 002, 20, CBRZ, 0.50, 12, 5
002EHWT, 002, 24, EWHT, 0.50, 12, 5
002ZZZZ, 002, 21, ZZZZ, 0.50, 12, 5
003AMIL, 003, 10, AMIL, 0.50, 12, 5
003CBRZ, 003, 20, CBRZ, 0.50, 12, 5
003ZZZZ, 003, 21, ZZZZ, 0.50, 12, 5
We would like a report that will show something along the lines of:
Product AMIL BSVR CBRZ EHWT ZZZZ
001 Weight 0.50 Price 10 20 20 24 21
length 12 Price/Meter 0.5 0.5 0.5 0.5 0.5
unit 5 Product code 001AMIL 001BSVR 001CBRZ 001EWHT 001ZZZZ
002 Weight 0.50 Price 10 20 24 21
length 12 Price/Meter 0.5 0.5 0.5 0.5
unit 5 Product code 002AMIL 002CBRZ 002EWHT 02ZZZZ
003 Weight 0.50 Price 10 20 21
length 12 Price/Meter 0.5 0.5 0.5
unit 5 Product code 003AMIL 003CBRZ 003ZZZZ
In the last part with the product pricing, we would like to keep the column formatting so that if a product is not present, it's just a blank column if possible.
If anyone can help us to do this it would be most appreciated! Thanks
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply