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
