Data fields are not allowed in the Page Header section

How can I build the page header (Sales for John Smith) where John Smith is
returned in the query results? Data fields are not allowed in the Page
Header section.
All responses greatly appreciated.
--
Any and all contributions are greatly appreciated ...
Regards TJYou can use read-only parameter with default value from query (assuming that
you render separate instance of report for every person)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TJ" <nospam@.nowhere.com> wrote in message
news:O2Mt1aNoEHA.3564@.tk2msftngp13.phx.gbl...
> How can I build the page header (Sales for John Smith) where John Smith is
> returned in the query results? Data fields are not allowed in the Page
> Header section.
> All responses greatly appreciated.
> --
> Any and all contributions are greatly appreciated ...
> Regards TJ
>
>

Data contained in a CDATA Section in XML is lost

I know that anything in a CDATA section will be ignored by an XML parser. Does that hold true for the SSIS XML Source?

I am trying to import a large quantity of movie information and all of the reviews, synopsis, etc are contained in CDATA. example:

<synopsis size="100"><![CDATA[Four vignettes feature thugs in a pool hall, a tormented ex-con, a cop and a gangster.]]></synopsis>

Sounds like a good one, no?

The record gets inserted into the database however it contains a NULL in the field for the synopsis text. I would imagine that the reason for this would fall at the feet of CDATA's nature and that SSIS is ignoring it.

Any thoughts would be appreciated. Thanks.

Yes, this is a known issue in RTM (due to a bug in the reader XMLSource adapter calls behind the scene), it should be fixed in SP1 already. Please let us know if you still see issues after applying SP1.

Thanks

Wenyang

Data contained in a CDATA Section in XML is lost

I know that anything in a CDATA section will be ignored by an XML parser. Does that hold true for the SSIS XML Source?

I am trying to import a large quantity of movie information and all of the reviews, synopsis, etc are contained in CDATA. example:

<synopsis size="100"><![CDATA[Four vignettes feature thugs in a pool hall, a tormented ex-con, a cop and a gangster.]]></synopsis>

Sounds like a good one, no?

The record gets inserted into the database however it contains a NULL in the field for the synopsis text. I would imagine that the reason for this would fall at the feet of CDATA's nature and that SSIS is ignoring it.

Any thoughts would be appreciated. Thanks.

Yes, this is a known issue in RTM (due to a bug in the reader XMLSource adapter calls behind the scene), it should be fixed in SP1 already. Please let us know if you still see issues after applying SP1.

Thanks

Wenyang

Customizing report manager

I need to place a jpeg image of our company logo in the middle section of the Report Manager heading between the wording of "reporting services" and Home | My Subscriptions | Site Settings | Help

I am using SQL Reporting Services 2005 with SQL Server 2005 SRV Pack 2

Can someone point me in the right direction?

This is not possible. Report Manager was not designed to be customizable.

You can only edit the stylesheet (css) or replace some of the existing images (fixed size) by going to the installation directory and looking in the styles and images directories.

|||

I was able to accomplish what you are describing by:

1) Adding a custom image to the /images directory of the Report Manager virtual directory

2) Adding the following code to the ReportingServices.css stylesheet in the /styles directory of the Report Manager virtual directory:

#ui_sharedArea
{
background-image: url(..\images\{imagefilename.gif});
background-repeat: no-repeat;
background-position: center;
}

where imagefilename is the name of the image file you used in step 1

Customizing report manager

I need to place a jpeg image of our company logo in the middle section of the Report Manager heading between the wording of "reporting services" and Home | My Subscriptions | Site Settings | Help

I am using SQL Reporting Services 2005 with SQL Server 2005 SRV Pack 2

Can someone point me in the right direction?

This is not possible. Report Manager was not designed to be customizable.

You can only edit the stylesheet (css) or replace some of the existing images (fixed size) by going to the installation directory and looking in the styles and images directories.

|||

I was able to accomplish what you are describing by:

1) Adding a custom image to the /images directory of the Report Manager virtual directory

2) Adding the following code to the ReportingServices.css stylesheet in the /styles directory of the Report Manager virtual directory:

#ui_sharedArea
{
background-image: url(..\images\{imagefilename.gif});
background-repeat: no-repeat;
background-position: center;
}

where imagefilename is the name of the image file you used in step 1