Solved

.Rdl and htm

Posted on 2009-04-01
9
534 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
  • 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Foolproof security solutions has become one of the key necessities of every e-commerce or Internet banking website. If you too own an online shopping site then its vital for you to equip your web portal with customer security features that can allow…
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…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…
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.

828 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