May 1, 2018 at 9:31 am
I am struggling to create a report to show statistics on shipments. One data set selects Item#, Order#, Qty. Second Data set selects Ship Date, Item#, Qty. Same tables, but with different group by's. I need to show Average, Median, and Mode by day, also Average, Median, Mode by order#. One day could have multiple orders- one to many. I created two different matrix but I can't get them in one tablix. Is it possible to create a report in SSRS to combine these two datasets? What is the best way to go about it?
May 1, 2018 at 1:42 pm
Without the table structure and the two queries, along with a much more detailed description of what the records in the table represent, it is impractical to offer much advice, because we just don't know what we're trying to accomplish at anywhere near the level of detail necessary. If you can explain in more detail and provide the two queries that represent each data set, plus the other details requested, it will be a lot easier to help.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
May 2, 2018 at 8:52 am
Thanks Steve,
I was able to stack one Matrix on top of the other. Hide rows and size the columns to match.
It's a low tech solution but it works and exports cleanly to Excel.
May 16, 2018 at 8:42 am
steve 11373 - Wednesday, May 2, 2018 8:52 AMThanks Steve,I was able to stack one Matrix on top of the other. Hide rows and size the columns to match.
It's a low tech solution but it works and exports cleanly to Excel.
Glad you were able to sort it out. There's almost always more then one way to "skin the cat", so to speak, where creating SSRS reports is concerned.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply