Is it even possible?

  • Hi Everyone

    I've got 20 unrelated tables.

    The report request is that for a certain date range (I know how to do this), show the count of each of the first ten tables, and the sum of the values in one field in each of the next 10 tables.

    I'm not even sure it's possible within a single report in SSRS, but if it is, any hints, tips or help as to where to start would be grand!

    Thanks in advance,

    Robert

  • Hi,

    I'm not sure if I've understood the problem but as per my understanding, you can create 20 data sets for each individual table. It need not be related... You should be able to show individual results in one report..

    Hope this helps.

  • What should the output look like?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (1/13/2013)


    What should the output look like?

    😛

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden (1/13/2013)


    SQLRNNR (1/13/2013)


    What should the output look like?

    😛

    Ok, that makes sense then.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • ???

Viewing 6 posts - 1 through 5 (of 5 total)

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