web application -> report services

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angel - 27 Jul 2005 21:13 GMT

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

Reply to this Message

Doume - 29 Jul 2005 23:49 GMT

Maybe the reportviewer ?

Reply to this Message

Bill Lane - 31 Jul 2005 04:31 GMT

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.

> Hi,
> Is there any example, article or book that shows how to integrate reports
[quoted text clipped - 14 lines]
> Thanks
> Angel

Reply to this Message