Solved

.Rdl and htm

Posted on 2009-04-01
9
546 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
Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Introduction (All good things must come to an end (http://en.wikipedia.org/wiki/All_Good_Things...))The original MySQL API (http://php.net/manual/en/book.mysql.php) has gone away, deprecated by PHP in Version 5.5, and removed from PHP in all current…
A Change in PHP Behavior with Session Write Short Circuit (http://php.net/manual/en/book.session.php#116217) (Winter 2014)** With the release of PHP 5.6 the session handler changed in a way that many think should be considered a bug.  See the note …
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

739 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