report wont refresh when accessed remotely

I have a report that is based on a straight forward query of
select * from tblx
No parameters ...
tblx gets populated by processes from an application that get invoked from a
command button. In the same process I then invoke the report using my
published url. The report comes up OK. But when I change the data in tblx
and bring up the report, it is still displaying the old data. Do I need to
add parameters to the query for it to refresh the data? Could someone
explain why the report does not refresh with the new data in tblx?
Thanks,
RichThank you for your reply. I am using RS2003 with sql server 2000. I went to
report properties but I don't see a report manager or anything about
execution. I went to the project properties - where I set the URL but I did
not see anything for executive there either. Is there somewhere on the
toolbar I can go to for locating the Report Manager or something about
execution?
Thanks,
Rich
"Chris Conner" wrote:
> This is easily fixed...
> Turn off caching for the report. By default, it is cached for 30 minutes. It
> does this since you will more often view data that is static, i.e. in the
> past, than current real time changes.
> To change the cache setting for the report, go to the report itself and view
> its properties in the report manager. Look to your left and you will see
> "execution settings". click that, next you should see the cache options
> available. Set it to your liking. :)
> Here is what you should see - just select "Do not cache temporary copies of
> this report"
> Always run this report with the most recent data
> Do not cache temporary copies of this report
> Cache a temporary copy of the report. Expire copy of report after
> a number of minutes: Missing expiration value
> The timeout value is not valid. It is either a
> negative integer or it is too large.
>
> Cache a temporary copy of the report. Expire copy of report on
> the following schedule:
> Report-specific schedule
> Shared schedule Select a shared schedule
>
>
> =-Chris
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >I have a report that is based on a straight forward query of
> >
> > select * from tblx
> >
> > No parameters ...
> >
> > tblx gets populated by processes from an application that get invoked from
> > a
> > command button. In the same process I then invoke the report using my
> > published url. The report comes up OK. But when I change the data in
> > tblx
> > and bring up the report, it is still displaying the old data. Do I need
> > to
> > add parameters to the query for it to refresh the data? Could someone
> > explain why the report does not refresh with the new data in tblx?
> >
> > Thanks,
> > Rich
>
>|||Report manager is the name of the portal. It is the website provided by RS
to display the reports.
http://YourServer/Reports/Pages/Folder.aspx
Click on a report, click on the properties tab, on the left you will see
execution (I assume it is there for 2000). You will definitely see other
items like General, Security, etc.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> Thank you for your reply. I am using RS2003 with sql server 2000. I went
> to
> report properties but I don't see a report manager or anything about
> execution. I went to the project properties - where I set the URL but I
> did
> not see anything for executive there either. Is there somewhere on the
> toolbar I can go to for locating the Report Manager or something about
> execution?
> Thanks,
> Rich
> "Chris Conner" wrote:
>> This is easily fixed...
>> Turn off caching for the report. By default, it is cached for 30 minutes.
>> It
>> does this since you will more often view data that is static, i.e. in the
>> past, than current real time changes.
>> To change the cache setting for the report, go to the report itself and
>> view
>> its properties in the report manager. Look to your left and you will see
>> "execution settings". click that, next you should see the cache options
>> available. Set it to your liking. :)
>> Here is what you should see - just select "Do not cache temporary copies
>> of
>> this report"
>> Always run this report with the most recent data
>> Do not cache temporary copies of this report
>> Cache a temporary copy of the report. Expire copy of report
>> after
>> a number of minutes: Missing expiration value
>> The timeout value is not valid. It is either a
>> negative integer or it is too large.
>>
>> Cache a temporary copy of the report. Expire copy of report on
>> the following schedule:
>> Report-specific schedule
>> Shared schedule Select a shared schedule
>>
>>
>> =-Chris
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >I have a report that is based on a straight forward query of
>> >
>> > select * from tblx
>> >
>> > No parameters ...
>> >
>> > tblx gets populated by processes from an application that get invoked
>> > from
>> > a
>> > command button. In the same process I then invoke the report using my
>> > published url. The report comes up OK. But when I change the data in
>> > tblx
>> > and bring up the report, it is still displaying the old data. Do I
>> > need
>> > to
>> > add parameters to the query for it to refresh the data? Could someone
>> > explain why the report does not refresh with the new data in tblx?
>> >
>> > Thanks,
>> > Rich
>>|||Thank you for this advice. Well, to reveal my ignorance,
I typed this in the address bar of my browser
http://myservername/Reports/Pages/Folder.aspx
which did not return anything. So then I tried
http://myservername/ReportServer/Reports/Pages/Folder.aspx
which also did not return anything (good). Then I tried
http://myservername/ReportServer/Reports/Pages/Invoices.aspx
Invoices is the folder where I deploy my report to. But nothing. My
intuitive skills are a little bit less than meager (at best). May I request
if you could show me an example of what specific address I need to type?
Thank again for your reply and for your help.
Rich
"Bruce L-C [MVP]" wrote:
> Report manager is the name of the portal. It is the website provided by RS
> to display the reports.
> http://YourServer/Reports/Pages/Folder.aspx
> Click on a report, click on the properties tab, on the left you will see
> execution (I assume it is there for 2000). You will definitely see other
> items like General, Security, etc.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> > Thank you for your reply. I am using RS2003 with sql server 2000. I went
> > to
> > report properties but I don't see a report manager or anything about
> > execution. I went to the project properties - where I set the URL but I
> > did
> > not see anything for executive there either. Is there somewhere on the
> > toolbar I can go to for locating the Report Manager or something about
> > execution?
> >
> > Thanks,
> > Rich
> >
> > "Chris Conner" wrote:
> >
> >> This is easily fixed...
> >>
> >> Turn off caching for the report. By default, it is cached for 30 minutes.
> >> It
> >> does this since you will more often view data that is static, i.e. in the
> >> past, than current real time changes.
> >>
> >> To change the cache setting for the report, go to the report itself and
> >> view
> >> its properties in the report manager. Look to your left and you will see
> >> "execution settings". click that, next you should see the cache options
> >> available. Set it to your liking. :)
> >>
> >> Here is what you should see - just select "Do not cache temporary copies
> >> of
> >> this report"
> >>
> >> Always run this report with the most recent data
> >> Do not cache temporary copies of this report
> >> Cache a temporary copy of the report. Expire copy of report
> >> after
> >> a number of minutes: Missing expiration value
> >> The timeout value is not valid. It is either a
> >> negative integer or it is too large.
> >>
> >>
> >> Cache a temporary copy of the report. Expire copy of report on
> >> the following schedule:
> >>
> >> Report-specific schedule
> >> Shared schedule Select a shared schedule
> >>
> >>
> >>
> >>
> >> =-Chris
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >> >I have a report that is based on a straight forward query of
> >> >
> >> > select * from tblx
> >> >
> >> > No parameters ...
> >> >
> >> > tblx gets populated by processes from an application that get invoked
> >> > from
> >> > a
> >> > command button. In the same process I then invoke the report using my
> >> > published url. The report comes up OK. But when I change the data in
> >> > tblx
> >> > and bring up the report, it is still displaying the old data. Do I
> >> > need
> >> > to
> >> > add parameters to the query for it to refresh the data? Could someone
> >> > explain why the report does not refresh with the new data in tblx?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>|||As far as I know every RS installation has report manager. For one thing,
that is how you set up security roles. Plus you use it for other things like
setting credentials for data sources etc.
When you say this did not return anything:
http://myservername/Reports/Pages/Folder.aspx
Did you get any message? Sometimes you need to put in fully qualified server
name http://myservername.whatever.com/Reports/Pages/Folder.aspx
If you have a working Reporting Server then someone in you organization has
to know about this.
Also, even if there, you would need to be in the proper role to be able to
make a change.
If it comes up and there are no folders then that is because you are not in
the correct role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
> Thank you for this advice. Well, to reveal my ignorance,
> I typed this in the address bar of my browser
> http://myservername/Reports/Pages/Folder.aspx
> which did not return anything. So then I tried
> http://myservername/ReportServer/Reports/Pages/Folder.aspx
> which also did not return anything (good). Then I tried
> http://myservername/ReportServer/Reports/Pages/Invoices.aspx
> Invoices is the folder where I deploy my report to. But nothing. My
> intuitive skills are a little bit less than meager (at best). May I
> request
> if you could show me an example of what specific address I need to type?
> Thank again for your reply and for your help.
> Rich
>
> "Bruce L-C [MVP]" wrote:
>> Report manager is the name of the portal. It is the website provided by
>> RS
>> to display the reports.
>> http://YourServer/Reports/Pages/Folder.aspx
>> Click on a report, click on the properties tab, on the left you will see
>> execution (I assume it is there for 2000). You will definitely see other
>> items like General, Security, etc.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
>> > Thank you for your reply. I am using RS2003 with sql server 2000. I
>> > went
>> > to
>> > report properties but I don't see a report manager or anything about
>> > execution. I went to the project properties - where I set the URL but
>> > I
>> > did
>> > not see anything for executive there either. Is there somewhere on the
>> > toolbar I can go to for locating the Report Manager or something about
>> > execution?
>> >
>> > Thanks,
>> > Rich
>> >
>> > "Chris Conner" wrote:
>> >
>> >> This is easily fixed...
>> >>
>> >> Turn off caching for the report. By default, it is cached for 30
>> >> minutes.
>> >> It
>> >> does this since you will more often view data that is static, i.e. in
>> >> the
>> >> past, than current real time changes.
>> >>
>> >> To change the cache setting for the report, go to the report itself
>> >> and
>> >> view
>> >> its properties in the report manager. Look to your left and you will
>> >> see
>> >> "execution settings". click that, next you should see the cache
>> >> options
>> >> available. Set it to your liking. :)
>> >>
>> >> Here is what you should see - just select "Do not cache temporary
>> >> copies
>> >> of
>> >> this report"
>> >>
>> >> Always run this report with the most recent data
>> >> Do not cache temporary copies of this report
>> >> Cache a temporary copy of the report. Expire copy of report
>> >> after
>> >> a number of minutes: Missing expiration value
>> >> The timeout value is not valid. It is either a
>> >> negative integer or it is too large.
>> >>
>> >>
>> >> Cache a temporary copy of the report. Expire copy of report
>> >> on
>> >> the following schedule:
>> >>
>> >> Report-specific schedule
>> >> Shared schedule Select a shared schedule
>> >>
>> >>
>> >>
>> >>
>> >> =-Chris
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >> >I have a report that is based on a straight forward query of
>> >> >
>> >> > select * from tblx
>> >> >
>> >> > No parameters ...
>> >> >
>> >> > tblx gets populated by processes from an application that get
>> >> > invoked
>> >> > from
>> >> > a
>> >> > command button. In the same process I then invoke the report using
>> >> > my
>> >> > published url. The report comes up OK. But when I change the data
>> >> > in
>> >> > tblx
>> >> > and bring up the report, it is still displaying the old data. Do I
>> >> > need
>> >> > to
>> >> > add parameters to the query for it to refresh the data? Could
>> >> > someone
>> >> > explain why the report does not refresh with the new data in tblx?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >>
>> >>
>> >>
>>|||Thank you again. So this time I made sure that I typed in
https://myservername/Reports/Pages/Folder.aspx
and now I did get something:
Error:
The request failed with HTTP status 401: Unauthorized.
I also tried https://...
Well, at least this time I got something besides page can't be found...
What do I need to configure for authorization?
Thanks again,
Rich
"Bruce L-C [MVP]" wrote:
> As far as I know every RS installation has report manager. For one thing,
> that is how you set up security roles. Plus you use it for other things like
> setting credentials for data sources etc.
> When you say this did not return anything:
> http://myservername/Reports/Pages/Folder.aspx
> Did you get any message? Sometimes you need to put in fully qualified server
> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
> If you have a working Reporting Server then someone in you organization has
> to know about this.
> Also, even if there, you would need to be in the proper role to be able to
> make a change.
> If it comes up and there are no folders then that is because you are not in
> the correct role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
> > Thank you for this advice. Well, to reveal my ignorance,
> >
> > I typed this in the address bar of my browser
> >
> > http://myservername/Reports/Pages/Folder.aspx
> >
> > which did not return anything. So then I tried
> >
> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
> >
> > which also did not return anything (good). Then I tried
> >
> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
> >
> > Invoices is the folder where I deploy my report to. But nothing. My
> > intuitive skills are a little bit less than meager (at best). May I
> > request
> > if you could show me an example of what specific address I need to type?
> >
> > Thank again for your reply and for your help.
> >
> > Rich
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Report manager is the name of the portal. It is the website provided by
> >> RS
> >> to display the reports.
> >> http://YourServer/Reports/Pages/Folder.aspx
> >>
> >> Click on a report, click on the properties tab, on the left you will see
> >> execution (I assume it is there for 2000). You will definitely see other
> >> items like General, Security, etc.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> >> > Thank you for your reply. I am using RS2003 with sql server 2000. I
> >> > went
> >> > to
> >> > report properties but I don't see a report manager or anything about
> >> > execution. I went to the project properties - where I set the URL but
> >> > I
> >> > did
> >> > not see anything for executive there either. Is there somewhere on the
> >> > toolbar I can go to for locating the Report Manager or something about
> >> > execution?
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Chris Conner" wrote:
> >> >
> >> >> This is easily fixed...
> >> >>
> >> >> Turn off caching for the report. By default, it is cached for 30
> >> >> minutes.
> >> >> It
> >> >> does this since you will more often view data that is static, i.e. in
> >> >> the
> >> >> past, than current real time changes.
> >> >>
> >> >> To change the cache setting for the report, go to the report itself
> >> >> and
> >> >> view
> >> >> its properties in the report manager. Look to your left and you will
> >> >> see
> >> >> "execution settings". click that, next you should see the cache
> >> >> options
> >> >> available. Set it to your liking. :)
> >> >>
> >> >> Here is what you should see - just select "Do not cache temporary
> >> >> copies
> >> >> of
> >> >> this report"
> >> >>
> >> >> Always run this report with the most recent data
> >> >> Do not cache temporary copies of this report
> >> >> Cache a temporary copy of the report. Expire copy of report
> >> >> after
> >> >> a number of minutes: Missing expiration value
> >> >> The timeout value is not valid. It is either a
> >> >> negative integer or it is too large.
> >> >>
> >> >>
> >> >> Cache a temporary copy of the report. Expire copy of report
> >> >> on
> >> >> the following schedule:
> >> >>
> >> >> Report-specific schedule
> >> >> Shared schedule Select a shared schedule
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> =-Chris
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >> >> >I have a report that is based on a straight forward query of
> >> >> >
> >> >> > select * from tblx
> >> >> >
> >> >> > No parameters ...
> >> >> >
> >> >> > tblx gets populated by processes from an application that get
> >> >> > invoked
> >> >> > from
> >> >> > a
> >> >> > command button. In the same process I then invoke the report using
> >> >> > my
> >> >> > published url. The report comes up OK. But when I change the data
> >> >> > in
> >> >> > tblx
> >> >> > and bring up the report, it is still displaying the old data. Do I
> >> >> > need
> >> >> > to
> >> >> > add parameters to the query for it to refresh the data? Could
> >> >> > someone
> >> >> > explain why the report does not refresh with the new data in tblx?
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I'm confused, how do you even have anything working? This thread initially
started because of an issue with execution and caching.
Someone has to be an administrator on your Report Server site. Who is that?
They should be either doing this for you or setting you up with the correct
role. In Books Online look up the word roles filtered by SQL Server
Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:8330836A-A842-4B9E-9AD6-B3011DA6D006@.microsoft.com...
> Thank you again. So this time I made sure that I typed in
> https://myservername/Reports/Pages/Folder.aspx
> and now I did get something:
> Error:
> The request failed with HTTP status 401: Unauthorized.
> I also tried https://...
> Well, at least this time I got something besides page can't be found...
> What do I need to configure for authorization?
> Thanks again,
> Rich
> "Bruce L-C [MVP]" wrote:
>> As far as I know every RS installation has report manager. For one thing,
>> that is how you set up security roles. Plus you use it for other things
>> like
>> setting credentials for data sources etc.
>> When you say this did not return anything:
>> http://myservername/Reports/Pages/Folder.aspx
>> Did you get any message? Sometimes you need to put in fully qualified
>> server
>> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
>> If you have a working Reporting Server then someone in you organization
>> has
>> to know about this.
>> Also, even if there, you would need to be in the proper role to be able
>> to
>> make a change.
>> If it comes up and there are no folders then that is because you are not
>> in
>> the correct role.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
>> > Thank you for this advice. Well, to reveal my ignorance,
>> >
>> > I typed this in the address bar of my browser
>> >
>> > http://myservername/Reports/Pages/Folder.aspx
>> >
>> > which did not return anything. So then I tried
>> >
>> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
>> >
>> > which also did not return anything (good). Then I tried
>> >
>> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
>> >
>> > Invoices is the folder where I deploy my report to. But nothing. My
>> > intuitive skills are a little bit less than meager (at best). May I
>> > request
>> > if you could show me an example of what specific address I need to
>> > type?
>> >
>> > Thank again for your reply and for your help.
>> >
>> > Rich
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Report manager is the name of the portal. It is the website provided
>> >> by
>> >> RS
>> >> to display the reports.
>> >> http://YourServer/Reports/Pages/Folder.aspx
>> >>
>> >> Click on a report, click on the properties tab, on the left you will
>> >> see
>> >> execution (I assume it is there for 2000). You will definitely see
>> >> other
>> >> items like General, Security, etc.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
>> >> > Thank you for your reply. I am using RS2003 with sql server 2000.
>> >> > I
>> >> > went
>> >> > to
>> >> > report properties but I don't see a report manager or anything about
>> >> > execution. I went to the project properties - where I set the URL
>> >> > but
>> >> > I
>> >> > did
>> >> > not see anything for executive there either. Is there somewhere on
>> >> > the
>> >> > toolbar I can go to for locating the Report Manager or something
>> >> > about
>> >> > execution?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >> >
>> >> > "Chris Conner" wrote:
>> >> >
>> >> >> This is easily fixed...
>> >> >>
>> >> >> Turn off caching for the report. By default, it is cached for 30
>> >> >> minutes.
>> >> >> It
>> >> >> does this since you will more often view data that is static, i.e.
>> >> >> in
>> >> >> the
>> >> >> past, than current real time changes.
>> >> >>
>> >> >> To change the cache setting for the report, go to the report itself
>> >> >> and
>> >> >> view
>> >> >> its properties in the report manager. Look to your left and you
>> >> >> will
>> >> >> see
>> >> >> "execution settings". click that, next you should see the cache
>> >> >> options
>> >> >> available. Set it to your liking. :)
>> >> >>
>> >> >> Here is what you should see - just select "Do not cache temporary
>> >> >> copies
>> >> >> of
>> >> >> this report"
>> >> >>
>> >> >> Always run this report with the most recent data
>> >> >> Do not cache temporary copies of this report
>> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> report
>> >> >> after
>> >> >> a number of minutes: Missing expiration value
>> >> >> The timeout value is not valid. It is either
>> >> >> a
>> >> >> negative integer or it is too large.
>> >> >>
>> >> >>
>> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> report
>> >> >> on
>> >> >> the following schedule:
>> >> >>
>> >> >> Report-specific schedule
>> >> >> Shared schedule Select a shared schedule
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> =-Chris
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >> >> >I have a report that is based on a straight forward query of
>> >> >> >
>> >> >> > select * from tblx
>> >> >> >
>> >> >> > No parameters ...
>> >> >> >
>> >> >> > tblx gets populated by processes from an application that get
>> >> >> > invoked
>> >> >> > from
>> >> >> > a
>> >> >> > command button. In the same process I then invoke the report
>> >> >> > using
>> >> >> > my
>> >> >> > published url. The report comes up OK. But when I change the
>> >> >> > data
>> >> >> > in
>> >> >> > tblx
>> >> >> > and bring up the report, it is still displaying the old data.
>> >> >> > Do I
>> >> >> > need
>> >> >> > to
>> >> >> > add parameters to the query for it to refresh the data? Could
>> >> >> > someone
>> >> >> > explain why the report does not refresh with the new data in
>> >> >> > tblx?
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Rich
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks. I am currently working for a small subscription firm. I am still
relatively new to Reporting Services. The owner's son manages the network
(real young guy), and I did not set up RS. It was already in place. The
only RS I ever set up was the free one from msdn, and I don't recall having
to set up roles. Anwya, I found an introductory article on google about
roles/security for RS. At least I got some direction from this post on which
way to go.
Rich
"Bruce L-C [MVP]" wrote:
> I'm confused, how do you even have anything working? This thread initially
> started because of an issue with execution and caching.
> Someone has to be an administrator on your Report Server site. Who is that?
> They should be either doing this for you or setting you up with the correct
> role. In Books Online look up the word roles filtered by SQL Server
> Reporting Services.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:8330836A-A842-4B9E-9AD6-B3011DA6D006@.microsoft.com...
> > Thank you again. So this time I made sure that I typed in
> >
> > https://myservername/Reports/Pages/Folder.aspx
> >
> > and now I did get something:
> >
> > Error:
> >
> > The request failed with HTTP status 401: Unauthorized.
> >
> > I also tried https://...
> >
> > Well, at least this time I got something besides page can't be found...
> > What do I need to configure for authorization?
> >
> > Thanks again,
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> As far as I know every RS installation has report manager. For one thing,
> >> that is how you set up security roles. Plus you use it for other things
> >> like
> >> setting credentials for data sources etc.
> >> When you say this did not return anything:
> >> http://myservername/Reports/Pages/Folder.aspx
> >> Did you get any message? Sometimes you need to put in fully qualified
> >> server
> >> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
> >>
> >> If you have a working Reporting Server then someone in you organization
> >> has
> >> to know about this.
> >>
> >> Also, even if there, you would need to be in the proper role to be able
> >> to
> >> make a change.
> >>
> >> If it comes up and there are no folders then that is because you are not
> >> in
> >> the correct role.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
> >> > Thank you for this advice. Well, to reveal my ignorance,
> >> >
> >> > I typed this in the address bar of my browser
> >> >
> >> > http://myservername/Reports/Pages/Folder.aspx
> >> >
> >> > which did not return anything. So then I tried
> >> >
> >> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
> >> >
> >> > which also did not return anything (good). Then I tried
> >> >
> >> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
> >> >
> >> > Invoices is the folder where I deploy my report to. But nothing. My
> >> > intuitive skills are a little bit less than meager (at best). May I
> >> > request
> >> > if you could show me an example of what specific address I need to
> >> > type?
> >> >
> >> > Thank again for your reply and for your help.
> >> >
> >> > Rich
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Report manager is the name of the portal. It is the website provided
> >> >> by
> >> >> RS
> >> >> to display the reports.
> >> >> http://YourServer/Reports/Pages/Folder.aspx
> >> >>
> >> >> Click on a report, click on the properties tab, on the left you will
> >> >> see
> >> >> execution (I assume it is there for 2000). You will definitely see
> >> >> other
> >> >> items like General, Security, etc.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
> >> >> > Thank you for your reply. I am using RS2003 with sql server 2000.
> >> >> > I
> >> >> > went
> >> >> > to
> >> >> > report properties but I don't see a report manager or anything about
> >> >> > execution. I went to the project properties - where I set the URL
> >> >> > but
> >> >> > I
> >> >> > did
> >> >> > not see anything for executive there either. Is there somewhere on
> >> >> > the
> >> >> > toolbar I can go to for locating the Report Manager or something
> >> >> > about
> >> >> > execution?
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >> >
> >> >> > "Chris Conner" wrote:
> >> >> >
> >> >> >> This is easily fixed...
> >> >> >>
> >> >> >> Turn off caching for the report. By default, it is cached for 30
> >> >> >> minutes.
> >> >> >> It
> >> >> >> does this since you will more often view data that is static, i.e.
> >> >> >> in
> >> >> >> the
> >> >> >> past, than current real time changes.
> >> >> >>
> >> >> >> To change the cache setting for the report, go to the report itself
> >> >> >> and
> >> >> >> view
> >> >> >> its properties in the report manager. Look to your left and you
> >> >> >> will
> >> >> >> see
> >> >> >> "execution settings". click that, next you should see the cache
> >> >> >> options
> >> >> >> available. Set it to your liking. :)
> >> >> >>
> >> >> >> Here is what you should see - just select "Do not cache temporary
> >> >> >> copies
> >> >> >> of
> >> >> >> this report"
> >> >> >>
> >> >> >> Always run this report with the most recent data
> >> >> >> Do not cache temporary copies of this report
> >> >> >> Cache a temporary copy of the report. Expire copy of
> >> >> >> report
> >> >> >> after
> >> >> >> a number of minutes: Missing expiration value
> >> >> >> The timeout value is not valid. It is either
> >> >> >> a
> >> >> >> negative integer or it is too large.
> >> >> >>
> >> >> >>
> >> >> >> Cache a temporary copy of the report. Expire copy of
> >> >> >> report
> >> >> >> on
> >> >> >> the following schedule:
> >> >> >>
> >> >> >> Report-specific schedule
> >> >> >> Shared schedule Select a shared schedule
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> =-Chris
> >> >> >>
> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
> >> >> >> >I have a report that is based on a straight forward query of
> >> >> >> >
> >> >> >> > select * from tblx
> >> >> >> >
> >> >> >> > No parameters ...
> >> >> >> >
> >> >> >> > tblx gets populated by processes from an application that get
> >> >> >> > invoked
> >> >> >> > from
> >> >> >> > a
> >> >> >> > command button. In the same process I then invoke the report
> >> >> >> > using
> >> >> >> > my
> >> >> >> > published url. The report comes up OK. But when I change the
> >> >> >> > data
> >> >> >> > in
> >> >> >> > tblx
> >> >> >> > and bring up the report, it is still displaying the old data.
> >> >> >> > Do I
> >> >> >> > need
> >> >> >> > to
> >> >> >> > add parameters to the query for it to refresh the data? Could
> >> >> >> > someone
> >> >> >> > explain why the report does not refresh with the new data in
> >> >> >> > tblx?
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> > Rich
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||The reason you didn't have to set up roles before was because if you
installed everything on your machine and you were a local admin for the
machine, then you automatically are in the administrator role for RS.
One easy way, if they add your userid to the local adminstrators account on
the server then you will be good to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:A8B42DAE-07A1-4500-873E-8535FB787DDF@.microsoft.com...
> Thanks. I am currently working for a small subscription firm. I am still
> relatively new to Reporting Services. The owner's son manages the network
> (real young guy), and I did not set up RS. It was already in place. The
> only RS I ever set up was the free one from msdn, and I don't recall
> having
> to set up roles. Anwya, I found an introductory article on google about
> roles/security for RS. At least I got some direction from this post on
> which
> way to go.
> Rich
> "Bruce L-C [MVP]" wrote:
>> I'm confused, how do you even have anything working? This thread
>> initially
>> started because of an issue with execution and caching.
>> Someone has to be an administrator on your Report Server site. Who is
>> that?
>> They should be either doing this for you or setting you up with the
>> correct
>> role. In Books Online look up the word roles filtered by SQL Server
>> Reporting Services.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:8330836A-A842-4B9E-9AD6-B3011DA6D006@.microsoft.com...
>> > Thank you again. So this time I made sure that I typed in
>> >
>> > https://myservername/Reports/Pages/Folder.aspx
>> >
>> > and now I did get something:
>> >
>> > Error:
>> >
>> > The request failed with HTTP status 401: Unauthorized.
>> >
>> > I also tried https://...
>> >
>> > Well, at least this time I got something besides page can't be found...
>> > What do I need to configure for authorization?
>> >
>> > Thanks again,
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> As far as I know every RS installation has report manager. For one
>> >> thing,
>> >> that is how you set up security roles. Plus you use it for other
>> >> things
>> >> like
>> >> setting credentials for data sources etc.
>> >> When you say this did not return anything:
>> >> http://myservername/Reports/Pages/Folder.aspx
>> >> Did you get any message? Sometimes you need to put in fully qualified
>> >> server
>> >> name http://myservername.whatever.com/Reports/Pages/Folder.aspx
>> >>
>> >> If you have a working Reporting Server then someone in you
>> >> organization
>> >> has
>> >> to know about this.
>> >>
>> >> Also, even if there, you would need to be in the proper role to be
>> >> able
>> >> to
>> >> make a change.
>> >>
>> >> If it comes up and there are no folders then that is because you are
>> >> not
>> >> in
>> >> the correct role.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:D457FC39-F037-4293-9707-452A7B2D27BF@.microsoft.com...
>> >> > Thank you for this advice. Well, to reveal my ignorance,
>> >> >
>> >> > I typed this in the address bar of my browser
>> >> >
>> >> > http://myservername/Reports/Pages/Folder.aspx
>> >> >
>> >> > which did not return anything. So then I tried
>> >> >
>> >> > http://myservername/ReportServer/Reports/Pages/Folder.aspx
>> >> >
>> >> > which also did not return anything (good). Then I tried
>> >> >
>> >> > http://myservername/ReportServer/Reports/Pages/Invoices.aspx
>> >> >
>> >> > Invoices is the folder where I deploy my report to. But nothing.
>> >> > My
>> >> > intuitive skills are a little bit less than meager (at best). May I
>> >> > request
>> >> > if you could show me an example of what specific address I need to
>> >> > type?
>> >> >
>> >> > Thank again for your reply and for your help.
>> >> >
>> >> > Rich
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Report manager is the name of the portal. It is the website
>> >> >> provided
>> >> >> by
>> >> >> RS
>> >> >> to display the reports.
>> >> >> http://YourServer/Reports/Pages/Folder.aspx
>> >> >>
>> >> >> Click on a report, click on the properties tab, on the left you
>> >> >> will
>> >> >> see
>> >> >> execution (I assume it is there for 2000). You will definitely see
>> >> >> other
>> >> >> items like General, Security, etc.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:F7326EDC-FB18-467F-8BDA-98E351058EB6@.microsoft.com...
>> >> >> > Thank you for your reply. I am using RS2003 with sql server
>> >> >> > 2000.
>> >> >> > I
>> >> >> > went
>> >> >> > to
>> >> >> > report properties but I don't see a report manager or anything
>> >> >> > about
>> >> >> > execution. I went to the project properties - where I set the
>> >> >> > URL
>> >> >> > but
>> >> >> > I
>> >> >> > did
>> >> >> > not see anything for executive there either. Is there somewhere
>> >> >> > on
>> >> >> > the
>> >> >> > toolbar I can go to for locating the Report Manager or something
>> >> >> > about
>> >> >> > execution?
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Rich
>> >> >> >
>> >> >> > "Chris Conner" wrote:
>> >> >> >
>> >> >> >> This is easily fixed...
>> >> >> >>
>> >> >> >> Turn off caching for the report. By default, it is cached for 30
>> >> >> >> minutes.
>> >> >> >> It
>> >> >> >> does this since you will more often view data that is static,
>> >> >> >> i.e.
>> >> >> >> in
>> >> >> >> the
>> >> >> >> past, than current real time changes.
>> >> >> >>
>> >> >> >> To change the cache setting for the report, go to the report
>> >> >> >> itself
>> >> >> >> and
>> >> >> >> view
>> >> >> >> its properties in the report manager. Look to your left and you
>> >> >> >> will
>> >> >> >> see
>> >> >> >> "execution settings". click that, next you should see the cache
>> >> >> >> options
>> >> >> >> available. Set it to your liking. :)
>> >> >> >>
>> >> >> >> Here is what you should see - just select "Do not cache
>> >> >> >> temporary
>> >> >> >> copies
>> >> >> >> of
>> >> >> >> this report"
>> >> >> >>
>> >> >> >> Always run this report with the most recent data
>> >> >> >> Do not cache temporary copies of this report
>> >> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> >> report
>> >> >> >> after
>> >> >> >> a number of minutes: Missing expiration value
>> >> >> >> The timeout value is not valid. It is
>> >> >> >> either
>> >> >> >> a
>> >> >> >> negative integer or it is too large.
>> >> >> >>
>> >> >> >>
>> >> >> >> Cache a temporary copy of the report. Expire copy of
>> >> >> >> report
>> >> >> >> on
>> >> >> >> the following schedule:
>> >> >> >>
>> >> >> >> Report-specific schedule
>> >> >> >> Shared schedule Select a shared schedule
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> =-Chris
>> >> >> >>
>> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> >> news:10673380-4C29-46B4-BAB0-F3087ED46C87@.microsoft.com...
>> >> >> >> >I have a report that is based on a straight forward query of
>> >> >> >> >
>> >> >> >> > select * from tblx
>> >> >> >> >
>> >> >> >> > No parameters ...
>> >> >> >> >
>> >> >> >> > tblx gets populated by processes from an application that get
>> >> >> >> > invoked
>> >> >> >> > from
>> >> >> >> > a
>> >> >> >> > command button. In the same process I then invoke the report
>> >> >> >> > using
>> >> >> >> > my
>> >> >> >> > published url. The report comes up OK. But when I change the
>> >> >> >> > data
>> >> >> >> > in
>> >> >> >> > tblx
>> >> >> >> > and bring up the report, it is still displaying the old data.
>> >> >> >> > Do I
>> >> >> >> > need
>> >> >> >> > to
>> >> >> >> > add parameters to the query for it to refresh the data? Could
>> >> >> >> > someone
>> >> >> >> > explain why the report does not refresh with the new data in
>> >> >> >> > tblx?
>> >> >> >> >
>> >> >> >> > Thanks,
>> >> >> >> > Rich
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>