Hi All,
A quick background. The Inventory Usage report in 10.0.700.4 does not work. When running the report, it only shows the information for a single warehouse even if you specifically select multiple warehouses on the filter tab.
Support is aware and I’ve been struggling to get a one of fix since 11/20/2015 because they are telling me it is fixed in 10.1.
We had a custom version of this report in E9 where we displayed additional information, including a subreport that would show the on hand quantities in PartBin.
This subreport simply showed the on hand quantity in each PartBin record, nothing more, so it was just a series of number values. In Crystal, it was easy to format the report so that the detail section repeated horizontally.
I’m having a tough time recreating this subreport in SSRS. By that, I mean I can’t figure out how to format the subreport so that is will detail section will report horizontally and then wrap below the first row if there is too much data to fit on the first row.
Here is a screenshot of what my current SSRS report design looks like now and where I want to put this subreport.
http://imgur.com/QrUtm4J
Here is a screenshot of what the E9 Crystal Report looked like.
http://imgur.com/28j4qiP
Any pointers on how to achieve what I’m looking to do?
[cid:421d42.png@8c849d5a.41a62caa]
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%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>
[Non-text portions of this message have been removed]
A quick background. The Inventory Usage report in 10.0.700.4 does not work. When running the report, it only shows the information for a single warehouse even if you specifically select multiple warehouses on the filter tab.
Support is aware and I’ve been struggling to get a one of fix since 11/20/2015 because they are telling me it is fixed in 10.1.
We had a custom version of this report in E9 where we displayed additional information, including a subreport that would show the on hand quantities in PartBin.
This subreport simply showed the on hand quantity in each PartBin record, nothing more, so it was just a series of number values. In Crystal, it was easy to format the report so that the detail section repeated horizontally.
I’m having a tough time recreating this subreport in SSRS. By that, I mean I can’t figure out how to format the subreport so that is will detail section will report horizontally and then wrap below the first row if there is too much data to fit on the first row.
Here is a screenshot of what my current SSRS report design looks like now and where I want to put this subreport.
http://imgur.com/QrUtm4J
Here is a screenshot of what the E9 Crystal Report looked like.
http://imgur.com/28j4qiP
Any pointers on how to achieve what I’m looking to do?
[cid:421d42.png@8c849d5a.41a62caa]
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%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>
[Non-text portions of this message have been removed]