LBI 9.0.2 on Windows 2003
Env: Unix, with Oracle DB
In reporting services dashboard, when there is a *scheduled* report, the viewer logs into Reporting Services initially. Then the viewer must log in again with Oracle credientials to actually view the *scheduled* report. Is this the way it's supposed to work? Having to log in twice to view a scheduled report?(Sorry I did not set up this instance of Reporting services).
For regular, published reports, the user only need to log in one time.
-R
Posted By Greg Moeller on 03/30/2009 03:58 PM Roger: In Report Administration, find the report in question, click on "Details", bo to the "Data Settings" link. Put in the "Default User ID" and Password(s), and make sure that the next box says "Schedule and Viewer"
Greg,
We don't see the next box on the screen which has the option "Schedule and Viewer". I'm guessing that is another option which must be allowed for the Reporting Services Administrator to have access to.
Posted By Matthew Nye on 03/31/2009 03:52 PM that should be enough. Once you set the default username and password or the override data source you should be able to run the report with out getting prompted.
Nope, we have done all that and still the viewer, after receiving the email and clicking on the link within the email, must logon to Reporting Services, and then a second time to logon to the Oracle database (within Reporting Services).
Yes we republished, then we reset the data settings to what they need to be. Still, have to log on twice.
I'm reading a KB article 1000297... says we will need to add an argument to the dashboard link of "Refresh=true". We know we can manually add that to the report URL in the browser and that will prevent having to log in twice.
Where do we add the arguement to the dashboard link? Within the "Edit..." link on the dashboard? (I don't see a place to add arguements. I need explicit navigation steps on this one guys.
Thanks in advance,
Roger