error when running report in vs

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - calculate change from a previous group row? Hi, All standard newbie apologies apply, but I can't believe this is as hard as it is to figure out. I have a table with a group row that sums a value for a given week. On each next instance of that row, I want to calculate the % change compared to the previous week(groupItemA - previous(groupItemA) / groupItemA). If the previous() function doesn't work with aggregate values, is there any way to perform this action? If so, how? Thanks in advance, Dean Tag: error when running report in vs Tag: 42680
  - 2
    - =?Utf-8?Q?The_bottleneck_of_reporting_serv?= Just find out that for small size table, reporting service works fine. When the size/total record of the table is increasing, the display process becomes slower and slower. I managed to trace it and find out that in my case, 300,000 records consumes more than 2 minutes for the report manage to render it, while loading the data from database only take 10 seconds! Anybody knows how to improve it? Tag: error when running report in vs Tag: 42679
  - 3
    - Perform aggregate against group value Is there a way that I can perform my aggregate function agains the value in group row instead of details row? Because I do not show numeric values in the details but group row. -- SevDer http://www.sevder.com A new .NET Source For .NET Developers Tag: error when running report in vs Tag: 42678
  - 4
    - Combining multiple reports into a single pdf You guys have any idea how to render multiple reports into one pdf file? Subreports won't work because I've different headers/footers. Also some of the reports are in portrait and some are in landscape. Thanks, Tag: error when running report in vs Tag: 42675
  - 5
    - Report subscription execution order in a schedule? When a schedule is triggered are the subscribed reports all executed immediately or sequentially? Tag: error when running report in vs Tag: 42674
  - 6
    - Page spacing issues When I have a group with the details below suppressed, the page spacing stays the same and does not shrink to match the hidden detail. This is very confusing for people viewing the report. For example.... I may have a report that is grouped by State. Lets say I have 2 states on my report... NC and SC. Below the state gouping, I have customer information in the detail section, but the section is hidden. Lets say for NC, there are 5 pages of hidden detail. For some reason, my report is displaying 5 blank pages between NC and SC where there would be detail. any ideas? thanks, Will Tag: error when running report in vs Tag: 42673
  - 7
    - RS 2005 - Paraemeter "Groups" Hi, I am investigating moving one of my client's reports from ASP 3.0 based to RS 2005. Many of their reports have Paremeter "Groups" such that a report can be displayed by entering a daterange, a week number or a month. The stored procs are designed to only take the daterange paremeters and the ASP generates that range if the user entered a week or a month. I am not seeing a clean way to implement this in RS2005, is there? Thank you, Jason Lind Tag: error when running report in vs Tag: 42672
  - 8
    - EXPORT TO PDF - double lines won't export Has anyone seen this before: if you set the borderstyle for any cell to double, when you export to PDF, it appears as a single line. Is there a work-around for this, aside from a adding another row? These are pretty complicated reports, and I don't want the added overhead of managing the visibility of a row I added just to get a double line. This should be simple. Any ideas? Tag: error when running report in vs Tag: 42671
  - 9
    - ReportViewer control and scaling issue When using the reportviewer control on a web page, we would like to set the width and heighth to a percentage of the container that it is placed in. It appears that the defaults are 400px. Of course these can be changed, but you may experience horizontal and/or vertical scroll bars or a window that is too large for the report. What we are trying to achieve is to have the contents of the exposed SRS report scale properly when the size of the browser window is changed. Has anyone else come across or tried to solve this issue ? Tag: error when running report in vs Tag: 42666
  - 10
    - "#Error" displayed in field on deployed report I have an unusual problem. First let me explain the data I'm trying to collect, to see if there is a different/better way (read: a way that works). On my report, the data is coming in from a stored procedure that is setup in a table control on the report; and the table has two subgroups (Breed and Hatchery for reference purposes, the data is pertaining to Turkey flock data FYI) in it to show the totals of each subgroup of the data. The user wants to have a field show the percentage of a hatchery a particular breed represents. For example: Table: Flocks Fields: FlockNumber, FlockBreed, FlockHatchery, FlockSize (number of birds) Data: 01; NIC; SC; 17,920 02; NIC; SC; 7,448 03; HYB; SC; 5,890 04; HYB; SC; 11,825 05; NIC; CF; 5,547 06; NIC; CF; 10,695 07; HYB; CF; 20,790 08; HYB; CF; 5,998 And the subtotals are on FlockBreed, then FlockHatchery like so: SC; NIC; 25,368 SC; HYB; 17,715 SC; 43,083 CF; NIC; 16,242 CF; HYB; 26,788 CF; 43,030 What the user wants is: SC; NIC; 58.88% SC; HYB; 41.12% SC; 100% CF; NIC; 37.75% CF; HYB; 62.25% CF; 100% What I did to solve this problem was to write another Stored Procedure to calculate the percentage and return it. Then I called the procedure from VB.NET code that I wrote and put in the "Code" tab of the "Report Properties" dialog. The code works, because I tested it first in a standalone application, but I'll post it (scroll-down) for good measure. I found that I had to add the "System.data.Dll" to the "References" tab to avoid errors, but once I did the report ran fine. I thought this had worked great. I previewed the report and the values showed up exactly as they were expected to. The values were correct and I thought I was home free. Then I deployed the report, and viewed it from Internet Explorer, and in the fields that should hold the percentage there is "#Error" printed (without quotes). I checked the log file located at: "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer_<dateTime>.log" on my SQL Server box and there is nothing pertaining to errors, only "Info" lines. Some quick searching suggested that there is a security issue to be dealt with, but nothing I tried seemed to help (for reference, I was working with the following link from Microsoft: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_install_25ia.asp) If anyone has any ideas how I can get this to work, or knows what I was doing wrong with the security, I'd greatly appreciate it. Thanks in advance. Here is the code for returning the percentage from the SQL Server Stored Procedure mentioned above: Public Function getBreedPercent(ByVal beginDate As Date, ByVal endDate As Date, ByVal breedCode As String, ByVal Hatchery As String) As Decimal Dim oConn As New System.Data.SqlClient.SqlConnection("Server=XXX;Database=PMTS_v650;User ID=XXX;Password=XXX;Trusted_Connection=False") Dim oCmd As New System.Data.SqlClient.SqlCommand Dim oTmpParam As System.Data.SqlClient.SqlParameter Dim oDR As System.Data.SqlClient.SqlDataReader Dim total As Decimal Try oConn.Open() oCmd.Connection = oConn oCmd.CommandText = "jasp_getBreedPercentofHatchery" oCmd.CommandType = System.Data.CommandType.StoredProcedure oTmpParam = New System.Data.SqlClient.SqlParameter("@beginDate", System.Data.SqlDbType.NChar) oTmpParam.Value = beginDate oTmpParam.Direction = System.Data.ParameterDirection.Input oCmd.Parameters.Add(oTmpParam) oTmpParam = New System.Data.SqlClient.SqlParameter("@endDate", System.Data.SqlDbType.NChar) oTmpParam.Value = endDate oTmpParam.Direction = System.Data.ParameterDirection.Input oCmd.Parameters.Add(oTmpParam) oTmpParam = New System.Data.SqlClient.SqlParameter("@Hatcherycode", System.Data.SqlDbType.NChar) oTmpParam.Value = Hatchery oTmpParam.Direction = System.Data.ParameterDirection.Input oCmd.Parameters.Add(oTmpParam) oTmpParam = New System.Data.SqlClient.SqlParameter("@BreedCode", System.Data.SqlDbType.NChar) oTmpParam.Value = breedCode oTmpParam.Direction = System.Data.ParameterDirection.Input oCmd.Parameters.Add(oTmpParam) oDR = oCmd.ExecuteReader While oDR.Read total = oDR("BreedPercent") End While Catch ex As Exception MsgBox("ERROR: " & vbCrLf & ex.ToString) Finally oConn.Close() oTmpParam = Nothing oDR = Nothing oCmd.Dispose() oConn.Dispose() oCmd = Nothing oConn = Nothing End Try Return total End Function Tag: error when running report in vs Tag: 42664
  - 11
    - Error 2826 when installing SQL Server Reporting Services When installing reporting services: The install walks through the Setup of the Support files, the System Check Results, and then Installing Reporting Services. However, the status bar never moves and eventually a window comes up that says the install failed, providing the option to send a report to MS but no specific error message. The following error is identified in the RMSI1.log: DEBUG: Error 2826: Control ActionText on dialog ProgressDlg extends beyond the boundaries of the dialog to the right by 37 pixels The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2826. The arguments are: ProgressDlg, ActionText, to the right Any ideas on how to resolve this issue???? Tag: error when running report in vs Tag: 42663
  - 12
    - Sum of all groups, which scope? Hi, I have a situation as follows TABLE Header1--------------------- Header2--------------------- GROUP1 MoneyValue1 MoneyValue2 OtherValues Details someotherValue1 someOtherValue2 GROUP2 AnotherValue Footer The output is as follows TABLE NAME No Heading11 Heading12 Heading13.... Heading21 Heading22 1 $1500.00 $23.67 otherValueComesHere someOtherValue11 someOtherValue12 someOtherValue21 someOtherValue22 group2Value 2 $1000.00 $73.67 otherValueComesHere someOtherValue11 someOtherValue12 group2Value 3 $2500.00 $23.00 otherValueComesHere someOtherValue11 someOtherValue12 someOtherValue21 someOtherValue22 someOtherValue31 someOtherValue32 group2Value ------------------------------------------------------ Now in the footer I see the following $11,500 $190.01 However I would like to get $5000 $120.34 And in the footer I cannot use the group scope! How is it possible? In addition to this, the row numbers with or without putting table as scope do not follow proper order. They start with 1, 2, 3 then 4,6,7,8,11 This is driving me crazy, any help is welcomed. Thanks in advance SevDer http://www.sevder.com A new .NET Source For .NET Developers Tag: error when running report in vs Tag: 42661
  - 13
    - Enable parameter selection I have two reports. On Report1, I have a hyperlink action that brings up Report2, passing the required parameters it needs. But when Report2 is shown, I don't have the ability to change the parameters, E.g. in Report2, I have a parameter in a list with a Show\Hide options. When getting redirected from Report1, the default is set to hide. When I'm in Report 2, I then want to change it to Show, but the parameter "section" is not on the report header. Looking at the link, I can see the following ...%3d0%26rc%253aParameters%3dFalse%26rc%253aReplacementRoot%3dhttp...When I change the False to True, I can then see the parameter area, but I'm not sure how to enable it in the report. Can't seem to find the property I need to change. Tag: error when running report in vs Tag: 42660
  - 14
    - Optimizing Reports I've got a report thats somewhat time consuming that runs on my reporting server, and what I've found is that if I select anything more than a few months in my daterange parameters, its like 5 minutes to run. What I'd like to know... Can I snapshot a years worth of default data, and have the report run off the snapshot, but allow you to specify date range within the two dates? Thanks in advance Weston Tag: error when running report in vs Tag: 42655
  - 15
    - My browser times out after 30 seconds; others don't I have several reports on a Reporting Services server. Most reports take less than 30 seconds to download to my browser - I can see them fine. One particular report takes a minute to download - others can see it, but my browser times out after 30 seconds. I get the message: "The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings." I set the report query timeout to 300 seconds, and the Report Execution Timeout on Reporting Manager to "Do not timeout report execution" Anyone have any ideas why the timeout on my browser occurs? Bob Kolar Tag: error when running report in vs Tag: 42653
  - 16
    - Programmatically Find a row Is there any way to programmatically find a particular row in a report? I have a report that displays multiple rows from a table. I'd like to load it positioned on a particular ID, then allow the user to page back and forth through the results via the default toolbar. (the report is being presented as HTML on an Intranet site). If this isn't a built-in feature, any suggestions on how to hook the paging control's Next and Previous events? Thanks, Chris PS - I'm using 2005, latest CTP version Tag: error when running report in vs Tag: 42652
  - 17
    - Formatting a string from the code I have a textbox that displays the amout of free disk space in megabytes. I'm working on converting it to gigabytes and if it's less that one gig, I want to display the string "Critical" bold and in red. Can this be done? Thanks. Tag: error when running report in vs Tag: 42650
  - 18
    - font color inside bar graph Is there a way to change the point lable color of the font if it's inside of the chart beside a bar? I have a chart that shows the percentage of disk space free. Once the chart gets less that 25% it runs out of room to put the point lable percentage beside the bar so it puts it on the bar. The bar is blue and the font is black, so it's hard to see the font inside the bar. Thanks. Tag: error when running report in vs Tag: 42649
  - 19
    - chart control I would like to set some of the properties in the chart control at run time from the database. Is there a way to set the properties at execution time? Tag: error when running report in vs Tag: 42647
  - 20
    - Installation - Only help file installs, No virtual directories or Hi, I am trying to install Reporting Services on Windows 2003 server (with no service pack). Initially it says Visual Studio is not present which is fine, i press next, then it goes into installation and there are no prompts for rs components, sql database creation etc. once installation is finished, only thing i can see is the reporting services help file in the menu. there are no virtual directories. Please help. thanks dhariwal Tag: error when running report in vs Tag: 42643
  - 21
    - Move Reporting Services Web Installation to another Web Server Tag: error when running report in vs Tag: 42641
  - 22
    - Setting Parameters In the Parameters section of Report Manager you can specify a default value for a parameter and then uncheck the prompt user box so the report always runs with that parameter. Can this functionality be set in the Report Designer or does it require manual intervention every time? Hope someone can help. Tag: error when running report in vs Tag: 42639
  - 23
    - RSExecRole is missing My production sqlserver stopped working for subscription in reporting services. WHen I investigated then i found that RSExecRole is missing. The only change done on that server was installing BIZTALK server. Can somebody help me out to setup RSExecRole role again. Tag: error when running report in vs Tag: 42637
  - 24
    - custom assemblies Hi. I'm trying to get my custom assembly to work with the report viewer control (web) in local processing mode. Is that possible at all? I've added the custom assembly to the web app bin folder. I'm using Visual Studio 2005 Release Candidate. I've included the error message: a.. An error occurred during local report processing. a.. The definition of the report 'Main Report' is invalid. a.. Error while loading code module: 'TravelCRMBusiness, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'. Details: Could not load file or assembly 'TravelCRMBusiness, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. b.. c.. d.. e.. Tag: error when running report in vs Tag: 42635
  - 25
    - Display measure details from multiple Measure Groups Current Environment (SQL 2000): Admin Access User Access ----------------------|---------------- Physical Cube #1 | Virtual Physical Cube #2 | Cube #1 Users only have access to Virtual Cube #1 New Test Environment (SQL 2005 Sept CTP): Admin Access User Access ----------------------------------------------------------- Cube #1 | Cube #3 â?? Includes Measure Cube #2 | Groups from cube #1 cube #2 Users have access to Cube #3. Cube #3 has a large number of calculated members and two measure groups (from cube #1 & #2). Both measure groups in Cube #3 intersect with the same dimension (Time). Is there a way in SSRS to display detailed data (not summary data) from both measure groups in a single reporting services table? Tag: error when running report in vs Tag: 42634
