Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

.Rdl and htm

Posted on 2009-04-01
9
Medium Priority
?
584 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
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…
Suggested Courses

879 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