I need to adda bookmark to the URL so when the new report is displayed, it automatically goes to the bookmarked section. I put the BookmarkID in the URL and it still doesn't work. Here's the URL: http://dev5/ReportServer/Pages/ReportViewer.aspx?/LHD2.0/TPIDDetail&TPID=2199596&Avg=58&rs:Command=Render&rc:BookmarkID=Test

Hi L.M, From your description, you want the report go to a bookmark automatically using URL Access. If I have misunderstood, please do not hesitate to let me know. By designer, going to specify bookmark based on the parameter BookMarkID of URL Access is invalid. However, the reporting services use the JavaScript to go to bookmark. We can improve custom JavaScript function to go to bookmark on report rendering. The default actionhandle for going to bookmark is like this: ClientReport0eb32b4586904d949d6b34617f030ed3.ActionHandler('Bookmark','BMID'); Here are the detailed steps of the workaround for your reference: 1. Embed custom code in the report: Public Shared Function GetColor() Dim script as String script = "var url=parent.parent.window.location.search;var Request = new Object(); if(url.indexOf(""?"")!=-1){var str = url.substr(1); strs = str.split(""&"");for(var i=0;i<strs.length;i++) { Request[strs[i].split(""="")[0]]=unescape(strs[i].split(""="")[1]);} } ;" script = script + "function GetOnloadEvent(){ if(Request[""rc:BookmarkID""]){var cellObject = document.getElementById(""oReportCell"");if(cellObject ){" script = script + "var ClientReport = new RSReport(parent.parent.document.getElementById('ReportViewerControl').ClientController, '', 'oReportDiv', 'oReportCell', '100', '', 1, 1, false, 0, '', 0, '');" script = script + "ClientReport.ActionHandler('Bookmark',Request[""rc:BookmarkID""]);" script = script + "clearTimeour(timer);}else{setTimeout(GetOnloadEvent,50);}}}var timer;timer=setTimeout(GetOnloadEvent,50);" System.Web.HttpContext.Current.Response.Write("<script language='javascript'>" & script & "</script>") Return "Transparent" End Function The code will register a client script. The script is used to go to bookmark. a. Get the URL. b. If the URL does not contain the parameter BookMarkID, render the report. c. If the URL contains the parameter BookMarkID: d. Create the ClientReport object. e. Execute the going to bookmark action ClientReport.ActionHandler('Bookmark',Request[""rc:BookmarkID""]); 2. In Report Designer, go to Layout page, set the color property of the body to be: =Code. GetColor() 3. Click the menu Report - Report Properties Reference.Add a reference System.Web 4. Configure the code access for the Report Server. 5. Now, if passing the parameter BookMarkId in the URL, the report will go the bookmark automatically. For more information, please see: Understanding Code Access Security in Reporting Services: http://msdn.microsoft.com/en-us/library/ms155108(SQL.90).aspx If there is anything unclear, please feel free to ask. Thanks, Jin Chen

Hi J.C. I try your solution but I don't works on my report server ... I have few questions ? 1) is URL Access by Bookmarkid invalid in RS 2005 or RS 2008 ? 2) I have already " Configure the code access for the Report Server " for a custom assembly for a data extension and it works fine (with a lot of try). but this dll was a classic dll (not strong named). In your solution, it's a bit different : system.web.dll is strong named ! I put this in rssrvpolicy.config <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="system.web" Description="xxx"> <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007d1fa57c4aed9f0a32e84aa0faefd0de9e8fd6aec8f87fb03766c834c99921eb23be79ad9d5dcc1dd9ad236132102900b723cf980957fc4e177108fc607774f29e8320e92ea05ece4e821c0a5efe8f1645c4c0c93c1ab99285d622caa652c1dfad63d745d6f2de5f17e5eaf0fc4963d261c8a12436518206dc093344d5ad293" /> </CodeGroup> is this correct ? i get this error message in rs log w3wp!session!1!06/08/2009-10:29:36:: i INFO: LoadSnapshot: Item with session: t45nymbvgrdaz055lhv3r3yf, reportPath: , userName: INETPSA\U212693 not found in the database w3wp!library!1!06/08/2009-10:29:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: L'excution t45nymbvgrdaz055lhv3r3yf est introuvable., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: L'excution t45nymbvgrdaz055lhv3r3yf est introuvable. w3wp!session!5!06/08/2009-10:29:37:: i INFO: LoadSnapshot: Item with session: t45nymbvgrdaz055lhv3r3yf, reportPath: , userName: INETPSA\U212693 not found in the database w3wp!library!5!06/08/2009-10:29:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: L'excution t45nymbvgrdaz055lhv3r3yf est introuvable., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: L'excution t45nymbvgrdaz055lhv3r3yf est introuvable. w3wp!library!1!06/08/2009-10:29:37:: Unhandled exception was caught: Microsoft.Reporting.WebForms.ReportServerException: L'excution t45nymbvgrdaz055lhv3r3yf est introuvable. (rsExecutionNotFound) Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) Microsoft.Reporting.WebForms.ReportDataOperation..ctor() Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType) Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 3) does your solution works in RS2005 with Snapshot Reports which are scheduled? Thank for your replySylvain Le Strat

Hi Jin, Where is the bookmark in the report set? How does the URL Link know where to go? I'm not sure I understand why we are setting the Color field to transparent?

Did this javascript work inside SSRS 2005?Mr Shaw