Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


.Rdl and htm

Posted on 2009-04-01
Medium Priority
Last Modified: 2013-11-26
Trying to do something very simple. I create a rtf file with images embedded with text. Iconvert the file to a HTM or XML file and then I try and embed this file into the Page Header of a.rdl file using BIDS. No idea how to do this. Ultimately I want to have a reporting system with table data showing on the bottom and on the top of each page the rtf,htm or xml that is dynamically choosen from a list of files. ie the header  should be choosend programatically depending on the table data.

Anyway, I can't even figure out how to embed the filein the header as a static embed.
Question by:janmishkin
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
LVL 37

Expert Comment

ID: 24043943
Any chance that you could convert your page header to an image?  In that case you should be able to get it working as explained here:

Author Comment

ID: 24045706
THis is only possible if the image size expands according to the size of the image.  I gues I could my front end save a RTF  as an Image. Once I do that is there a simple way to have the .rdl image Linked and will the image chage size accordingly???? I'll do some testing but I have a feeling that I'll need a more flexible solution.

Thanks though.

Author Comment

ID: 24053366
OK. THere is no easy way to do this so I'm switching to HTML/CSS but I can't get a page header for each page.
Major Serverless Shift

Comparison of major players like AWS, Microsoft Azure, IBM Bluemix, and Google Cloud Platform

LVL 37

Expert Comment

ID: 24217089
Sorry for not getting back to you sooner, life has been a bit hectic (and I lost track of this one).The image object in SSRS can actually automatically resize.  Theproperty is called Sizing and one of the values (the default one) iscalled AutoSize.  The only issue here is that the report header shouldhave its height set to the largest possible height of your generatedimages.
What then remains is selecting the right image for display.  I thinkyou have several options here, depending on how you define your imagesin the report.  One method that I tried out is the following:
  1. set the image's Source property to External - this allows you to use a URL to specify the image
  2. create a report parameter through which you will supply the name of the image
  3. set the image's Value property to the value of the expression, for instance: =Parameters!YourParameter.Value
Thevalue that you need to supply to the report parameter must be a validURL.  For testing purposes I used something like"file:C:\test\header1.bmp".

Author Comment

ID: 24299179
Better then all of this trying to create the doc dynamicly then convert it to a BMP( I'm not sure even how this is done) and then trying to fit it into an rdl - Is there a way to just have some plain HTML (.htm) that I can easily generate dynamically( I know hoe to do this) and somehow stick it in the page header of my rdl file??

Author Comment

ID: 24308383
Question. Can I embedd dynamically HTM or XML ... into the headers of an rdl report??
LVL 37

Accepted Solution

ValentinoV earned 1500 total points
ID: 24319173
Reporting Services 2008 (so not 2005) does have some support to add HTML to a Textbox through one of its new features called the Placeholder.  I wrote an article about the Placeholder on my blog:

Also, see this Books Online page for extra info:
The HTML-related part starts around the middle of the page.  There's also a list of supported tags.

As you'll see, not everything is supported.  I did a small test using an HTML table and the result was that the actual values that the cells contained were rendered right next to each other (<table> is not supported).  So the values in the table are not ignored, the table markup is.

To answer your question a bit better: the same HTML is supported in a textbox located in the header as well, so it all comes down to if you can form your HTML so that only supported tags are used.

Hope this helps,

Author Closing Comment

ID: 31565531
Not sure if it will work but its the closest I've gotten

Author Comment

ID: 24433887
It seems <IMG> is not supported which kills this as a solution. ALso I have BIDS 2005. I'de get 2008 if it solved anything. I can't believe I am not going to have solution to this.

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New Relic: Our company recently started researching several products to figure out what were the best ways for us to increase our web page speed and to quickly identify performance problems that we may be having. One of the products we evaluated wa…
It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question