Hi All,
On my 64bit itanium cluster, how come when I open up my Reporting Services Configuration Manager and go to the "Database Setup", under "Credentials Type" I am missing the option "Service Credentials"? This is how I have my dev server set up and would like it to be the same.
This was due to us connecting to the individual node rather than to the cluster when opening up the reporting services configuration manager.
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();
|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.
But i hope this link could help you..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1
If you found the way please post back here.
Thanks & Best Regards|||
I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
private void Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= new NetworkCredential(properties.Username, properties.Password, properties.Domain);
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();
|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.
But i hope this link could help you..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1
If you found the way please post back here.
Thanks & Best Regards|||
I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
private void Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= new NetworkCredential(properties.Username, properties.Password, properties.Domain);
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();
|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.
But i hope this link could help you..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1
If you found the way please post back here.
Thanks & Best Regards|||
I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
private void Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= new NetworkCredential(properties.Username, properties.Password, properties.Domain);
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
privatevoid Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = newDataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= newNetworkCredential(properties.Username, properties.Password, properties.Domain);
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();
|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.
But i hope this link could help you..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1
If you found the way please post back here.
Thanks & Best Regards|||
I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
private void Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= new NetworkCredential(properties.Username, properties.Password, properties.Domain);
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();
|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.
But i hope this link could help you..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1
If you found the way please post back here.
Thanks & Best Regards|||
I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
private void Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= new NetworkCredential(properties.Username, properties.Password, properties.Domain);
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
privatevoid Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = newDataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= newNetworkCredential(properties.Username, properties.Password, properties.Domain);
I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.
Is it possible?
Any help will be appreciated!!!
TIA
YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:
prefix:datasourcename=valueas the prefix is dsu (for user) or dsp (for password) HTH, Jens Suessmeyer. http://www.sqlserver2005.de
Thanks for your reply Jens!!!
But I am using a Report Viewer control in my application. How can I pass the username and password in this case?
|||Hi,
System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));
reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();
|||
I am trying to use the example code provided for a simialr problem but the line (in VB)
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache
always shows as read only. How do I get round this please?
|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.
But i hope this link could help you..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1
If you found the way please post back here.
Thanks & Best Regards|||
I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.
I tried the following suggestion:
reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);
reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
CredentialCache cc = new CredentialCache();
cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",
new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));
reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;
reportViewer1.ShowCredentialPrompts = false;
reportViewer1.RefreshReport();
...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:
ReportingService rService = new ReportingService();
rService.Credentials
= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!
|||Hi Glenn,
You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.
http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx
|||You can refer following link.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx
|||Hi, you can try this, might help.
I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows
network login user, I am using my application's user id and password to connect to datasource.
By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.
It works for me.
private void Form1_Load(object sender, EventArgs e)
{
.............................
Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();
myCredential.UserId = "myuserid";
myCredential.Password = "mypassword";
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
DataSourceCredentials[] myCredentials=null;
if (reportdatasourcecollection.Count > 0)
{
myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];
}
for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)
{
ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];
myCredential.Name = datasourceinfo.Name;
myCredentials[iIndex] = myCredential;
}
this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );
...............................
}
|||
Hi,
I am facing the same problem.
I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource
So what should be the Connection Methods in Shared DataSource?
Nilesh
|||Me too there's an error here.
ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();
any thoughts please?
thanks.
|||Ishwar,
Thanks for the link. That is awesome. I got it working using the following code.
ServerReport.ReportServerCredentials.NetworkCredentials
= new NetworkCredential(properties.Username, properties.Password, properties.Domain);
I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.
I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.
Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.
In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:
“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”
I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:
“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”
Matt
If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.
-Lukasz
I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.
I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.
Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.
In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:
“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”
I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:
“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”
Matt
If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.
-Lukasz
Hi,
I am building a cube in the 2005 Analysis Services. I built the cube successfully when each of my dimensions referenced exactly one table. Now I want to extend that to build two dimensions based on one table. I can build the 2nd dimension but I cannot use it within the cube.
Any suggestions on how to do that?
Thanks in advance,
Aref
Any reason why you can't build 1 dimension and use it in 2 roles within your cube (eg: Date dimension in Adventure Works plays 3 roles)?I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:
When I access http://<server>/ReportServer, I see the server name of my SharePoint site.
When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site
When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).
The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.
How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.
You may want to check out this thread on how to use a SharePoint list as a Datasource:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1154115&SiteID=1
HTH
Prash
I've looked at that thread many times and was able to extract information from a list using web services. But, with Reporting Services SP2 integration with SharePoint 2007, I figured they would have included built-in support to create reports in BIDS that consume SharePoint Lists and Document Libraries.
Perhaps I'm not seeing the full extent to which Reporting Services SP2 integration is supposed to act. My thoughts were that a SharePoint integration mode would allow reports to not only be stored on SharePoint sites, but also allow reports to be about the SharePoint site itself.
|||Reporting Services SP2 integration with SharePoint 2007 does not include built-in support for consuming SharePoint Site data to be displayed in a Report.
thanx,
Prash
I tried to workaround this issue
by Creating Microsoft Access 2007 Database, using Linked SharePoint List as a tables, then I created Reporting Service Report Using this Database, in Visual Studio the Report is working fine by showing the data correctly but when you try it on the report server reporsitory directly or in the Windows SharePoint Service 3 site It doesn't work at all, it keep loading and loading until the error unexpected error appear if am running it from the sharepoint site. even thougth I configured the data sources correctly in sharepoint for the report
Any help on that
Thanks
Mohd
|||Hi,
You may be interested by our Reporting Services Data Extension : ERSDE that lets you build reports using SharePoint lists.
Though it was initially built for SPS 2003/WSS V2 lists, most of the features still work with MOSS 2007/WSS V3. We will soon release an update for Moss 2007/Wss V3.
Frdric Latour
Enesys
I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:
When I access http://<server>/ReportServer, I see the server name of my SharePoint site.
When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site
When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).
The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.
How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.
You may want to check out this thread on how to use a SharePoint list as a Datasource:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1154115&SiteID=1
HTH
Prash
I've looked at that thread many times and was able to extract information from a list using web services. But, with Reporting Services SP2 integration with SharePoint 2007, I figured they would have included built-in support to create reports in BIDS that consume SharePoint Lists and Document Libraries.
Perhaps I'm not seeing the full extent to which Reporting Services SP2 integration is supposed to act. My thoughts were that a SharePoint integration mode would allow reports to not only be stored on SharePoint sites, but also allow reports to be about the SharePoint site itself.
|||Reporting Services SP2 integration with SharePoint 2007 does not include built-in support for consuming SharePoint Site data to be displayed in a Report.
thanx,
Prash
I tried to workaround this issue
by Creating Microsoft Access 2007 Database, using Linked SharePoint List as a tables, then I created Reporting Service Report Using this Database, in Visual Studio the Report is working fine by showing the data correctly but when you try it on the report server reporsitory directly or in the Windows SharePoint Service 3 site It doesn't work at all, it keep loading and loading until the error unexpected error appear if am running it from the sharepoint site. even thougth I configured the data sources correctly in sharepoint for the report
Any help on that
Thanks
Mohd
|||Hi,
You may be interested by our Reporting Services Data Extension : ERSDE that lets you build reports using SharePoint lists.
Though it was initially built for SPS 2003/WSS V2 lists, most of the features still work with MOSS 2007/WSS V3. We will soon release an update for Moss 2007/Wss V3.
Frdric Latour
Enesys
