Report drilldown still a major issue - HotFix needed!

While testing the latest RC1 SRS software and trying to get report drill down
in a chart working, I found that it was not working as expected. I thought
that this might be a Dundas issue, but has since learned that this is a MS
issue.
I understand that MS is aware of this and I strongly believe that this needs
to be fixed via HotFix rather than waiting until release time or later. We
are working towards a Spring 2006 release of our software and report
drilldown is one of the most important elements of our application.
Has anyone else ran into this issue?
Thanks!
KeithThis sound like you need a fix. I would contact Microsoft Product Support
Services. If it is indeed a fix and not user error, all fees are refunded.
If you specific details on what the bug is, I can look it up and see if it
is fixed if it is something we know about.
bradsy@.microsoft.com
--
| Thread-Topic: Report drilldown still a major issue - HotFix needed!!
| thread-index: AcXERUgoHQxmMZhhRD29mQIbnrU+Aw==| X-WBNR-Posting-Host: 66.89.74.203
| From: "=?Utf-8?B?S2VpdGg=?=" <Keith@.discussions.microsoft.com>
| Subject: Report drilldown still a major issue - HotFix needed!!
| Date: Wed, 28 Sep 2005 08:57:09 -0700
| Lines: 14
| Message-ID: <E55E5CE0-899D-46CA-87F2-11F58CAF6787@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53277
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| While testing the latest RC1 SRS software and trying to get report drill
down
| in a chart working, I found that it was not working as expected. I
thought
| that this might be a Dundas issue, but has since learned that this is a
MS
| issue.
|
| I understand that MS is aware of this and I strongly believe that this
needs
| to be fixed via HotFix rather than waiting until release time or later.
We
| are working towards a Spring 2006 release of our software and report
| drilldown is one of the most important elements of our application.
|
| Has anyone else ran into this issue?
|
| Thanks!
| Keith
|sql

Report Builder button doesn't appear....

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'
AllanI 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'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
further but still have the same problem.....
"Jay" wrote:
> 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've downloaded the MSDN RTM version and installed, but I have the same
problem. I have ensured that the users are in the Reporting services Content
Manager security group (and indeed every other group) but with no joy. Only
members of Windows Domain Admins group can see the button.
I guess I must be missing something ... ?
"Allan" wrote:
> I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> further but still have the same problem.....
> "Jay" wrote:
> > 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|||Make sure, that in site settings --> configure system level role definitions
--> System USer has "Execute report definitions" is checked. This is not
checked by default if you are upgrading to 05. If you are installing it brand
new, then it is checked by default.
"Furzehill Bill" wrote:
> I've downloaded the MSDN RTM version and installed, but I have the same
> problem. I have ensured that the users are in the Reporting services Content
> Manager security group (and indeed every other group) but with no joy. Only
> members of Windows Domain Admins group can see the button.
> I guess I must be missing something ... ?
>
> "Allan" wrote:
> > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > further but still have the same problem.....
> >
> > "Jay" wrote:
> >
> > > 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|||The solution provided by Nagini Indugula does not work (at least for all
cases).
Having the same issue, adding a user to the local admin group of the
SQLRS2K5 server has the Report Builder button appearing. Remove the user
from the local admin group, the button goes away.
Trying all other local groups for the user do not resolve the issue. Looking
also for a way to get this to work.
"Nagini Indugula" wrote:
> Make sure, that in site settings --> configure system level role definitions
> --> System USer has "Execute report definitions" is checked. This is not
> checked by default if you are upgrading to 05. If you are installing it brand
> new, then it is checked by default.
>
> "Furzehill Bill" wrote:
> > I've downloaded the MSDN RTM version and installed, but I have the same
> > problem. I have ensured that the users are in the Reporting services Content
> > Manager security group (and indeed every other group) but with no joy. Only
> > members of Windows Domain Admins group can see the button.
> >
> > I guess I must be missing something ... ?
> >
> >
> > "Allan" wrote:
> >
> > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > further but still have the same problem.....
> > >
> > > "Jay" wrote:
> > >
> > > > 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|||In digging some more, a post by Blackfish was the solution.
---
The solution is:
site settings -> Configure site-wide security -> New Role Assignment ->
add user to either 'System Admin' or 'System User'
Tim
---
"TL" wrote:
> The solution provided by Nagini Indugula does not work (at least for all
> cases).
> Having the same issue, adding a user to the local admin group of the
> SQLRS2K5 server has the Report Builder button appearing. Remove the user
> from the local admin group, the button goes away.
> Trying all other local groups for the user do not resolve the issue. Looking
> also for a way to get this to work.
>
> "Nagini Indugula" wrote:
> > Make sure, that in site settings --> configure system level role definitions
> > --> System USer has "Execute report definitions" is checked. This is not
> > checked by default if you are upgrading to 05. If you are installing it brand
> > new, then it is checked by default.
> >
> >
> >
> > "Furzehill Bill" wrote:
> >
> > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > problem. I have ensured that the users are in the Reporting services Content
> > > Manager security group (and indeed every other group) but with no joy. Only
> > > members of Windows Domain Admins group can see the button.
> > >
> > > I guess I must be missing something ... ?
> > >
> > >
> > > "Allan" wrote:
> > >
> > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > further but still have the same problem.....
> > > >
> > > > "Jay" wrote:
> > > >
> > > > > 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|||Hi - I'm glad you found the answer but I'm confused... why should we have to
do this versus just assigning the user to the report builder role under item
level security?
"TL" wrote:
> In digging some more, a post by Blackfish was the solution.
> ---
> The solution is:
> site settings -> Configure site-wide security -> New Role Assignment ->
> add user to either 'System Admin' or 'System User'
> Tim
> ---
> "TL" wrote:
> > The solution provided by Nagini Indugula does not work (at least for all
> > cases).
> >
> > Having the same issue, adding a user to the local admin group of the
> > SQLRS2K5 server has the Report Builder button appearing. Remove the user
> > from the local admin group, the button goes away.
> >
> > Trying all other local groups for the user do not resolve the issue. Looking
> > also for a way to get this to work.
> >
> >
> >
> > "Nagini Indugula" wrote:
> >
> > > Make sure, that in site settings --> configure system level role definitions
> > > --> System USer has "Execute report definitions" is checked. This is not
> > > checked by default if you are upgrading to 05. If you are installing it brand
> > > new, then it is checked by default.
> > >
> > >
> > >
> > > "Furzehill Bill" wrote:
> > >
> > > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > > problem. I have ensured that the users are in the Reporting services Content
> > > > Manager security group (and indeed every other group) but with no joy. Only
> > > > members of Windows Domain Admins group can see the button.
> > > >
> > > > I guess I must be missing something ... ?
> > > >
> > > >
> > > > "Allan" wrote:
> > > >
> > > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > > further but still have the same problem.....
> > > > >
> > > > > "Jay" wrote:
> > > > >
> > > > > > 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