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?

REport definitions

hi,

I have created a report in RS 2005 but i want to use in RS2003 how i change the report definitions in the current report to make it compatable in RS 2003

Thanks in advance,

Regards,

Somu

You can start by changing the XML namespaces at the top of the definition. Get a sample RS 2000 report to see how. It will take probably a few cycles of trial and error.|||You can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

These changes are usually sufficient to "downgrade" the RDL so it uploads on a RS 2000 report server.

-- Robert

Report Builder Permissions

Hi there,

I created a System Role: Report Builder User (checked "Execute Report Definitions")

Created a folder Home/FolderName/ReportModels

Created a Report Model, deployed it to the above folder.

The are a few users we would like them to run the report model, they belong to a windows group.

I assigned The "Report Builder User" to this Group.

The issue I have that when they run the Report Builder they get a login window (which then doesn't let them to continue).

I managed to overcome this by assiging to this group a "Browser" role at the Home level.

If I remove this assignment and set it in one level underneath the Home folder they can't run the Report Builder.

We don't want them to be able to view the folders at this level, Is there any other option besides setting the Browser role at the Home folder?

Thank you,

Itzhak

I believe users need to have at least Browser permission on all the parent folders of a given folder in addition to the folder itself. So yes, they will need to have permission to the Home folder. However, this will not (by itself) allow them to see subfolders of the Home folder to which they do not have permission. So you should still be able to hide the folders you don't want them to see.

Hope this helps!

|||

That's what I thought.

Yes, it did help.

Thank you,

Itzhak

sql

Report Builder button doesn't appear....

Users must have permission to the Execute Report Definitions task (normally obtained via the System Users role) for the Report Builder button to be displayed.
--Original Message--
From: Jay@.discussions.microsoft.com
Posted At: Friday, October 21, 2005 4:01 PM
Posted To: microsoft.public.sqlserver.reportingsvcs
Conversation: Report Builder button doesn't appear...
Subject: RE: Report Builder button doesn't appear...
I have run into a similar problem on my machine. The Report Builder button
never appears in my report manager home page.
I'm using Windows 2000 workstation with SQL Server 2005 (September)
Jay
"Allan" wrote:
> Hi,
> I have the latest CTP installed. Users do not see the report builder button.
> Only members of the local admin group seem to have it displayed. Can anyone
> steer me in the right direction'
>
> AllanHow do I do this. Please explain step-by-step. This is a third explanation
I have run across. Please see text below that I posted elsewhere:
Report Builder button does not show when an upgrade to Reporting Services
2005 is completed. If a fresh install is done then no problem. I need to do
an upgrade for an existing Reports Server 2000 and want user to have the
Report Builder button. Some docuementation said to set
EnableReportDesignClientDownload to true, but did not say how to do this.
Another document said Enable Report Design Client Button is set to True in
RSWebApplication.config by default. However, this also did not show how to do
this. I need clear and exact step-by-step instructions.
"Bob Meyers MSFT" wrote:
> Users must have permission to the Execute Report Definitions task (normally obtained via the System Users role) for the Report Builder button to be displayed.
>
> --Original Message--
> From: Jay@.discussions.microsoft.com
> Posted At: Friday, October 21, 2005 4:01 PM
> Posted To: microsoft.public.sqlserver.reportingsvcs
> Conversation: Report Builder button doesn't appear...
> Subject: RE: Report Builder button doesn't appear...
>
> I have run into a similar problem on my machine. The Report Builder button
> never appears in my report manager home page.
> I'm using Windows 2000 workstation with SQL Server 2005 (September)
> Jay
> "Allan" wrote:
> > Hi,
> > I have the latest CTP installed. Users do not see the report builder button.
> > Only members of the local admin group seem to have it displayed. Can anyone
> > steer me in the right direction'
> >
> > Allan
>|||I would also appreciate some help on this. The only time I see the
button is when I'm logged onto the machine that's hosting RS.
Users that have all possible roles assigned do not see the button on
the web site.
How can I make the button visible?