Embedding Dundas Chart Pro Charts in RS

This there a way to integrate the full version of Dundas Chart Pro in RS reports by using the extensibility API?
Including a URL accessed image of a Dundas Chart doesn't cut it if the rendering is to be done by PDF - my experence is showing that the image will be heavily pixelated.
TIA
JeffNot yet. I expect the Yukon version to support extensibility.
see www.sqlreportingservices.net
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"jbarts" <jbarts@.discussions.microsoft.com> wrote in message
news:A41DEF90-1E42-4C54-9C42-6191E08BA533@.microsoft.com...
> This there a way to integrate the full version of Dundas Chart Pro in RS
reports by using the extensibility API?
> Including a URL accessed image of a Dundas Chart doesn't cut it if the
rendering is to be done by PDF - my experence is showing that the image will
be heavily pixelated.
> TIA
> Jeff

Embedded or DB images not showing in ReportViewer

I have a report which has an embedded image in the heading and an image control that loads images from the database (Image control Data section configured as MIMEType=image/jpg, Source=Database, Value=Fields!Img_Data.Value).

In both cases I can see the embedded heading image and the database images in design mode (VS2005) and through the report manager web pages. When I try to render the report through the ReportViewer web control in my web application, the images do not display (standard missing image red "X" appears).

I have a button on my web form which re-runs the report and exports it to PDF, and when pressed the report is displayed correctly in PDF with all images.

What do I need to do to the ReportViewer web control for it to show embedded and database images? I am using the ReportViewer for 2005.

Please advise of give me some place to look.

Mark

Anyone?|||

Have the same problem.

Nowhere can find some answer.

Checked registration of http handler for reportViewer.

All seems ok.

But no one embedded image is not displayed.

We invested much time (read money) in the solution, and got stucked with this problem, because sorting images that uses reporting services dont display also.

If you found the solution, please help!

|||

I copied image URI from rendered report,

then tried to access embedded image from browser.

Copied url: http://localhost:2403/SITE/Reserved.ReportViewerWebControl.axd?ReportSession=w0bnfsz5qhowblqcixc22eix&ControlID=12fb7de86eea4d9080dda118312ed121&Culture=1049&UICulture=1049&ReportStack=2&OpType=ReportImage&StreamID=612c1bae-af83-408b-b385-25b08a827bc4

Result was Error

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ReportServerException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound)] Microsoft.Reporting.WebForms.ServerReport.InternalRenderStream(String format, String streamId, String deviceInfo, String& mimeType, String& encoding) +216 Microsoft.Reporting.WebForms.ServerReportControlSource.GetStreamImage(String streamID, String deviceInfo, String& mimeType) +59 Microsoft.Reporting.WebForms.ReportImageOperation.GetStreamImage(String streamID, HttpResponse response) +216 Microsoft.Reporting.WebForms.ReportImageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +94 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +215 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Seems, that is ugly implementation bug

|||Solved the PROBLEM by installing SQL Server Service Pack 2.)))|||

No, images showed only once, and then all goes wrong once again.

It's bad job that microsoft had done with this report control((

SP2 dosnt solve this problem!

sql

Embedded or DB images not showing in ReportViewer

I have a report which has an embedded image in the heading and an image control that loads images from the database (Image control Data section configured as MIMEType=image/jpg, Source=Database, Value=Fields!Img_Data.Value).

In both cases I can see the embedded heading image and the database images in design mode (VS2005) and through the report manager web pages. When I try to render the report through the ReportViewer web control in my web application, the images do not display (standard missing image red "X" appears).

I have a button on my web form which re-runs the report and exports it to PDF, and when pressed the report is displayed correctly in PDF with all images.

What do I need to do to the ReportViewer web control for it to show embedded and database images? I am using the ReportViewer for 2005.

Please advise of give me some place to look.

Mark

Anyone?|||

Have the same problem.

Nowhere can find some answer.