- Next
  - 1
    - Unable to see Calculated Members Current Environment: Admin Access User Access ----------------------|---------------- Physical Cube #1 | Virtual Physical Cube #2 | Cube #1 The virtual cube has about 700+ hundred calculated members. Users only have access to Virtual Cube #1 New Test Environment: Admin Access User Access ----------------------------------------------------------- Cube #1 | Cube #3 â?? Includes Measure Cube #2 | Groups from cube #1 cube #2 Users have access to Cube #3. Cube #3 has a large number of calculated members and two measure groups (from cube #1 & #2). When I create a SSRS report accessing data from Cube #3, I only see a portion of my calculated members listed under Measures on the Data tab. The last item listed under measures says â??More measures exist than can be shownâ??. Is there a SSRS setting to correct this? The only way to access the measures we need is to drag â??Measuresâ?? to the grid and remove the 600+ measures we donâ??t want included in the report. Tag: error when running report in vs Tag: 42633
  - 2
    - Multi Column Sub Report I've got a multi column report that runs fine, if called alone. The same report, inserted as sub report on an other report, only shows up one column, but two or more pages. Any ideas, how to get multi columns in the sub report? Tag: error when running report in vs Tag: 42632
  - 3
    - Support for Mac / other browsers in 2005 version? We are currently considering basing a new project for a large client on SQL Server 2005 and Reporting Services. But a large number of the users have Mac's. Will they be able to view and create reports? I haven't been able to find any info about what is supported on Mac and in other browsers than IE. A quick test with the September CTP showed some problems with Mac, but perhaps this will improve with the RTM version? If anybody has any information please let me know, as we very soon has to decide whether to go with Reporting Services or we have to use other solutions (i.e. web site with Crystal Reports). Kind regards Thomas N. S=F8rensen Development Manager Mondo Tag: error when running report in vs Tag: 42630
  - 4
    - RS 2005 with other browsers? Hi all Can anyone report on how well the early releases of RS 2005 works for browers other than Internet Explorer, especially FireFox? This was the main thing that prevented us using RS behind our customer portal website. I'm not so concerned about the toolbar etc but more the html for relatively simple tabular html reports. Thanks Ross Tag: error when running report in vs Tag: 42628
  - 5
    - Subscription fail notifiction Is there a way within the RS to notify a subscription fail like the sql job notifiction? Tag: error when running report in vs Tag: 42626
  - 6
    - Q: SP2 Hello, Is RS service packs cumulative, meaning can I just directly install SP2 without SP1? Thanks, Tag: error when running report in vs Tag: 42624
  - 7
    - Report subscription end date error. When I create a report subscription, check the 'Stop this schedule on:' check box, select the calander control and select the next month I receive the following error... This schedule requires an end date. Please specify the date at which this schedule expires, or clear the end date check box from the subscription. Can this error be prevented with a work around; it seems to be a bug in reporting services. Tag: error when running report in vs Tag: 42622
  - 8
    - Referencing a parameter value in another filter condition Hi, I'm using Business Intelligence Studio and have come across a challenge that I haven't managed to surmount yet. I need to build a query where the user enters a 'date from' parameter which constrains BOTH the invoice dates and the date of registration of the customer to whom the invoice relates. ie I want to retrieve invoices which are raised since 'date from' by customers who were not registered before 'date from'. I can easily create a parameter that constrains the invoice date but I cannot get a filter expression for the customer registration date to reference the value of the 'date from' parameter. The closest I've come is by making the customer registration constraint a second parameter, which means the user has to enter the same date twice. I'd be grateful for any help on offer. Thanks, Paul Tag: error when running report in vs Tag: 42620
  - 9
    - Drill Down - VS ok - Report Server not ok I have RS reports which when run from within Visual Studio, work perfectly. When deployed to the Report Server, drill down does not work. All other aspects of the reports work correctly, but not drill down. Clicking the + shows what looks like activity but the drill down section is not expanded. Would appreciate any suggestions or things to check/try. Thanks. Tag: error when running report in vs Tag: 42618
  - 10
    - Shell Execute from Report HI , Is it possible to click on a report at run-time and shell execute another program? Tag: error when running report in vs Tag: 42614
  - 11
    - Should I use Reporting Services? Hi there, I have been asked to rewrite some Access forms which generate reports into 'ASP.NET' technology. There is a current ASP.NET system in use with a SQL Server 2000 database. The Access forms connect to the SQL database along with its local tables, so it would be best to remove the Access form and replicate its functionality in the ASP.NET system. I originally was thinking to do everything through Reporting Services including the retrieval of the data from the SQL DB. However I am required to replicate a few reports which draw from the same 'datasource' (certain reports use certain portions of the datasource). Though from what I have read, data is always retrieved dynamically for each report? There is no caching of a datasource similar to a report? There are also a few requirements too which I don't think Reporting Services satisfies. That is, when I retrieve the data from the datasource, it would require calling code in the current ASP.NET system to filter the relevant data returned from the datasource based on user input (parameters). That code is used in another module in the ASP.NET system but doesn't use Reporting Services. Also, it is required to insert data to be displayed in a report ie I would retrieve the relevant information from the datasource based on user input (parameters) and then append some more data. So the data from the datasource and the 'new' data would be displayed in the report. I am now thinking to produce an interface/module in the ASP.NET system for the user to retrieve the relevant data and place it within a table/s in the SQL Server DB. And then use Reporting Services to generate the reports without the need for any user input besides selecting which type of report to generate. The data for the reports would come from the table/s filled in the interface/module. What do you guys think? I hope it makes sense! Thanks! Peter Tag: error when running report in vs Tag: 42613
  - 12
    - ASSERT: Assertion failed! Dear ALL, I have this problem during view report in Report Manager (I m using CTP Sept Cut for my SQL 2005 now). And, i can't find out what is this error about. w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call stack Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.GetTableCellProperties(Int32 cellIndex) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.IsParentVisible() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.AddPageTextbox(ProcessingContext processingContext, TextBox textbox, TextBoxInstance textboxInstance, TextBoxInstanceInfo textboxInstanceInfo, Object value) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateTextBoxInstance(TextBox textBox, ProcessingContext processingContext, Int32 index, IScope containingScope) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem reportItem, Boolean setupEnvironment, Int32 index) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance collectionInstance, ReportItemCollection reportItemsDef) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstance() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDetailObj.CreateInstances(ReportItemInstance riInstance, IList instanceList, RenderingPagesRangesList pagesList) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstances(ReportItemInstance riInstance, IList instanceList, RenderingPagesRangesList pagesList) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance riInstance, IList instanceList, RenderingPagesRangesList pagesList) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance riInstance, IList instanceList, RenderingPagesRangesList pagesList) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance riInstance, IList instanceList, RenderingPagesRangesList pagesList) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem reportItem, Boolean setupEnvironment, Int32 index) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance collectionInstance, ReportItemCollection reportItemsDef) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance collectionInstance, Boolean ignorePageBreaks, Boolean ignoreInstances) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateRowInstances(ProcessingContext processingContext, RuntimeRICollectionList rowRICols, TableRowInstance[] rowInstances, Boolean repeatOnNewPages, Boolean enterGrouping) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances() Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance riInstance, IList instanceList, RenderingPagesRangesList pagesList) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance riInstance, IList instanceList, RenderingPagesRangesList pagesList) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem reportItem, Boolean setupEnvironment, Int32 index) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance collectionInstance, ReportItemCollection reportItemsDef) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.CreateInstances(ParameterInfoCollection parameters, Boolean noRows) Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran) Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context) Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, Boolean snapshotProcessing, Boolean processWithCachedData, GetReportChunk getChunkCallback, ErrorContext errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback, ProcessingContext& context) Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached) Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc) Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile) Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context) System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpApplication.ResumeSteps(Exception error) System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) w3wp!library!1!10/26/2005-12:01:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. Please help Nicky Tag: error when running report in vs Tag: 42608
  - 13
    - RS 2000 installation I'm trying to install our MSDN copy of RS 2000 Report Server & Report Mgr on our development server (SQL2K sp3a on Win2K sp4 w/IIS). This installation went fine and I can see all the components, but now I'd like to install the "client components & samples" on my laptop (WinXP sp2 w/ VS.Net 2003). The installation routine is asking for a key after a dialog box tells me I do not have SQL or IIS installed on the laptop - what key do I use? I don't have a RS 2000 key that was on "the little yellow sticker" for RS 2000 & I don't want SQL2K or IIS installed on my laptop. I just want the Client Components on the laptop and the Server Components on the server. BTW - for this to work, do the server components have to reside on the same machine meaning SQL2K & IIS must be installed on the same server? Right now I'm using the Standard Edition of RS 2000 and all of our SQL Servers (Dev & Prod) are the standard edition SQL. Thanks Tag: error when running report in vs Tag: 42604
  - 14
    - An internal error occurred on the report server Dear all, My report is working in CTP Jun, but, after I have install the CTP Sept, some of my report have this error: w3wp!library!1!10/26/2005-09:41:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. Has anyone have see this problem before? thanks Regards NICKY Tag: error when running report in vs Tag: 42603
  - 15
    - Column Variance in Matrix Is it possible to create a Matrix report that contains a colum that calculates the variance between two other columns in the Matrix? For Example: 2004Sales | 2005Sales | Variance (2005Sales - 2004 Sales) Thanks! Chris Tag: error when running report in vs Tag: 42602
  - 16
    - Column Order in Matrix Using SRS 2000. When creating a matrix report, can you order the columns? By default, they are in alpha order. My columns are the months of the year. Using Order By in the query doesn't work. I want January, February..., not April, August... Tag: error when running report in vs Tag: 42599
  - 17
    - re: Report Builder Unless I misunderstand what you're doing, I can't repro this on RC2. I uploaded a model with descriptions on both an entity and an attribute, and both correctly show up in the tooltip over the corresponding item in the Report Builder explorer. Let me know if I'm missing something. --Bob This posting is provided "AS IS" with no warranties, and confers no rights. -----Original Message----- From: RonVanZanten@discussions.microsoft.com Posted At: Tuesday, October 25, 2005 4:10 PM Posted To: microsoft.public.sqlserver.reportingsvcs Conversation: Report Builder Subject: re: Report Builder Mr. Meyers, thanks for the reply, I do have one question as a follow up. Do I have to do something to turn it on? I have descriptions typed in, but when I "hover" over the column name in report builder, I only get the column name again in the little text box that comes open. I am running RC2. Thanks again. Ron "Bob Meyers [MSFT]" wrote: > Report Builder displays the description text as a tooltip in the Explorer pane. > > -----Original Message----- > From: RonVanZanten@discussions.microsoft.com > Posted At: Tuesday, October 25, 2005 5:42 AM > Posted To: microsoft.public.sqlserver.reportingsvcs > Conversation: Report Builder > Subject: Report Builder > > > I would like to have metadata about each field in the model when we use > report builder. I tried to use the description field that is in the > properties of each field but that discription does not show up on report > builder. Is this possible to do? Am I just doing it incorrectly? > Tag: error when running report in vs Tag: 42598
  - 18
    - Extending RDL & rendering How can I add new elements to an RDL report definition and then render those elements? For example, I'd like to add a new type of report (i.e. not a table, matrix, list, or chart), and write the code to generate the rendering of that particular type of element. A further complication: the implementation of this new element would also need to do the database queries, since it does not fit into the Reporting Services model (i.e. getting a flattened dataset back) Is this possible within Reporting Services? Tag: error when running report in vs Tag: 42594
  - 19
    - parameter default lost after deployment I have a report that takes one parameter with default value of "%". When I preview it in the report writer, it works fine rendering reports with the "%". When I run it from the Report Manager after deployment, the the default value is blank and it only renders after I type in "%" and click the "View Report" button. I checked the Properties/Parameter page from the Report Manager and found the "Has Default" is unchecked and "Default Value" is blank. Here is my question: Why the default value of % in the VS designer doesn't get updated in the Report Manager after deployment? And how to get the Report Manager take the default value? THis brings up another observation: The Report Manager has another layer of control setting the default value of a parameter regardless of what the designer has for the default value. This seems to add the flexibility after the deployment. Thank you. Tag: error when running report in vs Tag: 42592
  - 20
    - how to turn off required parameter in reports Trying to learn reporting services and in particular how to cascade parameters. Using AdventureWorks200 db made up a report which works fine except when there are no db entries for the last cascaded parameter. Its doing category->subcategory->product->vendor there are vendors in the db for some, but not all products. The report works fine when there's a vendor but produces nothing when there is no vendor to choose. I checked the allow blanks in the report parameters for the vendor but still no go. so what do I need to do to allow a report to run when ther is no value for the vendor? Thansk for your help. p.s. here's the main report sql: ------------------------ SELECT Product.Name AS Expr1, ProductInventory.Quantity, ProductCategory.Name AS Expr3, ProductSubCategory.Name, Product.ListPrice, Product.ProductLine, Vendor.Name AS Expr2, ProductModel.Name AS Expr4 FROM Product INNER JOIN ProductSubCategory ON Product.ProductSubCategoryID = ProductSubCategory.ProductSubCategoryID INNER JOIN ProductCategory ON ProductSubCategory.ProductCategoryID = ProductCategory.ProductCategoryID INNER JOIN ProductVendor ON Product.ProductID = ProductVendor.ProductID INNER JOIN Vendor ON ProductVendor.VendorID = Vendor.VendorID INNER JOIN ProductInventory ON Product.ProductID = ProductInventory.ProductID INNER JOIN ProductModel ON Product.ProductModelID = ProductModel.ProductModelID WHERE (Product.ProductID = @ProdID) AND (ProductSubCategory.ProductCategoryID = @Cat) AND (ProductVendor.VendorID = @VendID) AND (Product.ProductSubCategoryID = @SubCat) ------------------- thanks. Tag: error when running report in vs Tag: 42588
  - 21
    - Custom code compile error Hi I am trying to use a Function to return the number of whole weeks between to dates. My code in the Report Properties, Code tab is the following. public shared Function WeekAgo(dt As datetime) As Integer Dim firstdayofweek, firstdayofcurrentWeek as datetime firstdayofweek = DateAdd("d",- datepart("w",dt,FirstDayOfWeek.Monday,FirstWeekOfYear.FirstFourDays)+1, dt) firstdayofcurrentWeek = DateAdd("d",- datepart("w", Now(),FirstDayOfWeek.Monday,FirstWeekOfYear.FirstFourDays)+1,Now()) return DateDiff("w", firstdayofweek, firstdayofcurrentWeek, FirstDayOfWeek.Monday,FirstWeekOfYear.FirstFourDays) End Function When I run the report I get the following error There is an error on line 2 of custom code: [BC30456] 'Monday' is not a member of 'Date'. Somehow the FirstDayOfWeek.Monday is not known. When I remove the 2 enum (FirstDayOfWeek.Monday,FirstWeekOfYear.FirstFourDays) it works. When I add a new field,instead of using a function, and use the same code (with Field! values) it works, but I would like to have the code isolated in a Function. What am I doing wrong? Thanks in advance. -Henrik. Tag: error when running report in vs Tag: 42587
  - 22
    - Conditional number formatting How can I use conditional number formatting if one of the formats contain a comma? The iif statement conditions are separated by commas. If one of the conditionals should have the number format: #,##0,;(#,##0,);0 While the other condition should format to percentage: #.0%;(#.0%);0.0% how would I write the iif statement? Or is there another way to format this? Tag: error when running report in vs Tag: 42586
  - 23
    - re: Report Builder -- Can your data source be an Oracle database Report models only support SQL Server in this release. Oracle support is high on the list for a future release. Meanwhile you might consider experimenting with a shadow copy moved to SQL Server using SQL Integration Services. --Bob This posting is provided "AS IS" with no warranties, and confers no rights. -----Original Message----- From: LaurieT@discussions.microsoft.com Posted At: Tuesday, October 25, 2005 11:50 AM Posted To: microsoft.public.sqlserver.reportingsvcs Conversation: Report Builder -- Can your data source be an Oracle database Subject: Report Builder -- Can your data source be an Oracle database Hi again -- I am just trying to set up my first Report Model. We use Oracle to store all of our data that we want to report on (we use Reporting Services). Can I build a report model for Report Builder using an Oracle database as the data source? When I try to create the datasource, it looks like it can only accept a SQL Server database. Thank you, -- LaurieT Tag: error when running report in vs Tag: 42580
  - 24
    - Deploying too many reports causes error in report manager sql reporting services (sp2) windows 2003 server Sql 200 sp4 all on one server (iis & sql server) I have about 30 reports which I deploy from my local environment to our reporting server. If I deploy about 10 of the reports everything is fine, all reports deployed work. However, the more reports I deploy I notice the slower the report manager screen takes to load. After I deploy about 15 of my reports I will eventually get an error on report manager screen: There is an error in XML document (1, 4078) I have tried to deploy differnent reports to see if it is a specific report that may be causing this, but this does not seem to be the case. Any help with this would be greatly appreciated, as I am out of ideas and resources to figure this out. Regards, Troy Tag: error when running report in vs Tag: 42578
  - 25
    - When does a custom assembly run ? Does anyone know when in the lifecycle of the execution of a report, a custom assembly get executed? I understand that datasources are loaded in the order they appear in the RDL file. is a custom assembly executed when it is also found in an RDL file? We are trying to get a custom assembly to be executed when a report has been successfully executed in order to update a database of our own. It would be nice if MS supported the calling of custom assemblies at different points in the lifecycle of a report. Has anyone figured out a way to do this? ===================== Thanks! Keith p.s. Get off the couch and exercise! Tag: error when running report in vs Tag: 42576

An error has occurred during report processing.
Index was outside the bounds of the array.

Any one ever get this error while running a report in the visual studio? I
can deploy the report and it will run fine.

Thanks,
Jessica

Top