I need to integrate RS with ASP.NET application that has form based security. In my scenario the fact that SQL Server RS has Windows based security is a big draw back.
I had following issue:
1) I can't get access for ASPNET account to RS. I looked through an article but it didn't help me. But if I pass ID of an Administrator I can see reports
2) After I see the report all the advanced features: "Drill in, drill through, chart are killed. I can't see chart - broken link, drill through and drill down send me back to original reporting server application and I don't see any way to change links back to my application.
I am still trying to use MS news group vor this by I feal like giving up and go to CR.
Could I do anything about it or I should give up?