Showing posts with label upload. Show all posts
Showing posts with label upload. Show all posts

Monday, March 26, 2012

Report definitions - changes not apparent after upload/deploy.

We have SQL 2000 Reporting Services. There are a couple of reports that have been changed several times in the past, with no problems.

Now when we change these same reports, the new report definitions get successfully uploaded (as evidenced by the time stamp), but the old report definitions still show up.

We have tried the following.

1) Deleting the report from Reporting Services.

2) Recreating the report from scratch, then uploading the new report (w/ same name)

3) Uploading the desired report with a different name, then changing it to the desired name. (We have links and legacy applications that point to these reports). When we do this, the old version reappears.

This appears to be a caching problem. I have verified the caching option in the Properties > Data Execution [tab] is not selected. I have tried bouncing the SQL database, IIS services, and Reporting Services (let me know if there is a prescribed order).

Whatever we try, the old definitions remains persistently there.

Help!

Thanks in advance .

gmctech

Could this be client caching or proxy caching?

Friday, March 23, 2012

Report Common Header

I have 70 reports which all have company logo. If the name of logo is
changed, I have to modify this 70 times and upload to report server 70 times.
Do you have any suggestion that can minimize those tedious work load ?
Can report service allow to include HTML file which can be located in local
drive of report server (e.g. d:\Company Name\Company Logo.html) or the HTML
file is locate in Reporting Manager Folder ?I would assume that the company logo is an image. You can use several types
of external images:
* "Project" images. These are image resources that get published to a report
server and are referenced by relative paths in the reports. See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_1qcl.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
* "Database" images. The images are stored in a database.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_5ktv.asp
* External images on web servers or network shares.
Please check the related information in the RS 2000 SP1 Readme file:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:D8C67C57-0F15-4D4E-BF50-5C6E6123BA11@.microsoft.com...
> I have 70 reports which all have company logo. If the name of logo is
> changed, I have to modify this 70 times and upload to report server 70
times.
> Do you have any suggestion that can minimize those tedious work load ?
> Can report service allow to include HTML file which can be located in
local
> drive of report server (e.g. d:\Company Name\Company Logo.html) or the
HTML
> file is locate in Reporting Manager Folder ?|||I can't enter the image's relative path e.g. /Reports/images/CompanyLogo.gif.
An error 'The URL is not valid' is shown. But if I enter
http://localhost/Reports/images/CompanyLogo.gif, it's ok. Can I just input
the relative path instead of the exact url ? As the name of web server
will be changed, the same problem is still exist that I need to modify 70
times and upload to report server 70 times.
Thanks a lot !!!
"Robert Bruckner [MSFT]" wrote:
> I would assume that the company logo is an image. You can use several types
> of external images:
> * "Project" images. These are image resources that get published to a report
> server and are referenced by relative paths in the reports. See also:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_1qcl.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> * "Database" images. The images are stored in a database.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_5ktv.asp
> * External images on web servers or network shares.
> Please check the related information in the RS 2000 SP1 Readme file:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:D8C67C57-0F15-4D4E-BF50-5C6E6123BA11@.microsoft.com...
> > I have 70 reports which all have company logo. If the name of logo is
> > changed, I have to modify this 70 times and upload to report server 70
> times.
> > Do you have any suggestion that can minimize those tedious work load ?
> > Can report service allow to include HTML file which can be located in
> local
> > drive of report server (e.g. d:\Company Name\Company Logo.html) or the
> HTML
> > file is locate in Reporting Manager Folder ?
>
>|||The correct relative path of the image should be (don't specify "Reports" in
the path):
/images/CompanyLogo.gif
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:28EAA57D-0F1B-4602-AA43-43D0129B5656@.microsoft.com...
> I can't enter the image's relative path e.g.
/Reports/images/CompanyLogo.gif.
> An error 'The URL is not valid' is shown. But if I enter
> http://localhost/Reports/images/CompanyLogo.gif, it's ok. Can I just
input
> the relative path instead of the exact url ? As the name of web server
> will be changed, the same problem is still exist that I need to modify 70
> times and upload to report server 70 times.
> Thanks a lot !!!
> "Robert Bruckner [MSFT]" wrote:
> > I would assume that the company logo is an image. You can use several
types
> > of external images:
> > * "Project" images. These are image resources that get published to a
report
> > server and are referenced by relative paths in the reports. See also:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_1qcl.asp
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> >
> > * "Database" images. The images are stored in a database.
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_5ktv.asp
> >
> > * External images on web servers or network shares.
> > Please check the related information in the RS 2000 SP1 Readme file:
> >
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> > news:D8C67C57-0F15-4D4E-BF50-5C6E6123BA11@.microsoft.com...
> > > I have 70 reports which all have company logo. If the name of logo is
> > > changed, I have to modify this 70 times and upload to report server 70
> > times.
> > > Do you have any suggestion that can minimize those tedious work load
?
> > > Can report service allow to include HTML file which can be located in
> > local
> > > drive of report server (e.g. d:\Company Name\Company Logo.html) or the
> > HTML
> > > file is locate in Reporting Manager Folder ?
> >
> >
> >