Solved

.Rdl and htm

Posted on 2009-04-01
9
558 Views
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.
0
Comment
Question by:janmishkin
[X]
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
9 Comments
 
LVL 37

Expert Comment

by:ValentinoV
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: http://msdn.microsoft.com/en-us/library/ms156482.aspx
0
 

Author Comment

by:janmishkin
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.
0
 

Author Comment

by:janmishkin
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.
0
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 
LVL 37

Expert Comment

by:ValentinoV
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".
0
 

Author Comment

by:janmishkin
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??
0
 

Author Comment

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

Accepted Solution

by:
ValentinoV earned 500 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: http://blog.hoegaerden.be/2009/04/07/the-power-of-the-placeholder/

Also, see this Books Online page for extra info: http://msdn.microsoft.com/en-us/library/cc645967.aspx
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,
V.
0
 

Author Closing Comment

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

Author Comment

by:janmishkin
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.
0

Featured Post

Linux Academy Android App Now Supports Chromecast

We have some fantastic news for our Android fans. We’re so excited to announce that the Linux Academy Android app is now available with Chromecast support. That’s right – simply download the latest update of the Linux Academy App and start casting your favorite course videos!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video teaches users how to migrate an existing Wordpress website to a new domain.
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…

628 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