Reporting Server Project 2005 - xml datasource - Querying the data

The way I create the report is I use VS2005 to create the RDL programmatically on the fly. The problem is querying the data when I use XML as a data source (changing the data source is not an option).

I can connect to the XML data source, I enter a basic query in the data tab in VS 2005 and what happens is for some reason or another the above element in XML gets concatenated onto the column name in the result set.

So what I have to do is manually modify the RDL file to accept the new names and then the report works. There has to be a way to not have this happens. Any advice on where I can find information on how to do this would be greatly appreciated. Examples are always welcome.

See below for an example of what I did and an example of the XML data.

XML File Example:
<data>
<Table>
<iss_id>Test Data1</issu_id>
<issue_nm>Test Data1</issue_nm>
</Table>
<Table>
<iss_id>Test Data2</issu_id>
<issue_nm>Test Data2</issue_nm>
</Table>
<data>

XML Query: (I enter this in the data tab in VS 2005)
data/Table

Result:

Table_iss_id Table_issue_nm <--Column Headers
Test Data1 Test Data1
Test Data2 Test Data2

I think it has to do with the webservice web method, and how it needs to be set-up for serializing the parameters correctly to work with the XML data Source. I am having a similar problem which I am documenting here

http://forums.microsoft.com/MSDN/User/MyForums.aspx?SiteID=1

J. C.

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, Chris
If you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>
|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>
|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
about
able
>

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, ChrisIf you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
--
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> > Howdy all. I just started a new job and am suddenly having to write
> > queries
> > for users on the fly and put the results into Excel. I was thinking
about
> > denormalizing the db(although there isn't really much normalization now)
> > into just a few tables that users would be able to understand and be
able
> > to
> > query for themselves. Then have some great tool that would be able to do
> > queries and export to Excel. Perhaps using drag and drop, check boxes,
> > etc.
> > Is there such a tool already for SQL?
> >
> > TIA, Chris
> >
> >
>

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, ChrisIf you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
about
able
>