Report Parameter Dataset Running Twice?

Hi,
I have a DDL Report Parameter tied to a Dataset.
When I go to view the Report in RS the Dataset is run to populate the
Parameter, but it also seems to run the Dataset when I hit the View Report
button.
I don't have the Dataset tied to anything except the Report Parameter.
Is there a way to stop the 2nd run?
thank you
tOn May 22, 11:59 am, DigHazuse <DigHaz...@.discussions.microsoft.com>
wrote:
> Hi,
> I have a DDL Report Parameter tied to a Dataset.
> When I go to view the Report in RS the Dataset is run to populate the
> Parameter, but it also seems to run the Dataset when I hit the View Report
> button.
> I don't have the Dataset tied to anything except the Report Parameter.
> Is there a way to stop the 2nd run?
> thank you
> t
It should only be running to populate the report parameter. It sounds
like you possibly have the autorefresh set for the report (go to the:
Report drop-down tab -> Report Properties... -> General tab ->
autorefresh and see if it is selected). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you for responding Enrique ... unfortunately that box is not checked.
Any other ideas?
thank you
t
"EMartinez" wrote:
> On May 22, 11:59 am, DigHazuse <DigHaz...@.discussions.microsoft.com>
> wrote:
> > Hi,
> > I have a DDL Report Parameter tied to a Dataset.
> >
> > When I go to view the Report in RS the Dataset is run to populate the
> > Parameter, but it also seems to run the Dataset when I hit the View Report
> > button.
> >
> > I don't have the Dataset tied to anything except the Report Parameter.
> >
> > Is there a way to stop the 2nd run?
> >
> > thank you
> > t
>
> It should only be running to populate the report parameter. It sounds
> like you possibly have the autorefresh set for the report (go to the:
> Report drop-down tab -> Report Properties... -> General tab ->
> autorefresh and see if it is selected). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>sql

Report Manager Admin menu dissapearing

I've installed Reporting Services twice now. At first the administrative menu
in report manager works when I log in with an administative account and I can
upload my .RDL files. However, the next day I log in with the same account
and the administrative toolbar is gone. When I re-install it works again then
stops working. I've tried creating another administrative account and tried
logging in with that, same deal.
I don't get it, it's probably an issue with the authentication/impersonation
routines or something, but this is messed up. I don't have this issue on
another server with the same installation (Server2003, SQL2000, Reporting
Services SP2).
Any suggestions would be appreciated.Ok, I figured it out. Apparently the option to enable anonymous user access
in IIS has to checked off in both the reports and reporting services
application pools. Idiotic, you would expect it only to be required under the
reports pool as it is the one used for the report manager interface.
"Ramez" wrote:
> I've installed Reporting Services twice now. At first the administrative menu
> in report manager works when I log in with an administative account and I can
> upload my .RDL files. However, the next day I log in with the same account
> and the administrative toolbar is gone. When I re-install it works again then
> stops working. I've tried creating another administrative account and tried
> logging in with that, same deal.
> I don't get it, it's probably an issue with the authentication/impersonation
> routines or something, but this is messed up. I don't have this issue on
> another server with the same installation (Server2003, SQL2000, Reporting
> Services SP2).
> Any suggestions would be appreciated.