Extract a complete XML section and sub sections

Ive been using select statments to get information from each 'section'.
example below shows only for the Header section.
EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.TESTXML
Select * from OpenXML(@.hDoc, '//Header') with
(reportType varchar(10), reportNumber VarChar(6), batchNumber varchar(6),
reportSequenceNumber varchar(6), userNumber varchar(6) )
EXEC sp_xml_removedocument @.hDoc
the following section of the file has sub sections contained within the
Header section, Is there a simple way to return all the data values in one
SQL ?
- <Header reportType="REFT2013" reportNumber="14685" batchNumber="023"
reportSequenceNumber="000760" userNumber="948053">
<ProducedOn time="17:31:38" date="2004-09-27" />
<ProcessingDate date="2004-09-28" />
</Header>
You can specify relative XPaths for the columns in the subelements, as shown
below. Is that what you mean?
DECLARE @.TESTXML nvarchar(2000)
DECLARE @.hDoc integer
SET @.TESTXML =
'<Header reportType="REFT2013" reportNumber="14685" batchNumber="023"
reportSequenceNumber="000760" userNumber="948053">
<ProducedOn time="17:31:38" date="2004-09-27" />
<ProcessingDate date="2004-09-28" />
</Header>'
EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.TESTXML
Select * from OpenXML(@.hDoc, '//Header', 1)
with
(reportType varchar(10),
reportNumber VarChar(6),
batchNumber varchar(6),
reportSequenceNumber varchar(6),
userNumber varchar(6),
ProducedOnTime nvarchar(10) 'ProducedOn/@.time',
ProducedOnDate nvarchar(20) 'ProducedOn/@.date',
ProcessingDate nvarchar(20) 'ProcessingDate/@.date' )
EXEC sp_xml_removedocument @.hDoc
Cheers,
Graeme
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Peter Newman" <PeterNewman@.discussions.microsoft.com> wrote in message
news:4CD137BC-09E8-42A8-BC86-6C6991EA979C@.microsoft.com...
Ive been using select statments to get information from each 'section'.
example below shows only for the Header section.
EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.TESTXML
Select * from OpenXML(@.hDoc, '//Header') with
(reportType varchar(10), reportNumber VarChar(6), batchNumber
varchar(6),
reportSequenceNumber varchar(6), userNumber varchar(6) )
EXEC sp_xml_removedocument @.hDoc
the following section of the file has sub sections contained within the
Header section, Is there a simple way to return all the data values in one
SQL ?
- <Header reportType="REFT2013" reportNumber="14685" batchNumber="023"
reportSequenceNumber="000760" userNumber="948053">
<ProducedOn time="17:31:38" date="2004-09-27" />
<ProcessingDate date="2004-09-28" />
</Header>
sql

Extra white space in table

