I have created a report based on a sharepoint list and I am using a subscription in WSS 3.0 to email the report to the users once a week. I want one column in the report to act as a hyperlink to the sharepoint list item but in the email version of the report, the URL has the list item ID repeated twice, which renders the link invalid. Initially, I tried using the 'Encoded Absolute URL' from the sharepoint list query to populate the hyperlink but this just gives a 404 NOT FOUND error and I have found documented in several places on the web that this link only works with document libraries. So instead, I decided to create the URL for the action using an expression, like this: ="http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=" & ListItemID.Value This works perfectly in the development environment and when people run the report for themselves in the sharepoint document library where it is deployed but, for some reason, if I send the report on a schedule then I get the ID parameter repeated at the end twice. Like this: http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=999&ID=999 I have tried rendering the report in several different formats (Word, PDF, MHTML, HTML) and they all seem to work fine in the development and when run within SharePoint but not when they are rendered and emailed using the scheduler. Is this a bug or am I missing something? Any ideas as to how this can be resolved?

I've just tried using a file share subscription instead of email and the same problem occurs there too so itlooks to be something associated with the subscription rendering process

Hi nayrycradevets, I had tried to reproduce this issue with Reporting Services 2008 R2 and SharePoint 2010, however, everything works fine. Currently, I would like to check which version of Reporting Services Add-in for SharePoint Integrated mode you are using? Are you using Reporting Services Add-in 2008 SP2 CTP? If not, could you please update it to Reporting Services Add-in 2008 SP2 CTP? Additionally, ="http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=" & ListItemID.Value seems to be incorrect. We should use Fields!ListItemID.Value instead of ListItemID.Value. Reporting Services Add-in 2008 SP2 CTP can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyID=65606fdd-093f-4c70-91f6-dc1f24520e8f&displaylang=en If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi nayrycradevets, I had tried to reproduce this issue with Reporting Services 2008 R2 and SharePoint 2010, however, everything works fine. Currently, I would like to check which version of Reporting Services Add-in for SharePoint Integrated mode you are using? Are you using Reporting Services Add-in 2008 SP2 CTP? If not, could you please update it to Reporting Services Add-in 2008 SP2 CTP? Additionally, ="http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=" & ListItemID.Value seems to be incorrect. We should use Fields!ListItemID.Value instead of ListItemID.Value. Reporting Services Add-in 2008 SP2 CTP can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyID=65606fdd-093f-4c70-91f6-dc1f24520e8f&displaylang=en If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Thanks, Jim. I've downloaded and applied the updates as suggested but the problem is still occuring on our live server. I have deployed a similar report to the test server (which I upgraded first) and there doesn't seem to be the same issue when the report gets rendered. I am using the same versions of WSS (3.0), SQL Reporting Services and the Add-In on both sites.

Unfortunately, I spoke too soon. I created a second report on my test site and it has the same problem as the one in the live. The working report was one based on the user directory in the test site, whereas both the reports with errors in the link are created from custom lists. I haven't yet tried reports on any lists based on the standard templates but I guess that would be my next.

Hi Jin, Do you know if it would be possible to redirect a user to an infopath form based on the title that is returned from an SSRS report that references a sharepoint list? I have a report currently that only returns the needed rown from a SharePoint lIst that a user is assigned to. Each of these rows represents an entry in a forms library, but they do not have access to the original library where the forms are filled out. Is there a way to display this completed form for them through and action url or link? Thanks, BJ

Hi All, I am also experiencing the same problem using Reporting Services 2008 R2 and SharePoint 2010: The query string parameters are repeated in any hyperlink on the report (regardless of whether it has been generated as an Action or as a string as formatted HTML). For example, the link "http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=12" would be shown as "http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=12&ID=12". As another example, "http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=12&source=http://myserver/mysite" would be shown as "http://myserver/mysite/Lists/mylist/DispForm.aspx?ID=12&source=http://myserver/mysite&ID=12&source=http://myserver/mysite". Strangely enough, this only occurs when rendered through SharePoint on the Report Viewer Web Part. The preview in the report designer renders the links correctly. Any assistance/update regarding this issue would be greatly appreciated.

I'm having the same problem - as is scolt below. The link works fine when run in BIDS but when deployed to SP and run there the parameter section of the url is repeated.

Same problem here. The link works correctly in BIDS, but not once it's deployed on the server. Key factors: 1. SSRS and SharePoint are both on the same single server 2. (In my case) The object with the hyperlink Action is an Image that's in a hidden column 3. I copy / pasted an initial report in BIDS that worked, the copy doesn't seem to work. Not sure if the original ever did.Seth Sanusi

Currently, I have the same problem, any response to this? Would be great... Thanks, Pawel

I received a workaround from Microsoft - though they were not able to see the same error I'm getting in their lab. The error appears to occur when there are special characters in the url. The workaround involves using javascript in the hyperlink: ="javascript:window.navigate('http://myserver/mysite/Lists/mylist/mycontenttype/detail.aspx?ID="+Fields!ID.Value.ToString + "');"

Thanks, Dan. That solution works fine for me. Much appreciated