DPE method error; passing DS persisted As XML

Hello,
I am using Teo Lachev's DPE and have done the following so far.
Added the datasource with 'Nothing' in query. Also the @.datasource parameter
is taking a path to the xsd file that i created off the dataset that i will
use. The designer has the fields setup on the report.
Through code, based on parameters I am forming a dataset that i write to an
xml (this contains the same elements and schema as the xsd).
Then..
DataSet dsDataSet = new DataSet();
dsDataSet.ReadXml(@."C:\FSChartSampleDS.xml", System.Data.XmlReadMode.Auto);
parameters[0] = new ParameterValue();
parameters[0].Name = "DataSource";
parameters[0].Value = dsDataSet.GetXml();
followed by a call to the render function. Here the call fails with this
error:
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.NullReferenceException: Object reference not set to an instance of an
object.\n at
AWC.RS.Extensions.DataExtensions.DsDataReader.GetOrdinal(String name)\n at
Microsoft.ReportingServices.DataExtensions.MappingDataReader..ctor(String
dataSetName, IDataReader sourceReader, String[] aliases, String[]
fieldNames)\n at
Microsoft.ReportingServices.ReportProcessing.g..ctor(String A_0, IDataReader
A_1, String[] A_2, String[] A_3)\n at
Microsoft.ReportingServices.ReportProcessing.a0.v()\n at
Microsoft.ReportingServices.ReportProcessing.aw.c()\n at
Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)\n at
Microsoft.ReportingServices.ReportProcessing.aw.b()\n at
Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)\n -- End of
inner exceptionsolved this myself
"google" wrote:
> Hello,
> I am using Teo Lachev's DPE and have done the following so far.
> Added the datasource with 'Nothing' in query. Also the @.datasource parameter
> is taking a path to the xsd file that i created off the dataset that i will
> use. The designer has the fields setup on the report.
> Through code, based on parameters I am forming a dataset that i write to an
> xml (this contains the same elements and schema as the xsd).
> Then..
> DataSet dsDataSet = new DataSet();
> dsDataSet.ReadXml(@."C:\FSChartSampleDS.xml", System.Data.XmlReadMode.Auto);
> parameters[0] = new ParameterValue();
> parameters[0].Name = "DataSource";
> parameters[0].Value = dsDataSet.GetXml();
> followed by a call to the render function. Here the call fails with this
> error:
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
> occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
> error has occurred during report processing. -->
> System.NullReferenceException: Object reference not set to an instance of an
> object.\n at
> AWC.RS.Extensions.DataExtensions.DsDataReader.GetOrdinal(String name)\n at
> Microsoft.ReportingServices.DataExtensions.MappingDataReader..ctor(String
> dataSetName, IDataReader sourceReader, String[] aliases, String[]
> fieldNames)\n at
> Microsoft.ReportingServices.ReportProcessing.g..ctor(String A_0, IDataReader
> A_1, String[] A_2, String[] A_3)\n at
> Microsoft.ReportingServices.ReportProcessing.a0.v()\n at
> Microsoft.ReportingServices.ReportProcessing.aw.c()\n at
> Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)\n at
> Microsoft.ReportingServices.ReportProcessing.aw.b()\n at
> Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)\n -- End of
> inner exception

DPE Error running on report Server

We created a DPE to pull data off a Web Service to be used as a datasource in
the reports we create. We created and added the code group to the
rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
name to the Data section of the RSReportServer.config file. The report works
correctly in debug designer mode but we receive the following error when
trying to run the report through the report manager or report server.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
Get Online Help
Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.Check the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We created a DPE to pull data off a Web Service to be used as a datasource in
> the reports we create. We created and added the code group to the
> rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
> name to the Data section of the RSReportServer.config file. The report works
> correctly in debug designer mode but we receive the following error when
> trying to run the report through the report manager or report server.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
> Get Online Help
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
>

DPE Error on Report Server

