Post reply

repeated graph using multiple sources

  • May 16, 2016 at 2:08 pm

    #400168

    Hi

    I'm looking to create a report that does the following:

    We have 8 products (although more could be added)

    I want to create a set of graphs per product with a page break between

    So, 8 pages; one per product

    There's 4 graphs per page coming from 4 different data sources

    Each source has product as a attribute

    I can achieve this with one source using a matrix that has the graph as data, product as a row

    Then apply a page break

    I can also have a number of graphs that repeat per product so long as it comes from the source

    How do I do this using multiple data sources? as the matrix can only be associated with one dataset

    Thanks

    Damian.

    - Damian

  • May 16, 2016 at 2:18 pm

    #1879372

    Damian,

    can someone create a stored procedure that brings all the data together into one dataset? I suppose you could write a stored procedure that creates a temporary table and then populates by inserting from the various sources. Then you could base the report on that... Not a great answer, but it would work.

  • May 16, 2016 at 3:47 pm

    #1879385

    Have you thought about using subreports for the graphs?

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • May 18, 2016 at 9:07 am

    #1879904

    Thanks for the responses

    I am going to look at both single dataset and subreports

    I suspect for this particular report, a single dataset would work best as the data is derived from the same fact

    It's just the level of granularity that differs

    I will take a look at subsets though as I have just been presented with a couple of other 'dashboard' reports that use different facts but want presenting on the same page

    Subreports seem to work perfectly in this instance

    This is quite a good instructional video for anyone interested: https://www.youtube.com/watch?v=6S8Zzqthsbw

    Thanks

    Damian.

    - Damian

    • Viewing 4 posts - 1 through 3 (of 3 total)

    You must be logged in to reply to this topic. Login to reply