Datasource: SSIS extension

Hi!
According to msdn http://msdn2.microsoft.com/en-us/library/ms228006
all I need to do to allow SSIS datasource in the report builder is to
uncomment an extension line with SSIS name in the rsreportserver.config. But
this not works on my VS2005 (i tried on both Beta2 and RC instances)... No
one new data provider type occured in the dropdown. I'm disappointed, what's
wrong? If anyone knows what to do to really add SSIS data to a report, send
me a string, Please!I have the same exact problem. Can anyone help?
"Sergei Vedischev" wrote:
> Hi!
> According to msdn http://msdn2.microsoft.com/en-us/library/ms228006
> all I need to do to allow SSIS datasource in the report builder is to
> uncomment an extension line with SSIS name in the rsreportserver.config. But
> this not works on my VS2005 (i tried on both Beta2 and RC instances)... No
> one new data provider type occured in the dropdown. I'm disappointed, what's
> wrong? If anyone knows what to do to really add SSIS data to a report, send
> me a string, Please!
>|||The SSIS data extension is only supported for report designer and report
server, not directly in report builder.
Did you actually install the SSIS components on that machine? Also, in order
to use the SSIS data extension in report designer, you have to uncomment the
SSIS configuration element in the RSReportDesigner.config file.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:676FE940-5A2D-4F35-8CB3-82B5C02B916C@.microsoft.com...
>I have the same exact problem. Can anyone help?
>
> "Sergei Vedischev" wrote:
>> Hi!
>> According to msdn http://msdn2.microsoft.com/en-us/library/ms228006
>> all I need to do to allow SSIS datasource in the report builder is to
>> uncomment an extension line with SSIS name in the rsreportserver.config.
>> But
>> this not works on my VS2005 (i tried on both Beta2 and RC instances)...
>> No
>> one new data provider type occured in the dropdown. I'm disappointed,
>> what's
>> wrong? If anyone knows what to do to really add SSIS data to a report,
>> send
>> me a string, Please!

Datasets window display

Hi

When designing a report layout, I want to use the Datasets window, however, I could not find how to open this window. In MSDN, it says" On the View menu, click Datasets" to display the Datasets window. But I could not find the Datasets under the View menu on my local. Any advice? Thanks.

Hi,jiamei:

Would you please tell in which article from MSDN, you have found this words?

|||

Rex,

Here it is:http://msdn2.microsoft.com/en-us/library/ms365160.aspx

|||

Hi,jiamei:

Which project are you in? When you stay in the report project, you can click the 'view menu' on the top of the window and you will find the dataset option in the last position of the pop up list.

Databound Image to header...export issue

I followed the instructions from this post...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=384621&SiteID=1

on how to add databound images into a report header.

The issue I am encountering is exporting to PDF. If the report spans multiple pages, in PDF the image only shows up on the first page..and broken on all other pages.

I have tied the hidden image to the table that spans multiple pages. Shows ok in HTML but breaks when exported.

Thanks for any help.How did tie the hidden image to the table? Through RepeatWith? If so, the issue here is probably that RepeatWith is not supported in PDF. You can try adding a row to the table, mark it repeat on every page, and place the hidden image in the table row to make sure it gets repeated on each page.|||

try this

u can do that with the help of parameters

1) add a calculated field in dataset named imagebase64 in that add the following expression

Convert.ToBase64String(Fields!Photo.value)

2)Add report Parameter named image

set the datatype as string.

in the default value select the dataset and value field as imagebase64(calculated field)

set allow blank-true

set prompt-image

set hidden-true|||

I am having the same issue. The page header image shows in "Preview" but when exported to PDF it does not appear on any page, IE, the "red X" appears. The image works fine when exported to Excel.

Did you ever resolve this issue?

Thanks,

John

Databound Image to header...export issue

I followed the instructions from this post...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=384621&SiteID=1

on how to add databound images into a report header.

The issue I am encountering is exporting to PDF. If the report spans multiple pages, in PDF the image only shows up on the first page..and broken on all other pages.

I have tied the hidden image to the table that spans multiple pages. Shows ok in HTML but breaks when exported.

Thanks for any help.How did tie the hidden image to the table? Through RepeatWith? If so, the issue here is probably that RepeatWith is not supported in PDF. You can try adding a row to the table, mark it repeat on every page, and place the hidden image in the table row to make sure it gets repeated on each page.|||

try this

u can do that with the help of parameters

1) add a calculated field in dataset named imagebase64 in that add the following expression

Convert.ToBase64String(Fields!Photo.value)

2)Add report Parameter named image

set the datatype as string.

in the default value select the dataset and value field as imagebase64(calculated field)

set allow blank-true

set prompt-image

set hidden-true|||

I am having the same issue. The page header image shows in "Preview" but when exported to PDF it does not appear on any page, IE, the "red X" appears. The image works fine when exported to Excel.

Did you ever resolve this issue?

Thanks,

John

Databound Image to header...export issue

I followed the instructions from this post...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=384621&SiteID=1

on how to add databound images into a report header.

The issue I am encountering is exporting to PDF. If the report spans multiple pages, in PDF the image only shows up on the first page..and broken on all other pages.

I have tied the hidden image to the table that spans multiple pages. Shows ok in HTML but breaks when exported.

Thanks for any help.
How did tie the hidden image to the table? Through RepeatWith? If so, the issue here is probably that RepeatWith is not supported in PDF. You can try adding a row to the table, mark it repeat on every page, and place the hidden image in the table row to make sure it gets repeated on each page.|||

try this

u can do that with the help of parameters

1) add a calculated field in dataset named imagebase64 in that add the following expression

Convert.ToBase64String(Fields!Photo.value)

2)Add report Parameter named image

set the datatype as string. in the default value select the dataset and value field as imagebase64(calculated field) set allow blank-true set prompt-image set hidden-true|||

I am having the same issue. The page header image shows in "Preview" but when exported to PDF it does not appear on any page, IE, the "red X" appears. The image works fine when exported to Excel.

Did you ever resolve this issue?

Thanks,

John