Hi all,
When any user has created a report (based on a published model) using
ReportBuilder and wants to save it, the default save location is
../Reportserver/Models and not (as I expected) the root folder.
1) As far as I know the default save folder should be the root folder
(/Reportbuilder). Is that correct?
1-1) If yes - What causes this "misbehaviour"
2) Is it possible to change the default save folder to root (or maybe even
"My Reports")?
SW:
Windows Srv 2003 R2 SP1 - 64bit
SQL 2005 SP2 - 64bit
Thanks for any answers or comments!
PeterIf i am reading this correct
Right click the folder in solution explorer and change the default
folder location to My Reports
Cheers|||Hi!
I'm not sure if you get me right - or I get you wrong :-)
Thx for your reply.
> If i am reading this correct
Just to make it clear: I am not talking about where to publish the solution,
but where Report Builder tries to save a newly create report.
> Right click the folder in solution explorer and change the default
> folder location to My Reports
Please explain what folder I should right click?
If I open the project in VS 2005 the structure is
Project name
Data Sources
xxxxx.ds
Data Source views
xxxxx.dsv
Report Models
xxxxxxxx.smdl
Best regards,
Peter
-- Original Message --
From: "blueboy" <matt_meech@.hotmail.com>
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Sent: Monday, June 18, 2007 10:43 AM
Subject: Re: ReportBuilder default save folder is Reportserver/Models
> If i am reading this correct
> Right click the folder in solution explorer and change the default
> folder location to My Reports
> Cheers
>
"blueboy" <matt_meech@.hotmail.com> wrote in message
news:1182156196.524637.78530@.m36g2000hse.googlegroups.com...
> If i am reading this correct
> Right click the folder in solution explorer and change the default
> folder location to My Reports
> Cheers
>
Showing posts with label based. Show all posts
Showing posts with label based. Show all posts
Friday, March 30, 2012
Report's Parameter : From Date to Date
I want to add 2 parameters in my report to delimit a date range. The report is based on Analysis Services 2005 and I have created a Time Dimension. What is the best way to do this ?
I would prefer to use a Datetime parameter type because of the calendar component, but then I don't succeed to associate this parameter with the Time Dimension in the filter expression...
I really need an answer to that question, please help me
|||You can't really use a datetime parameter (at least not using the built-in prompting) as AS dates are members of a dimension, not scalars. And you aren't really guaranteed that the range between two members will give you what you want. We could add a feature at some point to convert them but that doesn't exist now.|||Thanks for the answer.
I just found a solution to my problem, even if the solution is not what I hoped for, it may help someone :
I created two Report Parameters "From Date" and "To Date" which use the calendar component to let the user choose a date. And in my Dataset, in the '...' button, in the 'Parameters' bar, I add a parameter whose value is :
="[Temps].[Temps - Date Key].[" & Year(Parameters!FromTempsTempsCalendrier.Value) & "-" & IIF(Month(Parameters!FromTempsTempsCalendrier.Value)<10,"0","") & Month(Parameters!FromTempsTempsCalendrier.Value) & "-" & IIF(Day(Parameters!FromTempsTempsCalendrier.Value)<10, "0","") & Day(Parameters!FromTempsTempsCalendrier.Value) & " 00:00:00]"
That way, I build the UNIQUENAME properties of my Time Dimension.
But an error occurs when the user select a date which does not exist in the Time Dimension.
|||Thanks for the possible solution. However, I've been working on following your steps, but I am not getting it to work.
Could you explain in a little more detail how to accomplish this?
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
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
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
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
Wednesday, March 28, 2012
Report Viewer/Default Parameters
Is it possible for one report to have different default parameters, based on the user viewing the report, when the report is accessed via the Report Viewer?
Thanks.
Assuming you are asking for viewing report through report server: default values can be (1) constant, (2) expression-based, or (3) dataset based.
Regarding (2): you could determine the default value based on the current userid, e.g =iif(User!UserId="abc", "Default1", "Default2")
Regarding (3): you could use the current user information in the query commandtext or as parameter into a stored procedure to dynamically determine the default value.
-- Robert
|||If you are using the ReportViewer control in ASP.NET, you can set the value of the parameter programatically based on the current user identity:
this.ReportViewer1.ServerReport.ReportPath = "/SampleReports/Employee Sales Summary";
ReportParameter p = new ReportParameter("EmpID", "20");
this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p });
Wednesday, March 21, 2012
Report Viewer
Is there a report viewer that I can use in a windows based application, not a
web application. If there is, where can I find it.With Widbey (Visual Studio) beta 2 they have both a winform and webform
control. Until then the only option is to either use webservices and render
it and show with something (i.e. render and show in IE control or render as
PDF and view it). Or use and IE control and use URL integration.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Arnold" <ChrisArnold@.discussions.microsoft.com> wrote in message
news:6FAF10A6-E889-464D-8ECC-C66F921BF618@.microsoft.com...
> Is there a report viewer that I can use in a windows based application,
not a
> web application. If there is, where can I find it.|||You can get a byte array of a report's output by using Reporting Services
Render() method.
Now you have plenty of options.
You can use windows IE browser control and after encoding byte array to a
char[] array just display output inside of the control.
Or you can save it as a file, if you'd like, with a random guid like name in
a temp directory and set it as a source file of your browser compnent.
About the same appoach applicable to the pdf control from Adobe or MS office
windows components.
"Chris Arnold" <ChrisArnold@.discussions.microsoft.com> wrote in message
news:6FAF10A6-E889-464D-8ECC-C66F921BF618@.microsoft.com...
> Is there a report viewer that I can use in a windows based application,
> not a
> web application. If there is, where can I find it.|||Have you looked at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Applications\ReportViewer
--
Regards
<<<Bryan Avery>>
"Chris Arnold" wrote:
> Is there a report viewer that I can use in a windows based application, not a
> web application. If there is, where can I find it.
web application. If there is, where can I find it.With Widbey (Visual Studio) beta 2 they have both a winform and webform
control. Until then the only option is to either use webservices and render
it and show with something (i.e. render and show in IE control or render as
PDF and view it). Or use and IE control and use URL integration.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Arnold" <ChrisArnold@.discussions.microsoft.com> wrote in message
news:6FAF10A6-E889-464D-8ECC-C66F921BF618@.microsoft.com...
> Is there a report viewer that I can use in a windows based application,
not a
> web application. If there is, where can I find it.|||You can get a byte array of a report's output by using Reporting Services
Render() method.
Now you have plenty of options.
You can use windows IE browser control and after encoding byte array to a
char[] array just display output inside of the control.
Or you can save it as a file, if you'd like, with a random guid like name in
a temp directory and set it as a source file of your browser compnent.
About the same appoach applicable to the pdf control from Adobe or MS office
windows components.
"Chris Arnold" <ChrisArnold@.discussions.microsoft.com> wrote in message
news:6FAF10A6-E889-464D-8ECC-C66F921BF618@.microsoft.com...
> Is there a report viewer that I can use in a windows based application,
> not a
> web application. If there is, where can I find it.|||Have you looked at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Applications\ReportViewer
--
Regards
<<<Bryan Avery>>
"Chris Arnold" wrote:
> Is there a report viewer that I can use in a windows based application, not a
> web application. If there is, where can I find it.
Report Title Help
How can I make my report title width the same as the table? The table can hide some columns based on the If/Else logic, but Report Title textbox is always static. What happens is that my table can be longer or shorter then my title.
Thanks
Yadgor2000
You can add an outermost table with two header rows to your report. Put the report title textbox in the first row, and the table you currently have into the second row. That way, the title textbox will grow or shrink based on the width of the inner table.Report times out
I have a report based on a complex query that takes a long time to run and is
timing out. I've tuned indexes the best I know how, I've set the "Do not
timeout report execution" in the Home page Site Settings and in the
individual report properties, but it still times out. Any suggestions will be
most appreciated.hi Dan,
I'm also seeing the same behavior that you are. It takes about 60 minutes
for our reports to timeout. How long do your reports run before they timeout?
Thanks,
Matt
If I make any progress on this, I will let you know.
"Dan" wrote:
> I have a report based on a complex query that takes a long time to run and is
> timing out. I've tuned indexes the best I know how, I've set the "Do not
> timeout report execution" in the Home page Site Settings and in the
> individual report properties, but it still times out. Any suggestions will be
> most appreciated.
>
timing out. I've tuned indexes the best I know how, I've set the "Do not
timeout report execution" in the Home page Site Settings and in the
individual report properties, but it still times out. Any suggestions will be
most appreciated.hi Dan,
I'm also seeing the same behavior that you are. It takes about 60 minutes
for our reports to timeout. How long do your reports run before they timeout?
Thanks,
Matt
If I make any progress on this, I will let you know.
"Dan" wrote:
> I have a report based on a complex query that takes a long time to run and is
> timing out. I've tuned indexes the best I know how, I've set the "Do not
> timeout report execution" in the Home page Site Settings and in the
> individual report properties, but it still times out. Any suggestions will be
> most appreciated.
>
Monday, February 20, 2012
Report referencing dynamic table
Hi all
Just wondering how one would approach buidling an RS report based on a
dynamic table ie. Each time the report is run, the table may have a
different number of columns.
Here is what I'm trying to acheive:
The user enters a date range for the report. The report then calls a SQL
stored proc which generates a table containing columns for each day in the
date range. That table is then used as a datasource in the report.
Any assistance guidance will be appreciated
Thanks in advance
GeorgeOn Jul 5, 6:23 pm, "_george" <none@.nojne@.none> wrote:
> Hi all
> Just wondering how one would approach buidling an RS report based on a
> dynamic table ie. Each time the report is run, the table may have a
> different number of columns.
> Here is what I'm trying to acheive:
> The user enters a date range for the report. The report then calls a SQL
> stored proc which generates a table containing columns for each day in the
> date range. That table is then used as a datasource in the report.
> Any assistance guidance will be appreciated
> Thanks in advance
> George
The best way to handle this is to use a matrix report. The days would
appear as columns in the matrix report; of course, it supports dynamic
pivoted columns. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Just wondering how one would approach buidling an RS report based on a
dynamic table ie. Each time the report is run, the table may have a
different number of columns.
Here is what I'm trying to acheive:
The user enters a date range for the report. The report then calls a SQL
stored proc which generates a table containing columns for each day in the
date range. That table is then used as a datasource in the report.
Any assistance guidance will be appreciated
Thanks in advance
GeorgeOn Jul 5, 6:23 pm, "_george" <none@.nojne@.none> wrote:
> Hi all
> Just wondering how one would approach buidling an RS report based on a
> dynamic table ie. Each time the report is run, the table may have a
> different number of columns.
> Here is what I'm trying to acheive:
> The user enters a date range for the report. The report then calls a SQL
> stored proc which generates a table containing columns for each day in the
> date range. That table is then used as a datasource in the report.
> Any assistance guidance will be appreciated
> Thanks in advance
> George
The best way to handle this is to use a matrix report. The days would
appear as columns in the matrix report; of course, it supports dynamic
pivoted columns. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Subscribe to:
Posts (Atom)