I am creating a report of users' productivity. I would like the main report to display the user name and location. I wouldlike tothen click on the name to display the user's information. The main report seems to be working, but the drill through does not. When I click on the hyperlink on the main report, Ireceive, "Some parameters or credentials have not been specified". Can anyone tell me what I am doing wrong? FYI: I am using VS 2005 Professional and my datasource is a business object. Thanks in advance.

Private Sub ReportViewer1_Drillthrough(ByVal sender As Object, ByVal e As Microsoft.Reporting.WinForms.DrillthroughEventArgs) Handles ReportViewer1.Drillthrough
Dim Detaildata As New List(Of ActionLogDetailData)
Dim LocalReport As LocalReport

LocalReport = e.Report
Detaildata = ActionLogDetail.GetDetailData(txtUserid.Text)
LocalReport.GetParameters()
LocalReport.DataSources.Add(New ReportDataSource("EntityAbbr", Detaildata))

Me.ReportViewer1.RefreshReport()

End Sub
End Class

e.Report is an instance of LocalReport that represents the report you are drilling into. ReportViewer.LocalReport is still set to the parent report. After the drillthrough event, ReportViewer.LocalReport will be set to e.Report, but during the event the represent different reports. You can see this by looking at the ReportPath (or ReportEmbeddedResource, depending on how you loaded the report) properties on each of them.

Since you are running in local mode, the problem is going to be with the parameters rather than credentials, since local mode doesn't use the data source connection information in your report definition.

One or more of the parameters on your drillthrough report does not have a value. There are two ways a drillthrough parameter can get a value: by having a default value, and by receiving a value from the parent report.

You can determine which parameter is missing a value by calling ReportViewer.LocalReport.GetParameters. Each parameter in the collection has a State property which will indicate whether it has a value and if not, why not.

Thanks for your reply, Mr. Hartman.

I have two more questions for you. What is the difference between the Local Report I have declared and the Reportviewer.LocalReport? I thought it was the same thing.

This what I have dimmed.

Dim LocalReport as LocalReport

LocaReport = e.Report........ e is the DrillthroughEventArgs

Then I go and get the data.........

Next, I set the LocalReport.DataSources = to what was returned.

Then I set the ReportViewer1.LocalReport.SetParamaters. All this seems like it should work. Am I using the wrong variable to get the data?

e.Report is an instance of LocalReport that represents the report you are drilling into. ReportViewer.LocalReport is still set to the parent report. After the drillthrough event, ReportViewer.LocalReport will be set to e.Report, but during the event the represent different reports. You can see this by looking at the ReportPath (or ReportEmbeddedResource, depending on how you loaded the report) properties on each of them.

Hi,

I dont have any parameters specified for the report and i am not drilling into the report. Its plain and simple local report which displays records from a dataset. It works fine until i close the report and open it again and it gives the error "Some parameters or credentials have not been supplied" when i run it in the debug modei getthe below message in the immediate window.

Run-time exception thrown : System.ArgumentOutOfRangeException - Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

I tried to get the parameters (reportviewer.localreport.getparameters) but it does not return anything.

HELP!!!!

Adhi

Hi,

Did you fix this issue? I am facing similar issue. It works fine on developement computer but in client machine I am getting following error
"some parameters or credentials have not been specified"

It works ifWhen wepress Refesh button of reportviewer control. I am already refreshing report in my code and that is why it works in development computer.

localReport.Refresh();
reportViewer1.LocalReport.Refresh();
reportViewer1.RefreshReport();

HELP!!!!

Kathy