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!
>
Showing posts with label enable. Show all posts
Showing posts with label enable. Show all posts
Monday, March 19, 2012
Thursday, March 8, 2012
Data Mining on SQL 2005 database
Is it possible to enable data mining tools on SQL SERVER 2005 database.
i need some tutorials on this? Please help ou
Ronald
Yes, it is possible.
http://msdn2.microsoft.com/en-us/library/ms166552.aspx
http://msdn2.microsoft.com/en-us/library/ms167488.aspx
|||Hi Andrew, I have created some mining models based on the Adventure Wiorks database (Microsoft Decision Trees, Microsoft Time Series).
How can executives managers be able to view trends, forecasting charts based on Microsoft Time Series Model using ASP.NET 2.0 with C#.
Please help me out.
Thanx
Ronald
|||For Time Series, perhaps the easiest way is to :
- connect to Analysis Services using the Profiler tool
- launch the Time series model in the BI Developer Studio viewer
- capture the query sent by the user
- create a report in Reporting services that sends the same query and then renders the charts.
If you want to do your own rendering, then you should follow the same steps to get the query of interest, then execute it from your web app using Adomd.Net Client or even OLE DB.
SQL Server 2005 comes with some sample web viewers for some of the Data Mining algorithms: Decision Trees, Naive Bayes and Clustering. You can see those viewers at work on sqlserverdatamining.com:
http://www.sqlserverdatamining.com/MovieSurveyDemo
|||
How do i capture the query sent by the user?
Can't I use reportviewer to render repoerts with cahrts? Please I kindly ask you to elaborate more on the last point of using Adomd.NET Client or even OLEDB.
Thanx in advance
Ronnie
|||You can use SQL Profiler to see all communication between the client and server. You can use RS to create reports with charts - somewhat. The charting is a bit limited, so it's difficult to replicate the charts in our viewer, and the viewers execute multiple queries and you would need a single query response to render a report.
You can work around the latter part by creating a .NET stored procedure for Analysis Services that would generate the appropriate rowset that you want to render in RS. You will likely need to do some finagling to get the charts rendered appropriately in a report though (e.g. different line styles for actual vs. predicted)
|||Hi Bogdan,I have accessed the website, but I don't find the web viewers you mention. Where is it?
My customer want to see the result of mining in their web client/browser.
Bernaridho
Data Mining on SQL 2005 database
Is it possible to enable data mining tools on SQL SERVER 2005 database.
i need some tutorials on this? Please help ou
Ronald
Yes, it is possible.
http://msdn2.microsoft.com/en-us/library/ms166552.aspx
http://msdn2.microsoft.com/en-us/library/ms167488.aspx
|||Hi Andrew, I have created some mining models based on the Adventure Wiorks database (Microsoft Decision Trees, Microsoft Time Series).
How can executives managers be able to view trends, forecasting charts based on Microsoft Time Series Model using ASP.NET 2.0 with C#.
Please help me out.
Thanx
Ronald
|||For Time Series, perhaps the easiest way is to :
- connect to Analysis Services using the Profiler tool
- launch the Time series model in the BI Developer Studio viewer
- capture the query sent by the user
- create a report in Reporting services that sends the same query and then renders the charts.
If you want to do your own rendering, then you should follow the same steps to get the query of interest, then execute it from your web app using Adomd.Net Client or even OLE DB.
SQL Server 2005 comes with some sample web viewers for some of the Data Mining algorithms: Decision Trees, Naive Bayes and Clustering. You can see those viewers at work on sqlserverdatamining.com:
http://www.sqlserverdatamining.com/MovieSurveyDemo
|||
How do i capture the query sent by the user?
Can't I use reportviewer to render repoerts with cahrts? Please I kindly ask you to elaborate more on the last point of using Adomd.NET Client or even OLEDB.
Thanx in advance
Ronnie
|||You can use SQL Profiler to see all communication between the client and server. You can use RS to create reports with charts - somewhat. The charting is a bit limited, so it's difficult to replicate the charts in our viewer, and the viewers execute multiple queries and you would need a single query response to render a report.
You can work around the latter part by creating a .NET stored procedure for Analysis Services that would generate the appropriate rowset that you want to render in RS. You will likely need to do some finagling to get the charts rendered appropriately in a report though (e.g. different line styles for actual vs. predicted)
|||Hi Bogdan,I have accessed the website, but I don't find the web viewers you mention. Where is it?
My customer want to see the result of mining in their web client/browser.
Bernaridho
Subscribe to:
Posts (Atom)