Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Complex Report formatting Expand / Collapse
Author
Message
Posted Thursday, February 27, 2014 7:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 3, 2014 11:29 AM
Points: 5, Visits: 29
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
Post #1545862
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse