I have a aspx page that displays a report based on parameters. I use the
report viewer tool. The objectdatasource will allow you to configure the
query and parameters. I use a dropdown box for one parameter and a session
variable to limit the report presented to the current logged on user. I am
using "form authentication". That is the good news.
I have not been able to get the report to show the correct data when I
select a different value in the dropdown box. More specifically, I use a
session variable for the userid. I use the dropdown box to select the month
of data to be presented. I set the selected index from the load procedure. I
have autopostback set for the dropdown box, but the report displays the same
data no matter what I select in the dropdown box. I can post the code if you
would like.
[quoted text, click to view] "Angel" <angel_f@hotmail.com> wrote in message
news:OUzZueukFHA.2920@TK2MSFTNGP14.phx.gbl...
> Hi,
> Is there any example, article or book that shows how to integrate reports
> created with reporting services with existing web applications.
> I want to find a way to call a report from my web application with a set
> of parameters sent by URL's string and render this report on the current
> browser .
> I am not sure how one can handle the authentication in this case.
> The web application use a "form authentication" and I would like to be
> able to go to the report without
> prompting the user to enter some user name and password since he/she was
> already authenticated when logged-in for web application. On the other
> hand I do not want the report to be visible to everyone.
>
> Ideally I would like also web application's virtual folder to be used as
> ReportServer root.
>
> Thanks
> Angel
>
