Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Limiting the amount of code in an HTML rendered report Expand / Collapse
Author
Message
Posted Monday, October 28, 2013 1:33 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, December 13, 2014 11:38 AM
Points: 78, Visits: 642
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

Post #1509096
Posted Tuesday, October 29, 2013 8:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 35,770, Visits: 32,440
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1509399
Posted Tuesday, October 29, 2013 9:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, December 13, 2014 11:38 AM
Points: 78, Visits: 642
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...
Post #1509419
Posted Tuesday, October 29, 2013 10:48 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 35,770, Visits: 32,440
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1509470
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse