I added a hyperlink in the report. It worked perfectly in development environment and hyperlink field displays desired value in ASP.net application. I deployed the report to test and tried to view the report from ASP.net application but the hyperlink field
is null. When i ran the stored procedure in test database and it returns value. Also stored procedure executes in 4 seconds in test database. Report query execution never finish executing when its connected to test database.
Based on the current description, I think the issue may occur when DataSource in the test environment doesn’t connect the database improperly.
In your scenario, the report with hyperlink field can work in the development environment. However, there are some issues in the test environment. Here, I want to confirm whether the report can run in the test environment or the hyperlink field is null when
running the report. As per my thought, the report shouldn’t run if report query execution keeps executing. If there is error message, you can view the error log. In this case, please post the error log to the forum for further analysis.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.