Checked registration of http handler for reportViewer.

All seems ok.

But no one embedded image is not displayed.

We invested much time (read money) in the solution, and got stucked with this problem, because sorting images that uses reporting services dont display also.

If you found the solution, please help!

|||

I copied image URI from rendered report,

then tried to access embedded image from browser.

Copied url: http://localhost:2403/SITE/Reserved.ReportViewerWebControl.axd?ReportSession=w0bnfsz5qhowblqcixc22eix&ControlID=12fb7de86eea4d9080dda118312ed121&Culture=1049&UICulture=1049&ReportStack=2&OpType=ReportImage&StreamID=612c1bae-af83-408b-b385-25b08a827bc4

Result was Error

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ReportServerException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound)] Microsoft.Reporting.WebForms.ServerReport.InternalRenderStream(String format, String streamId, String deviceInfo, String& mimeType, String& encoding) +216 Microsoft.Reporting.WebForms.ServerReportControlSource.GetStreamImage(String streamID, String deviceInfo, String& mimeType) +59 Microsoft.Reporting.WebForms.ReportImageOperation.GetStreamImage(String streamID, HttpResponse response) +216 Microsoft.Reporting.WebForms.ReportImageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +94 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +215 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Seems, that is ugly implementation bug

|||Solved the PROBLEM by installing SQL Server Service Pack 2.)))|||

No, images showed only once, and then all goes wrong once again.

It's bad job that microsoft had done with this report control((

SP2 dosnt solve this problem!

Embedded Images Not Displaying properly

Hi,

I have a question which i hope someone can help with. When using an embedded image stored on a server in my reporting services report i can see it when proeviewing the report but when it is deployed it no longer is shown on the report. If i try this with an image stored on my local drive it works fine in both preview and deployed mode.

I am wondering why this could be? My initial thoughts are that the security on the file stored on the server may not allow access when the report is run in a deployed state yet it is accessible to the report developper as they have access to the server directory. Does this sound feasible and if not can someone let me know as to why this may not work.

Many thanks,

Grant

Grant,

if you point to the picture just as an resource you should also publish the picture to the proper RS folder like the report.

Or use a web link which should be a "public" one and has to be accessible by every User using RS.

cheers,
Markus

embedded images in the report

We have company logo stored as an "embedded image" in the rdl file. When the
report is deployed to the production server, the logo is not displayed in
the Report Manager.
What all steps are required to deploy reports with embedded images?
pls. help.
ThanksHi newmem,
I have had the same problem. I have found out that my IE 6.0 causes the
error in my case. After switching the IE options "check for newer version of
stored html pages" from "automatically" to "every visit to the page"
everything works fine...
your way: IE -> Internet Options > Settings
I identified the IE because every output format displays the company logo
correctly (PDF...) and only the default and html format was wrong...
Regards
Wolfgang Himmelsbach
"newmem" wrote:
> We have company logo stored as an "embedded image" in the rdl file. When the
> report is deployed to the production server, the logo is not displayed in
> the Report Manager.
> What all steps are required to deploy reports with embedded images?
> pls. help.
> Thanks
>
>sql

Embedded images cause export to .pdf to fail.

I am using an embedded image of a signature on my report. It is a small
.jpg. When I run and print the report, everything is ok. When I try to
export it to pdf, the report stops rendering the report when it gets to the
image. I am using Adobe v.7. I tried this using Adobe v.5 and the whole
report renders except the signature image. Does anyone have an idea how i
can get around this?I found the answer was to change the embedded image from a .jpg format to a
.bmp format. I guess that adobe has a had time renedering images that were
in .jpg format.
"Chris Arnold" wrote:
> I am using an embedded image of a signature on my report. It is a small
> .jpg. When I run and print the report, everything is ok. When I try to
> export it to pdf, the report stops rendering the report when it gets to the
> image. I am using Adobe v.7. I tried this using Adobe v.5 and the whole
> report renders except the signature image. Does anyone have an idea how i
> can get around this?

