Changes on the design of the templates not showing

I made some changes on the design of the report's templates. I do that
locally, and then deploy and upload to the server. I haven't been able to see
those changes on the working website. I have the following:
Windows 2003 SP1
IIS 6.0
.Net Framework 1.1 SP2
SQL 2000 Enterprise Edition
SQL Reporting Services
SQL SP4
Visual Studio 2003
Am I missing something? I made the changes on the reports' solution file,
built, then deploy. After that, I went to the other solution (the one that
has my aspx application) then built.
Can somebody help me please? I have been trying a lot of different things
but nothing seems to work.
Thank you!!!I would first check that the target url for your report project is infact the
server you are attempting to update. Next, use report manager on your server
to verify the file date of your newly modified report.
If those all seem in order, you may need to reset IIS. I've noticed these
report formats (not the data) often cache themselves on the IIS server.
Hope that helps!
"Lucrecia" wrote:
> I made some changes on the design of the report's templates. I do that
> locally, and then deploy and upload to the server. I haven't been able to see
> those changes on the working website. I have the following:
> Windows 2003 SP1
> IIS 6.0
> .Net Framework 1.1 SP2
> SQL 2000 Enterprise Edition
> SQL Reporting Services
> SQL SP4
> Visual Studio 2003
> Am I missing something? I made the changes on the reports' solution file,
> built, then deploy. After that, I went to the other solution (the one that
> has my aspx application) then built.
> Can somebody help me please? I have been trying a lot of different things
> but nothing seems to work.
> Thank you!!!|||Thank you for answering. I tried resetting the IIS, it didn't work. I noticed
that the date of the reports in the localhost/Reportserver are really old,
and the weird thing is that the files that I have on my folder are the ones I
just modified. Is there anyway I can find out were the reports of that
localhost/Reportserver are located on the hard disk?
Another thing is that I am working with 2 computers, in one I have the VS
2003 where I am doing the changes on the reports' design, and the other one
is the server where I have the database and the rest of the stuff. So what I
do is that I deploy (I changed the Overwrite property to true), then build
the report.sln, then build the complete application. Does this affect
somehow?
"justinsaraceno" wrote:
> I would first check that the target url for your report project is infact the
> server you are attempting to update. Next, use report manager on your server
> to verify the file date of your newly modified report.
> If those all seem in order, you may need to reset IIS. I've noticed these
> report formats (not the data) often cache themselves on the IIS server.
> Hope that helps!
> "Lucrecia" wrote:
> > I made some changes on the design of the report's templates. I do that
> > locally, and then deploy and upload to the server. I haven't been able to see
> > those changes on the working website. I have the following:
> >
> > Windows 2003 SP1
> > IIS 6.0
> > .Net Framework 1.1 SP2
> > SQL 2000 Enterprise Edition
> > SQL Reporting Services
> > SQL SP4
> > Visual Studio 2003
> >
> > Am I missing something? I made the changes on the reports' solution file,
> > built, then deploy. After that, I went to the other solution (the one that
> > has my aspx application) then built.
> >
> > Can somebody help me please? I have been trying a lot of different things
> > but nothing seems to work.
> >
> > Thank you!!!

Change Report Owner

We had a person create over 200 report subscriptions and they are
showing up as the report onwer. No that this person has left and their
domain account has been deleted we have found that the SSRS 2005
report subscriptions are now failing.
How do you change the report subscriptions owner to someone that still
exists within the organisation? Or what else would be causing this
issue?
TIAOn Sep 5, 1:56 am, white...@.gmail.com wrote:
> We had a person create over 200 report subscriptions and they are
> showing up as the report onwer. No that this person has left and their
> domain account has been deleted we have found that the SSRS 2005
> report subscriptions are now failing.
> How do you change the report subscriptions owner to someone that still
> exists within the organisation? Or what else would be causing this
> issue?
> TIA
You are correct in assuming the subs are failing due to deletion of
the report owner's account. The same thing happened to us.
You will need to do one of two things: 1) have a current valid user
recreate all of the affected subs or 2) update the OwnerID value in
the Subscriptions table to a current valid user id.
What we did to eliminate this happening every time someone left was
create a generic "SubscriptionOwner" user account and amended the
stored procs (CreateSubscription And UpdateSubscription) that create
subscriptions so that the creating OwnerID value in the Subscriptions
table is replaced with that of the "SubscriptionOwner".|||On Sep 6, 2:55 am, toolman <t...@.infocision.com> wrote:
> On Sep 5, 1:56 am, white...@.gmail.com wrote:
> > We had a person create over 200 report subscriptions and they are
> > showing up as the report onwer. No that this person has left and their
> > domain account has been deleted we have found that the SSRS 2005
> > report subscriptions are now failing.
> > How do you change the report subscriptions owner to someone that still
> > exists within the organisation? Or what else would be causing this
> > issue?
> > TIA
> You are correct in assuming the subs are failing due to deletion of
> the report owner's account. The same thing happened to us.
> You will need to do one of two things: 1) have a current valid user
> recreate all of the affected subs or 2) update the OwnerID value in
> the Subscriptions table to a current valid user id.
> What we did to eliminate this happening every time someone left was
> create a generic "SubscriptionOwner" user account and amended the
> stored procs (CreateSubscription And UpdateSubscription) that create
> subscriptions so that the creating OwnerID value in the Subscriptions
> table is replaced with that of the "SubscriptionOwner".
Thanks for the advice.
However, I have changed the OwnerID in the Subscriptions table but
when I edit the subscription through report manager it still shows the
old username as "Owner:", but if performing a search through the
databse itself it doesn't show any where. I even tried renaming the
UserName field in the Users table, but the name still shows under
"Owner:" in Report Manager.
Any more help would be appreciated.