Not sure what your SQL Looks like, but asssuming something like PartBin Table Data.
SELECT BinNum+'='+CONVERT(varchar(40),OnhandQty)+',' As 'data()'
FROM Erp.PartBin
FOR XML PATH('')
This will return something like
A6=1.00000000, A6=1.00000000, A9-9=20.00000000, WH=1.00000000, 2-A=182.00000000, 2-A=182.00000000,
Just stick it in a sub report or a different data set.
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, Dec 8, 2015 at 1:23 PM, Joe Rojas jrojas@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>Hi All,
SQL Server 2014
I have a report where I would like to show bin on hand quantities for a particular part number.
Some parts will have a lot of bin locations and showing them in the traditional approach of a list in a single column won’t work well.
I’d like to be able to list them left to right and have them wrap to the next line when they reach the edge of the page.
Is this possible in SSRS? If yes, any pointers?
[cid:50af9f.png@e32c84e2.4e8a5ec8]
Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax
[http://matsinc.com/images/e-mail-signatures/tagline.jpg]
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png]<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png] <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png] <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png] <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png] <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png] <http://matsinc.com/blog>
[Non-text portions of this message have been removed]
</div> <div style="color:#fff;min-height:0;"></div>