Dataset to XML

Hi
I have an SQL Server stored procedure wich returns ceratin data and I have
it in a Dataset. I am supposed to change that data into an specific standard
XML format and write it to file.
I am using Visual Studio 2005 wich is completely new to me.
Could you help with some hints about how can I do that.
I have been looking a lot about this from the Net but every thing I have
found is very simple: GetXml() But that is not enough for me. I need to
change that XML so that I get it in the previously defined standard format
Thanks for any help
GabrielHello Gabriel,
Likely the fastest way to deal with this would be the write an XSL/T that
transforms the dataset XML to the desired format. Otherwise, if you have
SQL Server 2005 and are allowed to replace the stored procedure, you could
write a FOR XML PATH query and probably get pretty close to what you're look
ing
for straight out of SQL Server.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||Thanks a lot Kent.
I am completely new in this field and I have to study a lot. Your message
give me good hints to to start with.
greetings from Finland
Gabriel
"Kent Tegels" wrote:

> Hello Gabriel,
> Likely the fastest way to deal with this would be the write an XSL/T that
> transforms the dataset XML to the desired format. Otherwise, if you have
> SQL Server 2005 and are allowed to replace the stored procedure, you could
> write a FOR XML PATH query and probably get pretty close to what you're lo
oking
> for straight out of SQL Server.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>sql

Dataset to XML

Hi
I have an SQL Server stored procedure wich returns ceratin data and I have
it in a Dataset. I am supposed to change that data into an specific standard
XML format and write it to file.
I am using Visual Studio 2005 wich is completely new to me.
Could you help with some hints about how can I do that.
I have been looking a lot about this from the Net but every thing I have
found is very simple: GetXml() But that is not enough for me. I need to
change that XML so that I get it in the previously defined standard format
Thanks for any help
Gabriel
Hello Gabriel,
Likely the fastest way to deal with this would be the write an XSL/T that
transforms the dataset XML to the desired format. Otherwise, if you have
SQL Server 2005 and are allowed to replace the stored procedure, you could
write a FOR XML PATH query and probably get pretty close to what you're looking
for straight out of SQL Server.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
|||Thanks a lot Kent.
I am completely new in this field and I have to study a lot. Your message
give me good hints to to start with.
greetings from Finland
Gabriel
"Kent Tegels" wrote:

> Hello Gabriel,
> Likely the fastest way to deal with this would be the write an XSL/T that
> transforms the dataset XML to the desired format. Otherwise, if you have
> SQL Server 2005 and are allowed to replace the stored procedure, you could
> write a FOR XML PATH query and probably get pretty close to what you're looking
> for straight out of SQL Server.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>

Dataset row access

I'm trying to get a value from a specific row something like:-
=Fields[2]!Data.Value
where the 2 is the row of data i'm after.
Any ideas? TIA,
DFCould you please elaborate on your scenario so I can sugest a solution?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan Fell" <DanFell@.discussions.microsoft.com> wrote in message
news:8F7D8141-5919-4BA3-AF72-DCAD67EE9FEB@.microsoft.com...
> I'm trying to get a value from a specific row something like:-
> =Fields[2]!Data.Value
> where the 2 is the row of data i'm after.
> Any ideas? TIA,
> DFsql

Data-driven Subscription e-mail problem

Trying to test a data-driving subscription for 5 records for a specific
report. Run report interactively successfully in report services. Can't
figure out why e-mail is not being sent (set my e-mail address for all 5).
Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer info
set correctly in rsReportServer Config file. Viewed the
ReportServer(date).log file and no information listed, checked windows
application log and report server is being activated successfully. Any
suggestions' Thanks. JanineAre you running RS on a Windows Server 2003? If so, I think that there is a
known issue that can be solved with a hotfix. We had a similar problem and it
wasn't the RS configuration that was causing the problem rather it was an
issue with Windows Server 2003. Sorry that I do not have any additional info.
"JanineB1129" wrote:
> Trying to test a data-driving subscription for 5 records for a specific
> report. Run report interactively successfully in report services. Can't
> figure out why e-mail is not being sent (set my e-mail address for all 5).
> Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer info
> set correctly in rsReportServer Config file. Viewed the
> ReportServer(date).log file and no information listed, checked windows
> application log and report server is being activated successfully. Any
> suggestions' Thanks. Janine|||Do regular subscriptions work?
You need to look in the reportserverservice<date>.log file for the errors.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:02470CE4-B6B0-48E5-B387-BF0691124515@.microsoft.com...
> Are you running RS on a Windows Server 2003? If so, I think that there is
a
> known issue that can be solved with a hotfix. We had a similar problem and
it
> wasn't the RS configuration that was causing the problem rather it was an
> issue with Windows Server 2003. Sorry that I do not have any additional
info.
> "JanineB1129" wrote:
> > Trying to test a data-driving subscription for 5 records for a specific
> > report. Run report interactively successfully in report services. Can't
> > figure out why e-mail is not being sent (set my e-mail address for all
5).
> > Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer
info
> > set correctly in rsReportServer Config file. Viewed the
> > ReportServer(date).log file and no information listed, checked windows
> > application log and report server is being activated successfully. Any
> > suggestions' Thanks. Janine