SSRS 2008 SP1 64-bit DRILL-THROUGH Issues
Hi, Can anyone confirm that SSRS 2008 64-bit (Enterprise Version) does support drill through, please? I have created a Master/Detail drill through that works fine on VS Team 2008 (Enterprise Version), but it fails to run on the SSRS 2008 64-bit server - no error messages.' Both reports work fine independently on the server. The designated text box shows a link on mouseover, but nothing happens and "View Source" doesn't indicate any relevant HTML or JavaScript likely to move the page to the detail report. If SSRS 2008 SP1 64-bit does support drill through, has anyone had this issue and then solved it? *Both rdl files are in the same folder on the server **Drill Through works as expected on the server from within VS2008 Preview, but not within Report Manager
July 20th, 2010 6:52am

Hi, Confirm that both reports - > main and subreport are in same folder...Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2010 7:56am

Thanks for your reply Gayathri devi, I can confirm that both files are in the same project folder. Regards, Daryl
July 20th, 2010 8:00am

ok.. open your VS 2008 project in your server.. and make it sure it runs in preview with out any issue.Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2010 8:05am

Thanks again for your suggestion Gayathri devi. I have created a new project on the server and added the two reports and the drill-through action works exactly as expected. It runs in Preview with no issues, but still not within Report Manager :-(
July 20th, 2010 8:32am

Hmm k check the following things for not missing out anything Both Reports are deployed in same path(FOLDER) in report server... Parameters are correctly passed between both Reports Any authentication issues in Report manager.. Run your Report in Report Server for verification ( Path where u deployed) Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2010 10:59am

Hello again Gayathri devi. Thanks for your further suggestions. Yes, Both reports have been deployed into the same folder in Report Manager Yes, Parameters are correctly passed between both reports in VS2008 (clearly visible in detail report), but not in Report Manager Yes, Authentication is OK, both reports run OK separately with default parameters in Report Manager Yes, I have run the drill through reports OK on the server within VS2008 (Preview Mode) but not in Report Manager - The pointer cursor appears, but nothing happens on mousedown, click or double-click :-( Gayathri devi, are you able to confirm that the SSRS 2008 SP1 64-bit Enterprise version does support drill through? I see in the SQL Server 2008 specs that drill through is only available in the Enterprise version, but is is available in the 64-bit Enterprise edition? Regards, Daryl
July 20th, 2010 1:08pm

Hi, Am not sure about that.. But just trying out with you... Point 4 : not in preview mode.. Check in Report Server (where you deployed) http://servername/reportserver/ Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2010 1:15pm

Thanks for clarifying your meaning Gayathri devi. I should have seen that the first time ... duh ! ! ! I'll try that tomorrow when I'm back in the office (I don't use VPN). Thanks again for your ideas :-) Regards, Daryl
July 20th, 2010 1:35pm

Well Gayathri devi, I have tried the Report Server path and it gives the same result as the Report Manager. The individual reports run OK but the drill through is not working. I'll try the "URL" radio button, but if the URL to the server doesn't work, I doubt if it will work, but I will give it a try and advise the result. *** I have now tried to run the detail report using "Go to URL" and it does open the detail report but with the default parameters. Regards, Daryl
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2010 1:45am

Hi Daryl, First, I am sure the Drill-Through is supported in SQL Server Reporting Services 64 bit version. In this case, the issue may be caused by the cache. You may try deleting the reports, and then deploying it again. If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
July 22nd, 2010 1:53pm

Hi Jin Chen, Thanks for the confirmation of Drill Through in SRSR 2008. I appreciate your advice. I suspected this because I have actually got some simple reports to drill through, but I am stuck with drill through not working from a simple Drill-Down section. I have tested this on VS2008 and it runs fine but not within SSRS Report Server. I have checked the parameter names, values and scopes and there doesn't seem to be any issues, but when the page is displayed, the pointer appears on mouseover, but no link is there. I am about to switch to test the "Go to URL" mode. I'll let you know how I go. :-) ***Well, I have changed the drill through to "Go to URL" and exactly the same thing happens as with the "Go to Report". It works fine from VS2008 but nothing from Report Manager. The Detail page opens fine with a hard-coded query string, but not from the Master page in Report Manager. BTW: I had already cleared the cache and deleted the files several times, but it was worth mentioning. Thank you. I have also tested this report without the drill down section with the same failed result. I'm out of ideas. :-( Regards, Daryl
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2010 9:25am

Thanks for your suggestions, Gayathri devi and Jin Chen. I have found the answer. Hoping that my experience will help others, I found that unless I start with a detail row and then change it to a group, the drill through fails. Previously, I had a separate details row which I later deleted, because it was the grouped text box at the next highest level that I was using for the drill through. I also found that changing the padding and space before/after also caused the drill through to fail, and I had to back-track to retain the drill through functionality. This should not ever happen. I suspect that the SSRS application is not updating the RDL file properly. This is definitely the case when removing drill-down visibility controls. Several times, I have removed the check box in the application, only to find that the reference was not removed from the RDL file. Simple to fix, I agree, but if the application doesn't do that properly, what else is it missing? Thanks for your responses, guys. I appreciate your efforts :-)
July 29th, 2010 1:42am

Just for all other users with the same problem, my solution to this issues was: 1. switch to source code view (XML) 2. search for the textbox, where you have defined the action (goto report action) 3. between the opening tag and the closing tag of the textbox: remove all style properties (<style>..</style>) 4. deploy the report and test the drillthrough - it should work now 5. switch to designer view and set all style properties again to get back to your original layout It seems to be that the engine sometimes confuses the different settings of a textbox, I don't know. Hope I could help. Jens EDIT: sometimes it also seems to be working, if you just search for the <LeftIndent>..</LeftIndent> and <HangingIndent>..</HangingIndent> and remove these lines.
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2012 2:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics