How do I drill through to a report from a report that's in a different directory? In the designer I can only drill through to reports that are in that project. I'm sure that there is a simple solution (hopefully!).
View 1 RepliesHello,
I am using RS 2005 to design reports.
There's no problem when I connect to an Analysis Services 2005 cube.
But when I try to connect to an AS 2000 cube (Foodmart)...
I have read in this forum that I can use "Microsoft SQL Server Analysis Services" provider (or OLE DB)...
Can someone help me please!!
Thank you
I am using RS 2K5 to develop financial reports, with plenty of figures that must fit in a page.
I use tables for example. Fonts cannot be set smaller than 8pts.
I have also tried to decrease row height and to disable the "can grow to fit content" option, but of course in this way the text gets cut of in its lower part.
How can I do lines more compact? I need to reduce line spacing and to make the data more dense. Currently it looks very sparse.
Is it a known limitation for RS? Any workaround available? Any online example with dense reports?
Thank you.
Hi all,What is Drill Down Reports in Reporting Servies.How can i design Drill Down Reports.
Give me any example to desing Drill Down Reports.
Regards.
Any way to have the drill through report open in a new window on the web?
View 4 Replies View Related
Hi all
is it possible make drill down reports in crystal
my requirement is like
i have n rows in my report
if am clicking the first column in first row it will list details of that row in between first and second row
Same for all the rows
Quick reply is appreciated
Regards
Rameez
Hi All,
Am new to Reporting Services. I need to create some drill down reports. Am unable to find any guidance or tutorials. Anyone please help me to create drill down reports
Thanks in advance
Regards
Nataraj.C
Hi all,
Am new to SQL Server Reporting services. I need to create some Drill down reports. Am unable to find any guidance or tutorials for that. Please help me to create variety of drill down reports.
Thanks in advance.
Regards
Nataraj.C
I've been able to insert a graph in my reports which automatically allow drill down (into the graph). This has stopped working on new reports and I can't see why, or how to allow drill down (in graphs) again. Anyone help? I'm using Crystal Developer Ver9.2. Thanks
View 1 Replies View RelatedHi,
I always have this exception:
w3wp!library!1!02/28/2007-13:50:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database.
When i try to drill in a report that have images.
The weird is that i only have this error when i view this report in ReportViewer in a .aspx page. When i try to enter in this report directly by using the ReportServer ( http://server/Reports ) i dont have this error.
what is wrong ?
cya
Hi All,
I want to know How to make Drill Through Reports in SSRS ?
Please Suggest.
Ritesh Kumar
Hello,
In the sharepoint site from the main report when i go to my drill down report i see no back button, Is there a way to provide back button in the toolbar. I dont want to use the page back button. or is there any way by which if i click for my drill down report the report will be opened in a new window?
Thanks & Regds,
Hi, all experts here,
Thank you for your kind attention.
I am wondering if we can drill down reports in a different page with different layouts and columns? e.g. I have too many columns desired to see in a report, so I want to direct the users to another page with different layouts and columns, so the first view in the report wont display so many columns in a page. Is it possible to make it in SQL Server 2005 Reporting Services? And if it is possible then how? Hope my question is clear for your help.
Thanks a lot in advance and I am looking forward to hearing from you.
With best regards,
Yours sincerely,
Hi all.
Any body give me one example,how to create drill Through reports in Reporting Services.
Regards.
Report A contains a textbox that should navigate to Report B using the Jump To option. Report A and Report B are located in separated folders on the Reporting Server.
SSRS looks for the rdl file within the same folder when using the Jump To option. Is there away to navigate to a report located in a different folder on the same server?
Thanks
Hello,
I have a drill down report and would like to add interactive sort on two columns:- column 1 & column 2. These two columns should be in descending order. By adding this, when user's click on column 1 they will see the data based on the sorted order.
Does anyone help me on this issue.
Thanks,
BL
Any body pls tell me steps to create Drill Down reports in Sql Server 2005 Reporing Services.
If possible give me one example to create Drill down Reports.
Regards.
Naren
Hi there,
I'm using the reportviewer control to display a drill-through serverreport. Here is the code in my code-behind file:
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
Dim strReportPath As String = "/Public Reports/adfront/dealermodel/myreportname"
Dim paramUniqueID As New ReportParameter()
If Not Page.IsPostBack And Me.ReportViewer1.ServerReport.IsDrillthroughReport = False Then
Session("uniqueid") = Request.QueryString("uniqueid").ToString
'Set the report server URL and report path
Me.ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://localhost/reportserver")
Me.ReportViewer1.ServerReport.ReportPath = strReportPath
Me.ReportViewer1.SizeToReportContent = True
Me.ReportViewer1.AsyncRendering = False
Me.ReportViewer1.ShowBackButton = True
Me.ReportViewer1.ShowFindControls = False
Me.ReportViewer1.ShowPageNavigationControls = False
Me.ReportViewer1.ShowParameterPrompts = False
Me.ReportViewer1.ShowPromptAreaButton = False
Me.ReportViewer1.ShowZoomControl = True
Me.ReportViewer1.ZoomMode = ZoomMode.FullPage
'Set the processing mode for the ReportViewer to Remote
Me.ReportViewer1.ProcessingMode = ProcessingMode.Remote
'Set the report parameters for the report
paramUniqueID.Name = "uniqueid"
paramUniqueID.Values.Add(Session("uniqueid"))
Dim parameters() As ReportParameter = {paramUniqueID}
Me.ReportViewer1.ServerReport.SetParameters(parameters)
End If
Me.ReportViewer1.ServerReport.Refresh()
End Sub
Protected Sub ReportViewer1_Drillthrough(ByVal sender As Object, ByVal e As Microsoft.Reporting.WebForms.DrillthroughEventArgs) Handles ReportViewer1.Drillthrough
While (Me.ReportViewer1.ServerReport.IsDrillthroughReport)
Me.ReportViewer1.PerformBack()
End While
'Me.ReportViewer1.ServerReport.ReportPath = e.ReportPath
'Me.ReportViewer1.ServerReport.GetParameters()
Me.Label1.Text = Me.ReportViewer1.ServerReport.ReportPath
End Sub
When I drill-through the report and hit the (browser) back button and try to drill-trough again I get the following error:
The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)
When I hit back again and try to export the report to eg. PDF, I get this error:
Execution 'mly2yj555oen0o45oowe1e55' cannot be found
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: Execution 'mly2yj555oen0o45oowe1e55' cannot be found
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[Exception: Execution 'mly2yj555oen0o45oowe1e55' cannot be found]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +553
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +941
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension) +97
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +126
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +202
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
It looks like my executionid is lost on the reportserver. Does anybody knows how to fix this, so my users can use the browser back button?
Many thanx!
Ralph
Hi all,
Drill through bar charts work great in the report designer preview, but as soon as I deploy the report, and view the report in a webpage, drill through does not work smoothly.
I have to move the mouse around to be able to find a place on the bar to click through to the next report. Sometimes, I am able to click on the bar to go to next report, but then sometimes I have to click on the label, and other times somewhere in the vicinity of the label.
Any help will be much appreciated.
Thanks,
Kanwal
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 am using Report Builder 3.0 and i have report which has a drill down group. The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.
In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.
Can anyone help me with this?
This is my problem:
I have a cube that I created in AS2005, I have a hierarchy and drillthrough action defined. When I create a pivot table in Excel based on that cube and I try to drill down on the cell in the pivot table I can not drill down to the next level. I get an error message: Cannot show or hide detail for
this selection. My hierarchy is based on Dimension Facility. Facility State is root level, facility zip is next level. When I'm in AS2005 and browse the cube, I'm able to drill down and drill through and see the hierarchy just fine. (Also, I find interesting that when I create a cube in excel, based on a two relational tables, I'm able to drill down. ) I have the Analsysis Services Add-on installed on my machine, so I have the Cube Analysis Menu item. But I can't seem to even drill-through. So, for now all I want to know is why can't I drill-down (i.e. double clicking on a cell and having the data related "explode" in the spread sheet) like it shows in the article written by William Pearson, titled September 12, 2005
Introduction to MSSQL Server Analysis Services: Reporting Options for Analysis Services Cubes: MS Excel 2003 and More. Any help is greatly appreciated!!
Queen
View 8 Replies View Related
How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005.
Hi all,
I really need help with this issue.
I have a setup a reporting server that works perfectly when accessing it from the intranet. Now I need to give access to this report server over the intranet.
I'm stomped...
The network guys did create a secure access to my report server so I can access my server using :
https://<MySecureRS>/reports
The issue I'm facing is that once I authenticated my self using https://<MySecureRS>/reports
It shows the internal ip addres of my server in the browser.... http://<My internal IP Adress>/reports
How can I configure my server to stay on my secure address?
Thanks
Aiwa
Hi,
As per my reading, using RS2005 with backend database as SQL 2000 is
possible.
Can anyone tell me whether RS2005 connect to SQL 2000 database on same same
machine. i.e. in short can RS2005 reside with SQL 2000?
Which edition of RS 2005 support backend as SQL2000?
TIA,
Tanmaya
Has anyone used the MDX Scope Statement in a RS2005 Reporting Services
Report?
I am not sure if the scope / end scope statement will work in a RS report script.
Thanks,
I have a report that needs to show postal addresses. The address is broken down into several fields. The problem I have is some of the address parts are optional. If they are empty, I'm left with nasty gaps in the address. I'd really like next label to reclaim the space of any empty labels.
a quick example
A full address would look like this..
customer name
address line 1
address line 2
town
county
post code
if address line 2 isnt given, I get:
customer name
address line 1
town
county
post code
but I want:
customer name
address line 1
town
county
post code
Can anyone help?
Many thanks,
Paul
Are trend lines supported in RS2005, and if so how do you produce them?
Thanks,
Peter Cwik
Trizetto
I installed RS2005(SP2) with a SQL2000(sp4) db. Both are on seperate Windoes 2003 servers. I configured the reports manager to connect to a different web site on the same server instead of default web site. There were no installation prohlems. The RS server is up and running , all the virtual directories setup etc. When I try to access the reports directory via: http://dev2/Reports or browse the reports virtual directory from IIS, I get a 401 access denied error. The RS log reads:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:ReportingServices2005MSSQL.1Reporting ServicesLogFilesReportServerWebApp__07_10_2007_11_29_21.log</Path>
<SystemName>NWISTCST99</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!7/10/2007-11:29:30:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!5!7/10/2007-11:29:31:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!7/10/2007-11:29:32:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Please advise.
The RSweApplication.config in the ReportManager folder has the fully qualified URL to ReportServer<ReportServerUrl> and I have blanked out the <ReportServerVirtualDirectory>
Also the <UrlRoot> in rsreportserver.config in ReportServer folder points to the fully qualified URL to ReportServer.
What am I missing here ..?
I am not able to deploy report to report server, I have this error:
The permissions granted to user <IUSR_MashineName> are insufficient for performing this operation.
Well, I finally got RS2005 installed on Vista, only problem is, now it won't run. I've installed SP2 (Ctp) and still no joy. It just errors when attempting to access the web service.
Here's the error:
w3wp!library!5!01/08/2007-20:36:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest()
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
Any clues anyone? I'm all out.
Cheers,
Paul
All of the subscription emails that go out has a "From" display name of "POP3", so when the receipients receive the email, they see "POP3" in the "From" field. I would like to change this so ill-informed users don't delete the emails thinking they're junk/virus email.
Of course if the email software being used by the receipients doesn't support displaying a "From" name, then only the actual email will show and, in that case, it will be perfectly fine.
I'm trying to account for the less-than-educated end-users with minimal literacy in computers.
Does anyone know how to change this? Thanks!