April 19, 2012 at 8:28 am
Hello All,
I need some help regarding SSRS 2008 Dynamic Columns report.
The report has 3 datasets (DS1,DS2 and DS3)
DS1 :
ID Col1 Col2 ColZ
unique (Col z here has data from DS3 colz but not distinct)
DS2:
ID Qty Col3 col4 Colz
1 20 Scratch
1 24 scrap
DS3:
Colz
Scratch
Scrap
(21 distinct rows)
The values in DS3 changed depending on the input parameters (in here 21 rows, so the report contains columns from ds1 and 21 colums from ds3 values)
The report should like this
ID Col1 Col2 (Values in Colz, 21 distinct rows as columns) ------------------> Columns in report
(depending on ID, the qty value for appropriate colZ Value ) ------------> Data for columns
Example of report:
ID Col1 Col2 scratch cut scrap.... 18 different columns
1 xyz abc 20(qty from ds2 based on id) 24
From above example of report, for ID = 1 scratch(colz value from ds3) and scrap(colz value from ds3) qty(ds2) values for ID =1 in DS2 are filled if it doesn't have one value its empty (cut).
I hope this makes sense. Please shoot questions if i am not clear.
Thanks,
Satch
April 20, 2012 at 12:25 pm
wow, looks like my post makes no sense at all.
April 20, 2012 at 12:27 pm
Satch24 (4/20/2012)
wow, looks like my post makes no sense at all.
Well... there is no question asked on your post 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 20, 2012 at 12:53 pm
LOL!!! and i was thinking that i gave lot of information for everyone to understand. 😛
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply