Hi All to Readers,

I'm working  Asp.Net with C# & Generating Reports with SSRS-2005..

I'm Want to Know that Generating Reports in C# Using XML Files..

This is the XML file i'm having (test.xml)

<Log_Details>
           <Log PageName="Home.aspx" Time="10:30:20:32636"  Type="Sample" ID="1" Cat_ID="41" />

          <Log PageName="Home.aspx" Time="12:55:20:32636"  Type="Check" ID="4" Cat_ID="56" />

          <Log PageName="Home.aspx" Time="11:30:20:32636"  Type="Check" ID="8" Cat_ID="59" />

          <Log PageName="Home.aspx"Time="11:30:20:32636"   Type="Sample" ID="1" Cat_ID="44" />

------------------------------------------------------------------

------------------------------------------------------------------

------------------------------------------------------------------

--------------------------------------------------------------------

</Log_Details>

Now I want to Make Use of this XML File(test.xml) Data for Generating Reports..

I want to Generate Reports in Between

            Time-Type(Sample) 
      and Time-Type(Check) 
      and Time-Cat_ID

Here..
      'ID' in this XML file is related to Particular Type's ID( ie Sample-1 or Check-4 or Check-8 or --------)



How to do this..

Please Give Me the Suggestions in Doing This..

Thank You..

SQL Server 2005 supports an XML data type, and you can query against XML data using an XPATH like syntax.  SQL Server Reporting Services allows you to use whatever query you want to select out your data, so it sounds like its just a matter of getting the right query down and plugging it into your report.

Hi.,

Thanks For Your Reply..

How to Make Use of this XPATH like Syntax for Generating Reports.. How to Make this XML file into Query for Selecting Data..

Is it Necessary to Insert this XML Data into Database..