Enabling automatic ClickThrough/ Drill Into for Report Builder Reports against a model

Hello - I am having difficulty enabling the automatic click-through functionality for my model. I have two entities - Customer & Incident. Incident is a role/FK/OptionalMany relationship to customer.

I've read through earlier postings on this subject (below) and have verified that the #Incidents attribute in my incident entity has the EnableDrillThrough=true.

My test report is simple - Customer Name (from customer) and #Incidents (from incident). When I run it, the click-through option is not available (the cursor stays as an arrow and doesn't change to a finger).

Are there other properties or settings that I need to be working with? I have SP2 (9.0.3042) installed on our Standard edition of SQL 2005. I know Infinite Click-Through is not in Std edition, but a few levels should be, correct?

Thanks in Advance,

Toni

Other related postings -

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1260819&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=657279&SiteID=1

I just installed my model on a machine with Reporting Services Enterprise edition and the click through is working.

I'll try to get verification from Microsoft on this difference in versions and will post back.

|||The entire feature is available only in the Enterprise edition.

EnableReportDesignClientDownload

Dear all
I would like to turn of the Report Builder Buttom in the Report Manager. It
worked with the following script out of msdn:
Class Sample
Public Shared Sub Main(ByVal prompt As String)
Dim rs As New ReportingService.ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim props(0) As [Property]
Dim setProp As New [Property]
setProp.Name = "EnableReportDesignClientDownload "
setProp.Value = prompt
props(0) = setProp
Try
rs.SetSystemProperties(props)
Catch ex As System.Web.Services.Protocols.SoapException
Console.Write(ex.Detail.InnerXml)
Catch e As Exception
Console.Write(e.Message)
End Try
End Sub 'Main
My problem is now, when I try to enable the Report Builder Buttom, this does
not work. Any idea why?
Thanks in advance for your answer,
Marc
--
Best regards,
MarcHello Marc,
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.
See Home->Site Settings->Configure system-level role definitions->System
User->Execute Report Definitions
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Peter
it worked well thanks!
Best regards,
Marc|||Welcome!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Enable Report Builder for User

I cannot figure out how to display the 'Report Builder' icon in the toolbar for a user.

I've tried setting the different security roles, but the icon doesn't display.

Thanks.

I guess what I should have asked was -- "How do I deploy Report Builder to a user?"

I've found that this URL will execute Report Builder -- http://server name/reportserver/reportbuilder/reportbuilder.application

What is the best way to deploy ReportBuilder to a user?

|||

Hi,

If I am correct, you want the user to build his own ad-hoc reports using the report model. If this is correct, when the user click on the report builder, he will be able to select the report models (already deployed on the production server).

When user selects the report model and the format for the report, the report builder is available to the user as clickonce application. It would require .NET framework to be available on the user's machine as prerequiste.

Hope this helps.

Virendra

|||

Hi Virendra,

I am having the same issue with Report Builder as Pwomack.

Like Pwomack i found that same link to http://<<server>>/reportserver/reportbuilder/reportbuilder.application although i couldn't use it because our users work with Res Powerfuse in a Terminal Server environment (users don't have access to the local C: drive and .Net Framework tries to place Tmp files in Documents & Settings\username\local settings\... which is prohibited in our environment / infrastructure.)

I've been testing and i've tried to adjust user rights and such but without luck. The .Net framework is installed on our servers. Do you have any other suggestions where i could look?

With regards,

Gawelles

Enable Report Builder for User

I cannot figure out how to display the 'Report Builder' icon in the toolbar for a user.

I've tried setting the different security roles, but the icon doesn't display.

Thanks.

I guess what I should have asked was -- "How do I deploy Report Builder to a user?"

I've found that this URL will execute Report Builder -- http://server name/reportserver/reportbuilder/reportbuilder.application

What is the best way to deploy ReportBuilder to a user?

|||

Hi,

If I am correct, you want the user to build his own ad-hoc reports using the report model. If this is correct, when the user click on the report builder, he will be able to select the report models (already deployed on the production server).

When user selects the report model and the format for the report, the report builder is available to the user as clickonce application. It would require .NET framework to be available on the user's machine as prerequiste.

Hope this helps.

Virendra

|||

Hi Virendra,

I am having the same issue with Report Builder as Pwomack.

Like Pwomack i found that same link to http://<<server>>/reportserver/reportbuilder/reportbuilder.application although i couldn't use it because our users work with Res Powerfuse in a Terminal Server environment (users don't have access to the local C: drive and .Net Framework tries to place Tmp files in Documents & Settings\username\local settings\... which is prohibited in our environment / infrastructure.)

I've been testing and i've tried to adjust user rights and such but without luck. The .Net framework is installed on our servers. Do you have any other suggestions where i could look?

With regards,

Gawelles