Scenario based Kerberos setup with Reporting Service in Sharepoint integration mode.

It’s always been a challenge to setup Kerberos in environments where there would be multiple tiers involved for an application. As the number of tiers increase, there is an increase in the number of hops that would take place. It becomes even more difficult when Enterprise level applications like Reporting Services and SharePoint are integrated…

0

Leaving a report idle in report manager and acessing it again throws, System.Exception: The page has expired. To re-open it, you must access the original page.

When you leave the report open in report manager idle for some time and accessing it fails with the following error message: (Any operation that causes a Postback event can kickout this error) w3wp!ui!6!11/19/2009-02:58:25:: e ERROR: The page has expired. To re-open it, you must access the original page. w3wp!ui!6!11/19/2009-02:58:25:: e ERROR: HTTP status code…

0

Cannot click Subscriptions tab after Moving to Windows Authentication from Forms based Authentication

I was working on an interesting case where the reporting service was moved back to Windows authentication from Forms based authentication (FBA). There were lot of subscriptions which were created using a forms based user account. Now when the reporting service was moved back to Windows authentication, the reports which contains all these subscriptions we…

0

Working with RDLC and passing parameter to subreport in Report Viewer control

Recently I was looking for a sample that will help me with the concept of Passing parameters to sub reports in RDLC. I didn’t get one. So I thought of exploring more on to this and started off the journey. The tricky part with the RDLC is, even though it gives you the option of…

9

Reporting Service Frequently Asked Questions (FAQ)

1. How Duplicate SPN’s in IIS can come in to picture?   An SPN is a service principal name and usually uniquely identified in a domain with it’s service name.   for eg: If we have a machine name “test” in the domain “contoso.com” and we have a web site (ws1) which is served by an application…

0

Clicking the drillthrough link in a 2008 Multi valued parameter report after exporting to MHTML / Word formats which contains drillthrough action (Go to report) fails

PROBLEM: 1. Consider a report (rptParent) with a multi value query based parameter and it has links (table cell action “Go to report”) to rptChild. 2. The report (rptChild) renders pased on the parameter value it receives from rptParent. 3.   When viewed on report server all the links work, both rptParent and rptChild works too. 4. Now either EXPORT or…

5