Is it possible to use Dataset with Sql Reporting Services ?

[Oney]

Sql Reporting Services uses sql command and stored procedures to
prepare report. but I need to use dataset to manipulate data in a
class. So is
it possible with Sql Reporting Services ?

Thanks

[Scott Allen]

Hi Oney:

Yes, you'll have to build a data processing extension (DPE). Christa C
has an article on this very subject:
http://msdn.microsoft.com/sql/defaul.../rsdsetex3.asp

--
Scott
http://www.OdeToCode.com/blogs/scott/
On 11 Nov 2004 04:39:34 -0800, oz*********@yah oo.com (Oney) wrote:

Sql Reporting Services uses sql command and stored procedures to
prepare report. but I need to use dataset to manipulate data in a
class. So is
it possible with Sql Reporting Services ?

Thanks

[Oney]

I read that article and done it but on the report project on Shared
Data Source window, "DataSet Data Extension" Type doesn't appear!

I compiled the the project and paste ReportServer bin folder and
ReportDesigner bin folder. After I added RSReportServer. config file

<Extension Name="DataSet"
Type="Microsoft .Samples.Report ingServices.Dat aSetExtension.D SXConnection,RS CustomData"> <Configuratio n> <XSDConfigurati on><XSDFile>C:\ Customer.xsd</XSDFile> </XSDConfiguratio n></Configuration></Extension>
in Data tag

then i added to RSReportDesigne r.config file
<Extension Name="DataSet"
Type="Microsoft .ReportDesigner .Design.Generic QueryDesigner,M icrosoft.Report ingServices.Des igner"/>

in data tag and designer tag

atfer that

I added rspreviewpolicy .config file in ReportDesigner and ReportServer

<CodeGroup class="UnionCod eGroup"
version="1"
PermissionSetNa me="FullTrust"
Name="DataSetEx tensionGroup"
Description="Th is code group grants data extensions full trust.">
<IMembershipCon dition
class="UrlMembe rshipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Re porting
Services\Report Server\bin\RSCu stomData.dll"
/>
</CodeGroup>

what is wrong ?

C:\Customer.xsd is exist
by the way I use evaluation version
oz*********@yah oo.com (Oney) wrote in message news:<cc******* *************** ****@posting.go ogle.com>...

Sql Reporting Services uses sql command and stored procedures to
prepare report. but I need to use dataset to manipulate data in a
class. So is
it possible with Sql Reporting Services ?

Thanks

[Scott Allen]

Hi Oney:

It sounds as if you have done everything correctly. You might want to
check the report server log files to see if they indicate any errors
or problems.

One thing I've always had to double and triple check are the policy
files. Did you put the new CodeGroup just after the CodeGen membership
group?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On 12 Nov 2004 03:12:43 -0800, oz*********@yah oo.com (Oney) wrote:

I read that article and done it but on the report project on Shared
Data Source window, "DataSet Data Extension" Type doesn't appear!

I compiled the the project and paste ReportServer bin folder and
ReportDesign er bin folder. After I added RSReportServer. config file

<Extension Name="DataSet"
Type="Microsof t.Samples.Repor tingServices.Da taSetExtension. DSXConnection,R SCustomData"> <Configuratio n> <XSDConfigurati on><XSDFile>C:\ Customer.xsd</XSDFile> </XSDConfiguratio n></Configuration></Extension>
in Data tag

then i added to RSReportDesigne r.config file
<Extension Name="DataSet"
Type="Microsof t.ReportDesigne r.Design.Generi cQueryDesigner, Microsoft.Repor tingServices.De signer"/>

in data tag and designer tag

atfer that

I added rspreviewpolicy .config file in ReportDesigner and ReportServer

<CodeGroup class="UnionCod eGroup"
version="1"
PermissionSetN ame="FullTrust"
Name="DataSetE xtensionGroup"
Description="T his code group grants data extensions full trust.">
<IMembershipCo ndition
class="UrlMemb ershipCondition "
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Re porting
Services\Repor tServer\bin\RSC ustomData.dll"
/>
</CodeGroup>

what is wrong ?

C:\Customer.xs d is exist
by the way I use evaluation version