Showing posts with label image. Show all posts
Showing posts with label image. Show all posts

Wednesday, March 28, 2012

Making use of RGDI output

According to the Reporting Services feature matrix, the image output that Report Server Express has is something called RGDI. From what I've gathered, RGDI stands for Remote GDI.

What is the RGDI file format useful for? I don't know the proper file extension to give the file, nor do I know what viewer can view it.

Is there some way to convert the RGDI format to a more universally accepted file format such as .tif, .gif, .jpg, etc...? I'm hoping that I can just capture the binary stream, and convert the stream to a different image format before saving the file.

Thanks!

RGDI is not useful in itself, it's only usable and used by the Winforms report controls in VS 2005.

Thanks
Tudor|||

So you are saying that RGDI isn't available via a call to the Render() web service method to Report Server Express?

In that case, is Report Server Express going to support calling Render with a format of "IMAGE" and return a .tif file? If not, does RS Express support rendering to any sort of image type? The .tif functionality seems pretty useful.

Thanks.

|||

RGDI is available, but it only works with the WinForms Report Control. It consists of serialized GDI calls, which are not generally useful. The Express Server supports EMF format for printing.

|||

Brian, I would like to save the results of a Render() in the RGDI format to later be opened using a winforms application that may not have access to our servers.

Is it possible to save the RGDI results and open them later with the ReportViewer in a disconnected environment?

Making use of RGDI output

According to the Reporting Services feature matrix, the image output that Report Server Express has is something called RGDI. From what I've gathered, RGDI stands for Remote GDI.

What is the RGDI file format useful for? I don't know the proper file extension to give the file, nor do I know what viewer can view it.

Is there some way to convert the RGDI format to a more universally accepted file format such as .tif, .gif, .jpg, etc...? I'm hoping that I can just capture the binary stream, and convert the stream to a different image format before saving the file.

Thanks!

RGDI is not useful in itself, it's only usable and used by the Winforms report controls in VS 2005.

Thanks
Tudor|||

So you are saying that RGDI isn't available via a call to the Render() web service method to Report Server Express?

In that case, is Report Server Express going to support calling Render with a format of "IMAGE" and return a .tif file? If not, does RS Express support rendering to any sort of image type? The .tif functionality seems pretty useful.

Thanks.

|||

RGDI is available, but it only works with the WinForms Report Control. It consists of serialized GDI calls, which are not generally useful. The Express Server supports EMF format for printing.

|||

Brian, I would like to save the results of a Render() in the RGDI format to later be opened using a winforms application that may not have access to our servers.

Is it possible to save the RGDI results and open them later with the ReportViewer in a disconnected environment?

Monday, March 12, 2012

Make a copy of parts of a ROW, but with a new Key.

Hi there,

I want to insert a new record into my database table, giving new field
values for all but one (an image field), which I can copied from an existing
record. The background to this is that I am allowing a user to create a new
"template" from an existing one, thus I want a new record, but also to copy
the existing template data blob into the new record.

My code looks like this, but obviously doesn't work (I don't supply a field
for the first field "ID" in my SELECT statement which should be a unique ID.
Obviously, I want SQL to automatically generate one for me!). Is there any
way to do this with SQL?

IF @.Error = 0
BEGIN
SELECT @.DateCreated,
@.Title,
@.Description,
@.Thumbnail,
ReportTemplate.Report

INTO

ReportTemplate

FROM

ReportTemplate

SET @.Error = @.@.ERROR
ENDI think I got it. Like this:

IF @.Error = 0
BEGIN
INSERT INTO
ReportTemplate
(
DateCreated,
Title,
Description,
IsStatic,
Thumbnail,
Report
)

SELECT

@.DateCreated,
@.Title,
@.Description,
@.IsStatic,
@.Thumbnail,
ReportTemplate.Report

FROM

ReportTemplate

WHERE

ReportTemplate.ID = @.ID

SET @.Error = @.@.ERROR
END

"Robin Tucker" <idontwanttobespammedanymore@.reallyidont.com> wrote in
message news:c635gr$483$1$8302bc10@.news.demon.co.uk...
> Hi there,
> I want to insert a new record into my database table, giving new field
> values for all but one (an image field), which I can copied from an
existing
> record. The background to this is that I am allowing a user to create a
new
> "template" from an existing one, thus I want a new record, but also to
copy
> the existing template data blob into the new record.
> My code looks like this, but obviously doesn't work (I don't supply a
field
> for the first field "ID" in my SELECT statement which should be a unique
ID.
> Obviously, I want SQL to automatically generate one for me!). Is there
any
> way to do this with SQL?
> IF @.Error = 0
> BEGIN
> SELECT @.DateCreated,
> @.Title,
> @.Description,
> @.Thumbnail,
> ReportTemplate.Report
> INTO
> ReportTemplate
> FROM
> ReportTemplate
> SET @.Error = @.@.ERROR
> END