i having problem getting query-based parameters refresh in ssrs when view report or refresh button clicked. illustrate problem, created report 2 parameters. 1 parameter set timestamp now() using ssrs function. other parameter set value getdate() sql server database query. when view report, both parameters accurately timestamp. when hit view report button or refresh, neither parameter refreshes. way can timestamps refresh re-open page in new browser. there anyway these timestamps update without having open new page/session? thanks!
fix: build main report no parameters. embed subreport report. in subreport, build parameter called randomtime. in main report, go subreport properties , feed parameter randomtime value =now(). refresh of query based parameters in subreport everytime hit refresh, must depend on randomtime. easiest way found add column sql query slect @randomtime dummycolumn. ensures query repull , parameters refresh everytime refresh button clicked
Comments
Post a Comment