Embedded Images

Is there any way to embed images when you want to view a report in HTML?
From what I can tell... RS makes a copy of the embedded image... and then
references this copy (hosted on the report server) in the HTML... however,
the application I use to generate the report doesn't allow direct access to
the reporting server... which complicates things a bit... has anyone else
dealt with this issue?Render report as MHTML
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MER78" <MER78@.discussions.microsoft.com> wrote in message
news:F2682F11-DDDF-45E3-A81F-1A1193B1B3B7@.microsoft.com...
> Is there any way to embed images when you want to view a report in HTML?
> From what I can tell... RS makes a copy of the embedded image... and then
> references this copy (hosted on the report server) in the HTML... however,
> the application I use to generate the report doesn't allow direct access
> to
> the reporting server... which complicates things a bit... has anyone else
> dealt with this issue?sql

Embedded image does not appear

Hi there!

I've an embedded image (logo) in my report, and in the preview it looks wonderful, but after deploy the logo doesnt appear in the report (report server).

The url of the dead-link-image is http://hamsql1/Reports$BI/Reserved.ReportViewerWebControl.axd?.

I thought that an embedded image is stored "in" the report, but it seems to be an other place. Is it nessecary to deploy an embedded image too? Is it a problem of permissions (i read it in another threat)? How to set these image-see-permission? Or is there an other problem?

Every idea is very welcome!

Thanks,

Torsten

Some new informations:

The imported image is an printable image with 300 dpi. These image does not appear in the report. Another image, 72dpi, appears. Is it possible, that the render is not able to render 300 dpi?

|||

Hello,

What version of Reporting Services are you running? Have you applied the latest service pack? If you go to http://<server>/ReportServer and look in the bottom right you will see the version number.

Also, are both images embedded? Are they both the same image type (gif, jpg, etc.)? Are either of them scaled? Is the sizing option on both set the same?

Try building a new blank report and embedding both images using the wizard defaults. Does it work then?

Larry

|||

HI Larry!

I've Microsoft SQL Server Reporting Services, Version 9.00.3042.00, SP2, running on Win 2003 Server 64 Bit.

Both images are embedded, both are jpg. I tried both, scaled and nonscaled, it seems there is no dependency on scaling or not.

I tried it in a blank report, and again, the 300dpi image does not appear, the 72dpi image is okay.

Torsten

|||

Hello Torsten,

