Reporting Services

A recent MSDN magazine article decribed SQL Server's Reporting Services.
Will Reporting Services work on MSDE?
TIA!
Wayne P.
No, you can't host Reporting Services on MSDE--it must be Standard Edition
or better. You CAN, however, extract data from MSDE databases and virtually
any other data source.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Wayne P." <infinite@.nospam-totalink.net> wrote in message
news:%23FzZKJobEHA.3476@.tk2msftngp13.phx.gbl...
> A recent MSDN magazine article decribed SQL Server's Reporting Services.
> Will Reporting Services work on MSDE?
> TIA!
> Wayne P.
>
|||Thanks for the info -
IMHO this is a shame - the toolset would have added a nice set of
functionality for smaller projects. Most of my clients end up using MSDE
solely due to the price of MS SQL.
Thanks again -
Wayne P.
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:eRtlsQobEHA.808@.tk2msftngp13.phx.gbl...
> No, you can't host Reporting Services on MSDE--it must be Standard Edition
> or better. You CAN, however, extract data from MSDE databases and
virtually
> any other data source.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Wayne P." <infinite@.nospam-totalink.net> wrote in message
> news:%23FzZKJobEHA.3476@.tk2msftngp13.phx.gbl...
>
|||In SQL Server 2005 we will have reporting services report controls included
in Visual Studio that will provide you report rendering, rather than server
functionality.
They will be free to redist as part of your app.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne P." <infinite@.nospam-totalink.net> wrote in message
news:#1ic7oobEHA.3804@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks for the info -
> IMHO this is a shame - the toolset would have added a nice set of
> functionality for smaller projects. Most of my clients end up using MSDE
> solely due to the price of MS SQL.
> Thanks again -
> Wayne P.
>
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:eRtlsQobEHA.808@.tk2msftngp13.phx.gbl...
Edition[vbcol=seagreen]
> virtually
> rights.
Services.
>
|||I look forward to the new version!
Wayne P.
"Euan Garden[MS]" <euang@.online.microsoft.com> wrote in message
news:emZeqvqbEHA.2544@.TK2MSFTNGP10.phx.gbl...
> In SQL Server 2005 we will have reporting services report controls
included
> in Visual Studio that will provide you report rendering, rather than
server
> functionality.
> They will be free to redist as part of your app.
> --
> -Euan
> Please reply only to the newsgroup so that others can benefit. When
posting,
> please state the version of SQL Server being used and the error
number/exact
> error message text received, if any.
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "Wayne P." <infinite@.nospam-totalink.net> wrote in message
> news:#1ic7oobEHA.3804@.TK2MSFTNGP10.phx.gbl...
MSDE
> Edition
> Services.
>

Reporting off ADO.NET datasets

hi,

I am trying to implement this:
http://blogs.msdn.com/bimusings/archive/2006/03/24/560026.aspx

my web service seems to work because i can view the data in the page when i invoke the public web method i created.

i'm trying to retreive the data and use it as the dataset in a report. this is my query string:
<Query>

<ElementPath IgnoreNamespaces="True">
GiveMeDataResponse {}/
GiveMeDataResult/diffgram{}/
Results {}/Table {CompanyID, CompanyName, ABN, Abbreviation}
</ElementPath>

<SoapAction>
http://tempuri.org/GiveMeData
</SoapAction>
<Method Namespace="http://tempuri.org/"
Name="GiveMeData">
</Method>
</Query>

When i try to run the query, it returns my four columns, but there is no data in the columns. it just returns one empty row.

what am i doing wrong?i don't know what i was doing wrong, but i got the example working.

But now i have a new problem and was hoping someone can help me?

I'm still following this example:
http://msdn2.microsoft.com/en-us/library/aa337489.aspx

I've changed the web method to return a dataset that has a datatable added to it. here is my code:

DataSet ds = new DataSet("Results");

DataTable dt = new DataTable("Results");

dt.Columns.Add("FirstName");
dt.Columns.Add("LastName");
dt.Columns.Add("Address");
dt.Columns.Add("City");
dt.Columns.Add("State");
dt.Columns.Add("PhoneNumber");

DataRow row = dt.NewRow();
row["FirstName"] = "Bob";
row["LastName"] = "The Builder";
row["Address"] = "10 My Street";
row["City"] = "Sydney";
row["State"] = "NSW";
row["PhoneNumber"] = "123456";
dt.Rows.Add(row);

ds.Tables.Add(dt);

return ds;

the query in Reporting Services doesn't return any data. It doesn't throw an error, it just returns one empty row.

Thanks for your help.