We have created a DPE that returns data from a Web Services and uses it as
the datasource in the reports. We have changed the config files and added
the code group also added the name to the data section of the
rsreportserver.config file. We have strong named the dll and added it to the
GAC. The report runs fine in debug designer mode but will not run through
the report server or report manager. We get the following error.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
An attempt has been made to use a data extension 'ISIS WS Data' that is not
registered for this report server. (rsDataExtensionNotFound) Get Online HelpCheck the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We have created a DPE that returns data from a Web Services and uses it as
> the datasource in the reports. We have changed the config files and added
> the code group also added the name to the data section of the
> rsreportserver.config file. We have strong named the dll and added it to the
> GAC. The report runs fine in debug designer mode but will not run through
> the report server or report manager. We get the following error.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> An attempt has been made to use a data extension 'ISIS WS Data' that is not
> registered for this report server. (rsDataExtensionNotFound) Get Online Help
>|||I did all that I'm now getting a 401 unauthorized error.
"Jerry" wrote:
> Check the documentation about how to deploy a similar DPE.
> [WebService Data Processing Extension]
> http://www.rdlcomponents.com/DTE/default.aspx
> Thanks
> Jerry
> "Deb Taylor" wrote:
> > We have created a DPE that returns data from a Web Services and uses it as
> > the datasource in the reports. We have changed the config files and added
> > the code group also added the name to the data section of the
> > rsreportserver.config file. We have strong named the dll and added it to the
> > GAC. The report runs fine in debug designer mode but will not run through
> > the report server or report manager. We get the following error.
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> >|||Generally this error message means you need to log on (enter a valid user ID
and password) somewhere first. If you have just entered these and then
immediately see a 401 error, it means that one or both of your user ID and
password were invalid for whatever reason (entered incorrectly, user ID
suspended etc.).
Jerry
--
[Call a WebService from SQL Server 2000]
www.rdlcomponents.com
"Deb Taylor" wrote:
> I did all that I'm now getting a 401 unauthorized error.
> "Jerry" wrote:
> > Check the documentation about how to deploy a similar DPE.
> >
> > [WebService Data Processing Extension]
> > http://www.rdlcomponents.com/DTE/default.aspx
> >
> > Thanks
> > Jerry
> >
> > "Deb Taylor" wrote:
> >
> > > We have created a DPE that returns data from a Web Services and uses it as
> > > the datasource in the reports. We have changed the config files and added
> > > the code group also added the name to the data section of the
> > > rsreportserver.config file. We have strong named the dll and added it to the
> > > GAC. The report runs fine in debug designer mode but will not run through
> > > the report server or report manager. We get the following error.
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> > >

don't see the "data driven subscriptions" button

hi all,

i built my report with BIDS, configured my datasource and report. then i deployed it. on http://localhost/reports, I to go to the Report, but under "subscriptions", I don't see the "create data driven subscriptions" button.

however, under properties/datasources of my report, I clearly configured the
"Credentials stored securely in the report server"-setting.

Did I forgot something?

Thx

Hello,

What version of SQL Server are you running? Data-driven subscriptions are only available in Enterprise edition.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Jarret

