
Signature
Alexander L. Wykel
AW Software Works
> I’m starting a new project which will dynamically generate (user will have to
> pick and choose data, then generate the XML dynamically) RDLC for Reporting.
> My approach was to use LINQ to XML for the API. My question is what is the
> best API to use? Performance is no concern, most critical factor is that the
> code be easy to maintain easy to dynamically generate the mark-up for the
> RDLC.
I am not familiar with RDLC but using LINQ to XML (XDocument,XElement)
should be easier to work with than DOM (XmlDocument,XmlElement). If you
want to create new XML document then there is also XmlWriter as an option.

Signature
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
Alexander Wykel - 08 May 2008 19:10 GMT
RDLC is the Report Definition Language Client-side that SQL Server uses it's
an XML format. I will put a post about dynamic RDLC in at the SQL Group
reporting group.

Signature
Alexander L. Wykel
AW Software Works
> > I’m starting a new project which will dynamically generate (user will have to
> > pick and choose data, then generate the XML dynamically) RDLC for Reporting.
[quoted text clipped - 6 lines]
> should be easier to work with than DOM (XmlDocument,XmlElement). If you
> want to create new XML document then there is also XmlWriter as an option.
Wen Yuan Wang [MSFT] - 09 May 2008 07:32 GMT
Thanks for Martin's prompt reply.
Hello Alexander,
As you see, RDLC is a well formatted XML file. In general, we use
XmlTextWriter class which provides several methods that are useful for
creating a report definition file, as the sample showed in SQL SSRS online
book. Moreover, Linq to XML is also an option, because the code is easier
to maintain and read. Submitting the issue on SQL Reporting Group could
also be a good choice. This is becasue the people in those groups will be
more likely to be able to help and familiar in such field.
http://msdn.microsoft.com/en-us/library/ms170667.aspx
[Tutorial: Generating RDL Using the .NET Framework]
Anyway, if you have any more concern, please also feel free to let us know.
We are glad to assist you.
Hope this helps.
Best regards,
Wen Yuan
Microsoft Online Community Support
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.com.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Alexander Wykel - 09 May 2008 17:58 GMT
With the addition of the new API's it's not always clear shich one shoukd be
used. I was all for LINq to XML but if there was a better approach I would
have swayed in that direction. Thank you for your input!

Signature
Alexander L. Wykel
AW Software Works
> Thanks for Martin's prompt reply.
>
[quoted text clipped - 26 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.