Post reply

Limiting the amount of code in an HTML rendered report

  • October 28, 2013 at 1:33 pm

    #278524

    Hello...

    I've once again run into issues using SSRS 2008 R2 to render reports for viewing in gmail webmail. Does anyone know of a way to limit the amount of styling code that SSRS adds to an HTML 4.0 rendered file?

    Here's the issue...

    I need to be able to display a formatted report in the body of an email that will be viewed using gmail webmail. In the past I've been able to get this to work using a combination of SSRS and C#... but now I've run into a new problem with a size restriction on how large the viewable email body code can be. My report is ~300k and the restriction is 101k.

    Looking at the html...it's bloated with a ridiculous amount of styling code. Has anyone run into an issue with this? Have you figured out a way to limit the amount of code in these files?

    Thanks

  • October 29, 2013 at 8:52 am

    #1662393

    Yes. That's why I don't use SSRS for most things. The HTML bloat is ridiculous.

    If you're not including any graphs in the email, lookup sp_senddbmail in Books Online and have a look at the last example where they convert a table output to HTML using a trick with FOR XML PATH. I use that method for all of my morning reports and several other things.

    --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)

  • October 29, 2013 at 9:21 am

    #1662410

    Thanks Jeff... I also use FOR XML PATH for some of my smaller reports. 🙂 I was was hoping there was some way to turn the HTML bloat off and control what gets rendered...oh well. Why can't MS just make SSRS a top of the line product. In it's current state...It really is garbage...

  • October 29, 2013 at 10:48 am

    #1662455

    brickpack (10/29/2013)

    Thanks Jeff... I also use FOR XML PATH for some of my smaller reports. 🙂 I was was hoping there was some way to turn the HTML bloat off and control what gets rendered...oh well. Why can't MS just make SSRS a top of the line product. In it's current state...It really is garbage...

    BWAAA-HAAA!!!! If you think SSRS makes for bloated HTML, you should work with Teleric controls sometime. 😉 I'm not a font-end programmer but the guys I work with say they produce insanely bloated pages.

    --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)

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

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