I've got a table with a header, group, and detail row. The detail row
is collaspable however when it's collasped there is several lines of
white space between the parent groups. How do I get rid of this white
space?
Thanks in advance for the helpIs it possible that the white space is really the detail row, and it is
not shrinking as expected? (I've had this same problem before...) If
you are supressing just a column or two, but not hiding the entire
detail row (such as setting visibility --> hidden property based upon
conditional expression) then you will get the spacing issue as
described.|||Thanks Matt
That was the problem. I was setting the visibility at the cell level
when i should have been setting it on the over all row. thanks for the
help
Mathiassql

Extra columns in Excel with SP2

I would like to upgrade to Reporting Services service pack 2 so that I can
specify report colours and specify to move the header into Excel's header.
However when we upgrade to Service Pack 2 it causes extra totals columns to
appear at the end of the months in the generated reports. These columns
could possibly acceptable if they were titled as Total however they are not.
Can anybody make any suggestions in how to generate the report in excel
without the additional columns appearing in the excel output? Many thanks.Does anybody have any ideas about how to do this - any guesses even would be
appreciated. Thanks
"Nicola Jones" wrote:
> I would like to upgrade to Reporting Services service pack 2 so that I can
> specify report colours and specify to move the header into Excel's header.
> However when we upgrade to Service Pack 2 it causes extra totals columns to
> appear at the end of the months in the generated reports. These columns
> could possibly acceptable if they were titled as Total however they are not.
> Can anybody make any suggestions in how to generate the report in excel
> without the additional columns appearing in the excel output? Many thanks.

External image problem when sorting in table

Reporting Services I am using external image png as my header for reports When i am clicking on sort row of the report the header image is dissapeared.Though it is working well in Visual Studio 2005 the problem is occuring after deploying it in reportserver.

What the reason and how can i remove this error.It was working well when i had embeded the image..But i need to have external image only..

Did you install SP1 on the report server (http://www.microsoft.com/sql/sp1.mspx)?

-- Robert

External Image disappears with Interactive Sorting

Hi,

I have an image in the page header that is included in the project and is defined as "external". I also have interactive sorting enabled for the report. When a column is sorted, the image in the page header disappears. I deleted the image from the report and re-created it as "embedded" which does retain the image between postbacks.

Thank you,

Bob

Thank you Bob. This issue will be fixed in SP2 of RS 2005. If you have a pressing need, a hotfix has been released that product support services has.|||

Thank you Brad, I can live with this work around until SP2. In pre-SP1, I liked the "Select All" feature in multivalued parameters. In SP2, will this be available again? Will there be an option to turn this on and off, I hope?

|||

There is a post-SP1 hotfix which will restore the "Select All" option exactly the way it was in RTM. You will need to contact Microsoft product support (http://www.microsoft.com/services/microsoftservices/srv_support.mspx) to receive the SP1-based hotfix.

-- Robert

|||

Robert,

I installed the sequence of post-SP1 Hotfixes (including the one for SSRS) accessible through the link you provided, but this did not restore the 'Select All' capability. I called the support line and they could not provide any assistance without a reference # for the fix. Can you provide a bit more information on what needs to be installed/configured to restore the 'Select All' capability?

For reference: http://support.microsoft.com/kb/918222 is where I found the Hot Fix package.

Thanks in advance,

Bob Mack - HP

|||

Sql Hotfix #803 - but you may need to wait a few more days because a new package is currently being built.

-- Robert

|||Any update on the availability of this Hotfix?

Expression to Parameter

I would like my header text not to be hard coded

I took a very big table which include texts i need from my DB to DS

How can i pick a single row with single data in it to be bind

to my Paramter ?

Could you explain this in more detail ?

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Exporting to HTML with Images

I have added our logo to the header of a crystal report. I am trying to export it to html 4.0, but it creates a .png file for each page of the report. This would be fine except that when the report is refreshed and re-exported it creates a new set of .png files instead of overwriting the old ones. Does anyone know a way around this?See if you find answer here

http://support.businessobjects.com/

Exporting to Excel

Hi guys,
I have set up a report that exports perfectly into PDF,
but not into Excel.
The report contains a table with:
- a standard table header
- a table row: with alternating logos & a textbox directly
next to it
- a details area
- a table footer
(By alternating logos, I am referring to having different
images placed into a rectangle and different logos will
appear depending on certain conditions).
The problem: When exported into Excel, the logo/image does
not appear on the same row as the textbox that is directly
next to it. And the rest of the details from the table
gets pushed a few rows down.
Any info would be appreciated.
Regards,
LisaNo takers from Microsoft on this one?
Regards,
Lisa
"Lisa Liputra" wrote:
> Hi guys,
> I have set up a report that exports perfectly into PDF,
> but not into Excel.
> The report contains a table with:
> - a standard table header
> - a table row: with alternating logos & a textbox directly
> next to it
> - a details area
> - a table footer
> (By alternating logos, I am referring to having different
> images placed into a rectangle and different logos will
> appear depending on certain conditions).
> The problem: When exported into Excel, the logo/image does
> not appear on the same row as the textbox that is directly
> next to it. And the rest of the details from the table
> gets pushed a few rows down.
> Any info would be appreciated.
> Regards,
> Lisa
>
>
>

exporting to a pdf problem

HI everybody, my problem is that when i export to a pdf file i get on first page cut of info and the second page I just get a header and footer. Is there anything to do to fix this problemWould you please post your RDL and the PDF file. If you are using SP1, would
you also post the <ReportName>.rdl.data file.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-man" <J-man@.discussions.microsoft.com> wrote in message
news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
> HI everybody, my problem is that when i export to a pdf file i get on
first page cut of info and the second page I just get a header and footer.
Is there anything to do to fix this problem|||Just checking - are you running SP1?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-man" <J-man@.discussions.microsoft.com> wrote in message
news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
> HI everybody, my problem is that when i export to a pdf file i get on
> first page cut of info and the second page I just get a header and footer.
> Is there anything to do to fix this problem|||Well, if you didn't apply SP1 you are probably not running it. When you
browse to http://servername/reportserver, what version do you see? If it
says 878, you are running SP1. If it says 743, you are running RTM. You can
install SP1 from the link off http://www.microsoft.com/sql/reporting.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"j-man" <j-man@.discussions.microsoft.com> wrote in message
news:A76A0B7C-3A01-4CFB-B43A-1D0485E847E0@.microsoft.com...
>I have no clue, I'm just a dumb kid. How would i find this out?
> "Brian Welcker [MSFT]" wrote:
>> Just checking - are you running SP1?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "J-man" <J-man@.discussions.microsoft.com> wrote in message
>> news:4F0ECF86-1C7B-4B53-ACA7-0F39C7EEC81F@.microsoft.com...
>> > HI everybody, my problem is that when i export to a pdf file i get on
>> > first page cut of info and the second page I just get a header and
>> > footer.
>> > Is there anything to do to fix this problem
>>