I have developed a data processing extension and want to enable the use of
the "edit" button on the data source wizard
This only seems to be enabled for the built in data providers. Do I need to
implement another interface?
Cheers
SimonHi Simon,
From your descriptions, I understood that you would like to custom the Data
Source dynamically. Have I understood you? Correct me if I was wrong.
First of all, I am not very sure whether you need a middle layer,however,
here is an example using ADO.NET Datasets in Reporting Services passing the
filter data to the correct stored procedures. I think it might help
Using ADO.NET DataSets from SQL 2000 Reporting Services
http://weblogs.asp.net/gavinjoyce/archive/2004/01/29/64339.aspx
Secondly, have you tried DataSet object? The DataSet object is central to
supporting disconnected, distributed data scenarios with ADO.NET. The
DataSet is a memory-resident representation of data that provides a
consistent relational programming model regardless of the data source. See
Topic "Using an External Dataset with Reporting Services" in Reporting
Services BooksOnline.
If I misunderstood you, please feel free to let me know further what you
want and it will be highly appreciated if you could show me the scenario:)
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I think you have missed the point.
I have written a data processing extension implementing IDbConnection etc.
When I create a data source in report designer the box for the connection
string alows me to enter a connection string directly, however the edit
button on the right hand side is disabled. How can I enable this and have it
display the data link properties box as it does when using the sql server,
OLEDB, ODBC and Oracle data providers.
""Michael Cheng [MSFT]"" wrote:
> Hi Simon,
> From your descriptions, I understood that you would like to custom the Data
> Source dynamically. Have I understood you? Correct me if I was wrong.
> First of all, I am not very sure whether you need a middle layer,however,
> here is an example using ADO.NET Datasets in Reporting Services passing the
> filter data to the correct stored procedures. I think it might help
> Using ADO.NET DataSets from SQL 2000 Reporting Services
> http://weblogs.asp.net/gavinjoyce/archive/2004/01/29/64339.aspx
> Secondly, have you tried DataSet object? The DataSet object is central to
> supporting disconnected, distributed data scenarios with ADO.NET. The
> DataSet is a memory-resident representation of data that provides a
> consistent relational programming model regardless of the data source. See
> Topic "Using an External Dataset with Reporting Services" in Reporting
> Services BooksOnline.
> If I misunderstood you, please feel free to let me know further what you
> want and it will be highly appreciated if you could show me the scenario:)
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi Simon,
I have tested it on my side and it works fine. Please refer to the
following document to see whether it helps
Deploying a Data Processing Extension to Report Designer
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_extend_dataproc_9cds.asp
Deploying FsiDataExtension
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/ht
m/rss_sampleapps_v1_16g2.asp
Implementing a Data Processing Extension
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_extend_dataproc_5c2q.asp
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Can you tell me what you tested?
For the FSI extension the edit button should not bring up the data link
window because it is an extension for the file system and not an OLEDB
connection.
Do you understand what I am trying to do?
I have read all the online documentation and BOL and there is no mention of
the edit button on the datasource wizard.
Simon
""Michael Cheng [MSFT]"" wrote:
> Hi Simon,
> I have tested it on my side and it works fine. Please refer to the
> following document to see whether it helps
> Deploying a Data Processing Extension to Report Designer
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_extend_dataproc_9cds.asp
> Deploying FsiDataExtension
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/ht
> m/rss_sampleapps_v1_16g2.asp
> Implementing a Data Processing Extension
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_extend_dataproc_5c2q.asp
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
No comments:
Post a Comment