|||damn, i looked at my installation CD, and I see that it is "standard edition" that i have.
:-(

thanks anyway. now i can stop finally stop investigating.

again, I've almost lost day with these reporting services :-(

doing selectparameter at the back end code

Hi, How do u do selectparameter at the back end code?

I am facing this problem of the gridview not being able to find the datasource in the accordionpane so i decided to move the datasource out of the accordionpane.
However, since the gridview's datasource is linked to another gridview in the accordionpane, I will need to do a selectParameter to connect both gridviews.

The gridview using the datasource is called basicBookDetails.
The gridview to be linked with basicBookDetails is called book.
Book_List_ID is the datakeynames for both gridview book and basicBookDetails.

Can someone help me with this problem? Thanks.

This is the query statement that I used.

SELECT book_details.Status, book_list.Book_List_ID, Circulation_Type, book_details.Book_Details_ID, CONCAT(rockwell.book_list.Title, IFNULL(CONCAT(', ', edition.Edition_Name), ' ')) AS Title FROM book_list, edition, book_details, circulation_type WHERE (edition.Edition_ID = book_details.Edition_ID) AND (circulation_type.Circulation_ID = edition.Circulation_ID) AND (edition.book_list_id = book_list.Book_List_ID) AND (book_list.Book_List_ID = ?)

Hi There,

You can actually set your datasource select statement parameter on code-behind like below:

on your code behind, get the Book_List_ID and set it to your datasource

basicBookDetails.SelectParameters[0].DefaultValue ="YourParameterHere";

Hope this is help

|||

Hi,

Do you mind explaining a bit about what u said as I am a bit lost.
Am I also supposed to do changes to the query also after I add in the select statement parameter?
Do I need to declare a new parameter to input in the "YourParameterHere" or do i directly use Book_List_ID and place it inside?

Thanks.

|||

Hi There,

Correct me if im wrong, I guess you are doing something like Master / Detail with Gridview ?

So when you expand the detail, you set the parameter for the particular selected row so that it returns the correct value for the detail.

"Am I also supposed to do changes to the query also after I add in the select statement parameter?"

You don't need to change the query

"Do I need to declare a new parameter to input in the "YourParameterHere" or do i directly use Book_List_ID and place it inside?"

You do not need to declare new paramter, just set whatever value you get from the master in this case Book_List_ID

|||

The first gridview has a link button which is used to link to the 2nd gridview.
Meaning that gridview 1 is the master and gridview 2 is the details page and they are linked through datakeynames book_list_id.

I've gotten an exception when i run the page.
The exception is : "Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index "

Do you have any idea what it means?

|||

Hi There,

Could you show me your code here ? curious how is your sqldatasource look like.

Seems that your sqldatasource do not have insert parameter

e.g.

<SelectParameters>

<asp:ParameterName="book_list_id"Type="Int32"/>

</SelectParameters>

|||

This is my sqldatasource

<asp:SqlDataSourceID="bookExtensionDataSource"

runat="server"
ConnectionString="<%$ ConnectionStrings:rockwellConnectionString %>"
ProviderName="<%$ ConnectionStrings:rockwellConnectionString.ProviderName %>"

SelectCommand="SELECT book_details.Status, book_list.Book_List_ID, Circulation_Type, book_details.Book_Details_ID, CONCAT(rockwell.book_list.Title, IFNULL(CONCAT(', ', edition.Edition_Name), ' ')) AS Title FROM book_list, edition, book_details, circulation_type WHERE (edition.Edition_ID = book_details.Edition_ID) AND (circulation_type.Circulation_ID = edition.Circulation_ID) AND (edition.book_list_id = book_list.Book_List_ID) AND (book_list.Book_List_ID = ?)">

<SelectParameters>
<asp:ControlParameterControlID="book"Name="?"PropertyName="SelectedValue"/>
</SelectParameters>

</asp:SqlDataSource>

book is the ID of the master gridview(gridview 1)

|||

This is my sqldatasource

<asp:SqlDataSourceID="bookExtensionDataSource"

runat="server"
ConnectionString="<%$ ConnectionStrings:rockwellConnectionString %>"
ProviderName="<%$ ConnectionStrings:rockwellConnectionString.ProviderName %>"

SelectCommand="SELECT book_details.Status, book_list.Book_List_ID, Circulation_Type, book_details.Book_Details_ID, CONCAT(rockwell.book_list.Title, IFNULL(CONCAT(', ', edition.Edition_Name), ' ')) AS Title FROM book_list, edition, book_details, circulation_type WHERE (edition.Edition_ID = book_details.Edition_ID) AND (circulation_type.Circulation_ID = edition.Circulation_ID) AND (edition.book_list_id = book_list.Book_List_ID) AND (book_list.Book_List_ID = ?)">

<SelectParameters>
<asp:ControlParameterControlID="book"Name="?"PropertyName="SelectedValue"/>
</SelectParameters>

</asp:SqlDataSource>

book is the ID of the master gridview(gridview 1). i am trying to move the select parameter to the back end as it seems that the gridview cannot detect the datasource in the accordionPane.

|||

Hi There,

Are you doing something like, you have a master gridview, each master row have accordian and expand accoridian and display the detail ? like follow ?

Master

-- Accordian

-- Detail ?

Try this, i think this is better module:http://www.codeproject.com/aspnet/MasterDetail.asp

|||

The sequence of flow is like this

Accordion
--->master
---->details
---->details

|||

Hi There,

Did you try out the link that i posted ?

Unfortunately, im at work can;t actually write a sample to test your scenario now. Will try do it later tonight.

;)

|||

Hi there,

Would you able to post your code here? i think this would be better rather than i create a test that is not relavant to yours.

shacky:

The sequence of flow is like this

Accordion
--->master
---->details
---->details

The above structure is a bit weird to me, is there a specific reason ?

|||

All the gridviews are actually within an accordionPane.

When the master gridview is selected, the relevant information will be displayed in gridview 2(1st detail).
When gridview 2 is selected(1st detail) is selected, the relevant information will be displayed in gridview 3(2nd detail).

Below is the selectparameter for gridview 2 and 3:

selectparameter of gridview 2

<SelectParameters>

<asp:ControlParameterControlID="book"Name="?"PropertyName="SelectedValue"/>

</SelectParameters>

selectparameter of gridview 3

<SelectParameters>

<asp:ControlParameterControlID="basicBookDetails"Name="?"PropertyName="SelectedValue"/>

</SelectParameters>