Post reply

General question about types of queries that can form basis of excel and ssrs reports.

  • April 5, 2012 at 1:52 pm

    #256035

    This is a high level question. Can queries using CTE's or row_number...partition by functions be used as basis of a report in Excel and SSRS?

    -

  • April 5, 2012 at 2:06 pm

    #1469809

    In short yep you can use all of the above in SSRS - although not sure what you mean by excel? They are different apps do you mean will it render properly on export?

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • April 5, 2012 at 5:01 pm

    #1469910

    Thanks. Yes, I meant MS Excel for reporting.

    That assurance is all I need to go ahead and build my queries using CTEs, having faith that when I get to the Excel and/or SSRS part, they will work.

    -

Viewing 3 posts - 1 through 2 (of 2 total)

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