Please Help me 'DrillthroughSourceQuery' parameter is missing a value in report builder

Can u help to to solve my problem . Many time this question arised in the forum no one answer to me to find out the solution for my problem. So please help

I am using report builder thru LocalHost\Report . I want a drill through report by using Report Builder and cube . I created the report but unfortunatly I cannot create a drill through report using parameters .How can I pass parameter in report1 to jump into report2 .

When I running the report after giving drill through properties in report the following error will occure.

'The 'DrillthroughSourceQuery' parameter is missing a value

How can I create a report using parameter for drill down in report builder

I am expecting one answer from u expertise

-Create a report with your needed entities and save it in Report builder as RDL file.

-Import it in a Reporting project

-Design your report as needed

-Deploy it on the Report Server

-Use SSMS to connect to the Reporting Server and navigate to the model

-Connect the Report with the single / multi instance of your entity within the model.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

Could you please elaborate on the steps.

In my scenario the report rdl file is on some other server and the folder is not shared, how do i impport the rdl file in reporting project. Could you please elaborate on "Use SSMS to connect to the Reporting Server and navigate to the model"

Regards

Neeraj

Please Help me ''DrillthroughSourceQuery'' parameter is missing a value in report builder

Can u help to to solve my problem . Many time this question arised in the forum no one answer to me to find out the solution for my problem. So please help

I am using report builder thru LocalHost\Report . I want a drill through report by using Report Builder and cube . I created the report but unfortunatly I cannot create a drill through report using parameters .How can I pass parameter in report1 to jump into report2 .

When I running the report after giving drill through properties in report the following error will occure.

'The 'DrillthroughSourceQuery' parameter is missing a value

How can I create a report using parameter for drill down in report builder

I am expecting one answer from u expertise

-Create a report with your needed entities and save it in Report builder as RDL file.

-Import it in a Reporting project

-Design your report as needed

-Deploy it on the Report Server

-Use SSMS to connect to the Reporting Server and navigate to the model

-Connect the Report with the single / multi instance of your entity within the model.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

Could you please elaborate on the steps.

In my scenario the report rdl file is on some other server and the folder is not shared, how do i impport the rdl file in reporting project. Could you please elaborate on "Use SSMS to connect to the Reporting Server and navigate to the model"

Regards

Neeraj

sql

please help before I kill myself over this problem...

have a report that takes 1 parameter on a report server.

Trying to call the report using the reportviewer control

All I want to do is set the report parameter in code.

Dim rp = New Microsoft.Reporting.WinForms.ReportParameter

rp.Name = "InvoiceNumber"

rp.Values.Add("0618050")

Me.ReportViewer1.ServerReport.SetParameters(rp)

Me.ReportViewer1.ShowParameterPrompts = False

ReportViewer1.RefreshReport()

This always fails. I can't figure out how to add the report parameter to the control. PLEASE save me.

I haven't done this myself, but I did see an sample in the help files. Here's a snippet:

// Create the sales order number report parameter
ReportParameter salesOrderNumber = new ReportParameter();
salesOrderNumber.Name = "SalesOrderNumber";
salesOrderNumber.Values.Add("SO43661");

// Set the report parameters for the report
reportViewer1.ServerReport.SetParameters(
new ReportParameter[] { salesOrderNumber });

// Refresh the report
reportViewer1.RefreshReport();

I found this in my local reporting services help under 'Integrating Reporting Services Into Applications'-> 'Integrating Reporting Services Using the Report Viewer Control'.

I hope this helps- please don't kill yourself over microsoft code!!!!

|||what would this be in vb.net?|||

here is what I get in vb.net

Dim salesOrderNumber As ReportParameter = New ReportParameter()

salesOrderNumber.Name = "InvoiceNumber"

salesOrderNumber.Values.Add("0618050")

' Set the report parameters for the report

dim reportparameters() as ReportViewer1.ServerReport.SetParameters(new salesOrderNumber)

except where "new" is I get an error saying that "array bounds cannot appear in type specifiers"