reporting services - SSRS hyperlink to report prompting for values -
i have main report using register report in hyperlink.
so whenever user clicks on register hyperlink should show particular register displayed in report.
register report using 2 parameters - year , register
when click on register in main report prompts me select register dropdown list instead of showing data directly.
what can done avoid this?
if both reports in same project, can use drillthrough action. this'll let create link between 2 without needing construct url. in properties of object, under action, choose go report. let select should used each parameter, either static values or data.
https://msdn.microsoft.com/en-us/library/dd207031(v=sql.105).aspx
if they're in separate locations, can add parameter @ end of url you're using. point report server of register report, , add ¶m_name:param_value
end each parameter.
https://msdn.microsoft.com/en-gb/library/ms155391(v=sql.105).aspx
Comments
Post a Comment