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
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Report Services Question

Hi all,
I wanted to be able to log on to Report Services from another computer (remotely), how can I go about doing that setup from either fresh installation or after installation? Or can anyone guide me to on where am I suppose to post this question in? Any help from anyone is appreciated.
Thanks in advance.
Daren

Daren,

I'm going to move your thread to the Reporting Services forum. They should be able to help you there.

-Jeffrey

|||ok,
thanks Jeffrey.
Daren
|||

Can you give more details about your problem? Are you talking about setting up Reporting Services from scratch on a remote machine or configuring RS after setup. All of the configuration tools that ship with Reporting Services can be used with remote machines.

-Albert

|||Hi Albert,
I will try to explain it as clearly as I possible can. To log into Reporting Services on local machine, we would use SQL Server Management Studio and select Reporting Services under Server Type section in Connect to server dialog. But now if I want to setup the server together with the Reporting Services on a server somewhere remotely (lets say on pc1). Can I remotely connect to the Reporting Services using the same way as above but try to connect using another machine (lets say pc2)?
If possible, what do I have to do to the current setup to achieve that? Or do I have to do a fresh installation with setup being done there to achieve the same result?
Hope this can explain clear enough for my question. Thank you for reading my questions and trying to answer it.
Daren
|||

Yes, you can connect to a Report Server on a remote computer using SQL Management Studio. You can install Reporting Services on pc1 and SQL Management Studio on pc2.

-Albert

|||Hi Albert,
Can you lead me on how can I do that? I tried connecting to the Server name on pc1 and it says cannot connect to server. How can I go about making the connection possible? Please help me on this. Thanks in advance.
Daren
|||

On the error message box, click the "show techincal details" button to display more information about the error. Could you please post the error details?

-Albert

|||Here is the error message: (I changed the ip to xxx.xxx.xxx.xxx)
===================================

Cannot connect to xxx.xxx.xxx.xxx.

===================================

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)


Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Daren
|||

The error indicates that there's a problem connecting to the WMI service on the remote machine. You can verify WMI connectivity using the System Information tool. Run WinMSD.exe and select "Remote Computer" from the View menu. Enter the name of the remote computer. Does this work?

-Albert

|||Hi Albert,
I managed to run WinMSD.exe but I couldn't find any "Remote Computer" from the View menu, is it possible that I am using Windows 2000 Pro with SP4 that they do not have that funciton available?
I tried right clicking the "System Information" and select Properties, a "Select Computer" screen came up, I chose "Another computer" option and type in either the IP address or the computer name of the remote computer, the following error came out:

System Information
Access denied to Windows Management Instrumentation server on \\XXX. Have an administrator run WMI Control (WBEMCNTL.exe) and change your access permissions.
XXX is either the IP address or the remote computer name. But when I try to run WBEMCNTL.exe on remote computer, the file could not be found there. My remote computer is running the same OS (Windows 2000 Pro SP4).
Any idea how can I go about solving it? Thanks for helping me Albert.
Daren
|||

I think on Windows 2000, the WMI management tool is called WMIMGMT.MSC. See this article for troubleshooting WMI problems: http://www.microsoft.com/technet/scriptcenter/topics/help/wmi.mspx.

-Albert

|||Ok sorry to bother you again Albert,
I managed to get into my remote computer using WMI management tool and see the namespace for ReportServer under Security tab in "WMI Control (Remote computer name) Properties". But I still have the same problem connecting to remote computer Reporting Services in SQL Server Management Studio. How can I resolve it?
Thank you Albert for helping me up till now.
Daren
|||

Can you connect to the remote computer with WinMSD.exe?

-Albert

|||No I still cannot connect to the remote computer with WinMSD.exe, it still gives me the access denied error.
Daren