You are running on SP2 Original (http://www.sqlservercentral.com/columnists/sjones/2960.asp) and I have tested on a 32 bit Win 2003 with the same version of SSRS and don't see the problem. I will have to wait until I get home to test the 64 bit versions. Can you share your images with me? It could be image specific. My email is larry at smithmier dot com.

Thanks,

Larry

|||

Hi Larry!

Could you reproduce it?

Torsten

|||

Hello,

Yes, I received your report and images and reproduced it locally (even on a 32 bit machine). I fixed the problem by resaving the JPG as a new file using Paint.NET (http://www.getpaint.net/) and re-embedding it. I am looking at the file itself to see if I can figure out what went wrong, but for now, you should be fine with the new image. I am emailing it back to you.

Larry

Embedded image

A report has embedded images in it. They display fine in ReportDesigner.
However, they do not display after being deployed to the ReportServer when
viewed in ReportManager. They do display if the report is exported to pdf
format. However, the requirement is simply to display the report in
Sharepoint using a URL in the page viewer webpart. Does the image file need
to also be installed on the report server box, uploaded to ReportManager
...?I believe that If the image is embedded in the report than it is stored
as binary data in the ReportServer database.
Is the image showing up as a red x?
have you right-clicked on the image and looked at the properties?
What is the url of the imbedded image?|||The image is showing up as a box (there is not a red x). When I right-click
on the image the properties show the url as -
ReportServer?%2fDashboard+-+MTD&rs%3aFormat=HTML4.0&rs%3aImageID=8a9c568f-8086-4138-a852-fc08d0111215.
So even though the image is 'embedded' we're thinking that it is also stored
in the database. Would that happen when the report is deployed to the
reportserver or when the rdl is uploaded?
Thanks for the help.
"patrick_brisbine" wrote:
> I believe that If the image is embedded in the report than it is stored
> as binary data in the ReportServer database.
> Is the image showing up as a red x?
> have you right-clicked on the image and looked at the properties?
> What is the url of the imbedded image?
>|||if you run the below query against the reportserver database it should
return one record, the last part of the url is the image id in the
database: 8a9c568f-8086-4138-a852-fc08d0111215.
select * from chunkdata
where chunkname = '8a9c568f-8086-4138-a852-fc08d0111215'
If you are having problems, delete the report from the server, delete
the image from the report (report > embedded images > delete), and then
re-add the image. this will insert a new "image" record in the
database and might (or might not) fix your problem.
hope this help!|||The query did return a record.
I tried deleting the image and readding it. The record in the database also
deleted and readded. Still no luck. When I try to run the url statement for
the image, the following error occurs:
The stream cannot be found. The stream identifier that is provided to an
operation cannot be located in the report server database. (rsStreamNotFound)
Get Online Help
Is there something on the server that needs to be set? The report runs fine
on another server.
Thanks
----
"patrick_brisbine" wrote:
> if you run the below query against the reportserver database it should
> return one record, the last part of the url is the image id in the
> database: 8a9c568f-8086-4138-a852-fc08d0111215.
> select * from chunkdata
> where chunkname = '8a9c568f-8086-4138-a852-fc08d0111215'
>
> If you are having problems, delete the report from the server, delete
> the image from the report (report > embedded images > delete), and then
> re-add the image. this will insert a new "image" record in the
> database and might (or might not) fix your problem.
>
> hope this help!
>|||Could this have anything to do with the fact that both SharePoint and
ReportingServices are on the same server (Windows 2003)'
"PD" wrote:
> A report has embedded images in it. They display fine in ReportDesigner.
> However, they do not display after being deployed to the ReportServer when
> viewed in ReportManager. They do display if the report is exported to pdf
> format. However, the requirement is simply to display the report in
> Sharepoint using a URL in the page viewer webpart. Does the image file need
> to also be installed on the report server box, uploaded to ReportManager
> ...?|||Can you view the image on its own in Internet Explorer (right click image
file in Windows Explorer, Open With... > Internet Explorer)? If not, then it
may have something to do with the colour palette settings used in the image
itself.
We had exactly the same problem with an image appearing OK in the designer &
when exported to PDF/Excel, but not appearing in Report Manager. We got one
of our design guys here to fix the image so it was using the RGB colour
palette (don't know the technical process for it, I'm a DBA here), tried with
the new copy of the image, and hey presto! It worked.
Hope this helps.
Jadranka.
"PD" wrote:
> Could this have anything to do with the fact that both SharePoint and
> ReportingServices are on the same server (Windows 2003)'
>
> "PD" wrote:
> > A report has embedded images in it. They display fine in ReportDesigner.
> > However, they do not display after being deployed to the ReportServer when
> > viewed in ReportManager. They do display if the report is exported to pdf
> > format. However, the requirement is simply to display the report in
> > Sharepoint using a URL in the page viewer webpart. Does the image file need
> > to also be installed on the report server box, uploaded to ReportManager
> > ...?|||Hi PD
Did you have success in this problem
I'm with the exact SAMEproblem here. I already tried everything, an
nothing seems to work ...
If so, contact me ... rodrigo[at]pointsystems.com.br ..
Regards|||I FOUND THE SOLUTION
My server name contains a underscore "_" in it. It may cause sessio
problems
I found out that images on Reporting services rely o
session and cookies
In the Report Server Database, there is a table calle
ConfigurationInfo. I changed the value of UseSessionCookies t
False
Voilá! ;-
Regards

Embed a tif image in an RDLC

I need to expose a tif image as part of my report. Anyone know if
this is possible and if so how to do it?
Thanks,
JasonI didn't get an answer so I did the next best thing. I converted the
tiffs to gifs and replaced my result set:
Protected Sub butSubmit_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles butSubmit.Click
' Get the table adapter
Dim exceptionAdapter As New
Automated_BillingTableAdapters.vw_GetExceptionsWithChargesTableAdapter
' Get the Table
Dim ExceptionTable As
Automated_Billing.vw_GetExceptionsWithChargesDataTable = _
exceptionAdapter.GetExceptionsByTypeandDate(ddlExceptionTypes.SelectedValue,
tbExceptioBegin.Text, tbExceptionEnd.Text)
' Start a new table to handle the results with the altered
image path
Dim NewExceptionTable As New
Automated_Billing.vw_GetExceptionsWithChargesDataTable
' Process the rows from the original table
For Each row As
Automated_Billing.vw_GetExceptionsWithChargesRow In ExceptionTable
' Get the original image path
Dim FilePath As String = row("ImagePath").ToString
' Check to see if file exists
If My.Computer.FileSystem.FileExists(FilePath) Then
' File exists
' Get the image
Dim imageFile As Image
imageFile = Image.FromFile(FilePath)
' Get the pages
Dim frameDimensions As FrameDimension = New
FrameDimension(imageFile.FrameDimensionsList(0))
Dim NumberOfFrames As Integer =imageFile.GetFrameCount(frameDimensions)
' Process the pages
For intFrame As Integer = 0 To NumberOfFrames - 1
imageFile.SelectActiveFrame(frameDimensions,
intFrame)
' Create a path for the new file for the page
Dim sPath As String
sPath = FilePath.Remove(FilePath.Length - 4, 4) &
"-" & intFrame.ToString() + ".gif"
' Check to see if the image already exists for the
page
If Not My.Computer.FileSystem.FileExists(sPath)
Then
' Image does not exist
' Create page image
Dim bmp As System.Drawing.Bitmap = New
System.Drawing.Bitmap(imageFile, 493, 639)
bmp.Save(sPath, ImageFormat.Gif)
bmp.Dispose()
End If
' Create a new row for the page
Dim NewRow As
Automated_Billing.vw_GetExceptionsWithChargesRow =NewExceptionTable.NewRow()
' Copy the orginal row info to the new row
NewRow.ChargeCode = row.ChargeCode
NewRow.ChargeCodeMod1 = row.ChargeCodeMod1
NewRow.ChargeCodeMod2 = row.ChargeCodeMod2
NewRow.ChargeID = row.ChargeID
NewRow.CodedDate = row.CodedDate
NewRow.Coder = row.Coder
NewRow.DxCode = row.DxCode
NewRow.DxID = row.DxID
NewRow.ExamDate = row.ExamDate
NewRow.ExceptionDate = row.ExceptionDate
NewRow.ExceptionType = row.ExceptionType
NewRow.ExceptionTypeID = row.ExceptionTypeID
NewRow.Patient = row.Patient
NewRow.PlaceOfService = row.PlaceOfService
NewRow.ReportID = row.ReportID
NewRow.ReportStatus = row.ReportStatus
NewExceptionTable.Rows.Add(NewRow)
' Set the new row's image path to the new file
NewRow.ImagePath = "file://" & sPath
Next
' Clean up
imageFile.Dispose()
End If
Next
' Replace the datasource for report viewer
ReportViewer1.LocalReport.DataSources.Clear()
ReportViewer1.LocalReport.DataSources.Add(New
Microsoft.Reporting.WebForms.ReportDataSource("Automated_Billing_vw_GetExceptionsWithCharges",
NewExceptionTable))
ReportViewer1.LocalReport.Refresh()
End Subsql