I have a main report that has two parameters (RptMonth, Reports). RptMonth which the user selects from a calendar, and Reports which is a dropdown list. Produces main report correctly.
I want to goto a second report (Detail) based on clicking a textbox named KPI. I configured the textbox to Go To Report, added this parameter named ID value [ID] that is in the dataset of the query. Parameter settings - Name=ID, datatype=Integer, parameter
Get values from query=Dataset1, value field=ID, label field=KPI. Using always refresh. This is all configured in the main report. In the detail report I have one parameter named ID, type Integer, visibility=hidden.
Security for both reports use embedded connection, type SQL server. When I run the main report and click on the KPI textbox it passes the ID and I get the correct detail report. When I deploy it to the server I get
View Complete Post