'800a001c' error

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
    - Display Multi Value parameter in the report as a field Hi, I would like to show the Multi value parameter values in my report in the title. How can i display all value with comma separated. like If the user selects 4 values of out of 100 , I have to show the report title like "Event Data:comp1, comp2.." Regards, Sriman. Tag: '800a001c' error Tag: 69466
  - 2
    - Addtion / Sum of Parameter Array Values - SSRS Hi All, I want to Sum instead of Join Parameter arrays selected values and use it within the report to display data based on total sum of all the values selected. Join concatanates them with comma delimited values but i want sum of all those values. Example as below Value DisplayText 1 - Current Month 2 - Previoius Year 4 - Half Year 8 - Year to date so if current month and half year are selected then i want to read 1 + 4 = 5 and not 1,4 as currently i get by join function. Code = SUM(Parameters!dropdownbox.value) Result = #Error Code = Join(Parameters!dropdownbox.value,",") Result = "1,4" Code = SUM(Join(Parameters!dropdownbox.value,",")) Result = #Error Code = Parameters!dropdownbox.count Result = 4 (it gives me length of array) Code = ? Result = 5 (This is the result is want...but can make it work) Any help greatly appreciated Regards Nirav Lulla Yotta Consulting Tag: '800a001c' error Tag: 69465
  - 3
    - Rephrase my Issue with Pivot Table I have two tables (definitions follow) one called Product, the other called Traveler_Step. The PK-FK link is the Traveler_Step_#. Each product can only be at one step at a time. If the product is done processing the Traveler_Step_# is 0. Not all steps have a traveler at them. What I need is a query that will return all the steps from the Traveler_Step table that have a value of -1 in the WIPStep field. The query needs to order the steps by WIP_Status_Order. Also, there are many different Traveler_Step_# numbers for different travelers that have the same WIPStep for them. Running the following query against the two tables: SELECT Product.Ingot_Number, Product.Traveler_Number, MIN(Traveler_Step.Step) AS Step, Traveler_Step.WIPStep, Traveler_Step.WIP_Status_Order, Traveler_Step.Step_Description, COUNT(Product.Product_#) AS PieceCount FROM Product RIGHT OUTER JOIN Traveler_Step ON Product.Traveler_Step_# = Traveler_Step.Traveler_Step_# GROUP BY Product.Ingot_Number, Product.Traveler_Number, Traveler_Step.WIPStep, Traveler_Step.WIP_Status_Order, Traveler_Step.Step_Description HAVING Traveler_Step.WIPStep < 0 ORDER BY Product.Traveler_Number, Traveler_Step.WIP_Status_Order I get the following results: NULL NULL 10 -1 1 Weigh/Record 0 NULL NULL 23 -1 3 Hard Pickle 0 NULL NULL 55 -1 4 Hot Roll Intermediate 0 NULL NULL 15 -1 5 UT Test 0 NULL NULL 20 -1 6 Beta Quench 0 NULL NULL 25 -1 7 Grit Blast 0 NULL NULL 30 -1 8 Pickle 0 NULL NULL 40 -1 9 Air Anneal 0 NULL NULL 45 -1 10 Grit Blast 0 NULL NULL 50 -1 11 Pickle 0 NULL NULL 60 -1 12 Cold Roll Intermediate 0 NULL NULL 80 -1 13 Vacuum Anneal Hang 0 NULL NULL 90 -1 14 Cold Roll Final 0 NULL NULL 115 -1 15 Vacuum Anneal F/P 0 NULL NULL 130 -1 16 Plane Width 0 NULL NULL 140 -1 17 Machine Shape 0 NULL NULL 150 -1 18 Machine Grooves 0 NULL NULL 165 -1 19 Shear Final Length 0 U06436L 53086A 15 -1 5 UT Test 5 U06436L 53086B 15 -1 5 UT Test 4 U06450L 53223J 140 -1 17 Machine Shape 2 U06450L 53223L 140 -1 17 Machine Shape 16 U06460L 53236A 140 -1 17 Machine Shape 5 U06460L 53237K 40 -1 9 Air Anneal 4 U06460L 53237M 40 -1 9 Air Anneal 4 U06460L 53237N 40 -1 9 Air Anneal 3 U06494L 53248G 20 -1 2 Grit Blast 1 * U06494L 53307A 20 -1 6 Beta Quench 4 U06494L 53307B 20 -1 6 Beta Quench 3 I noticed that step 2 does not appear in the first fields with null values. But one operation is at step 2 (marked with a star (*)). I need to get all the steps to appear on the left of the matrix, then list all the items in the corresponding row of the matrix depending on the Traveler_Step.WIP_Status_Order field. I can get the steps to appear but as you can see in the query results the right join is not returning all the traveler_steps with null values. So I would like to see Traveler 12345 Traveler 67899 Traveler 23343 Traveler 223344 Step 1 Step 2 x Step 3 Step 4 Step 5 x x Step 6 x Step 7 .... Step 19 Where the traveler numbers are the columns and the X corresponds to the step in the rows. Any help? john CREATE TABLE [dbo].[Product]( [Product_#] [int] IDENTITY(1,1) NOT NULL, [Traveler_#] [int] NOT NULL, [Type_#] [int] NOT NULL, [Part_Number] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Date_Shipped] [datetime] NULL, [Operator_#] [int] NOT NULL, [Create_Date] [datetime] NOT NULL, [Shop_Order_#] [int] NOT NULL, [Date_Closed] [datetime] NULL, [Ingot_Number] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Status_#] [int] NULL, [Anneal_Number] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MRT_Number] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Double_Single_Length] [int] NULL, [Carton_#] [int] NULL, [Weight] [int] NULL, [Sister_Piece_#] [int] NULL, [Slab_Traveler_#] [int] NULL, [Chemistry_#] [int] NULL, [Traveler_Number] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Plate_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FinalID] [bit] NULL CONSTRAINT [DF_Product_FinalID] DEFAULT (0), [Traveler_Step_#] [int] NULL, [Marked] [int] NULL CONSTRAINT [DF_Product_Marked] DEFAULT (0), CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED ( [Product_#] ASC ) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[Traveler_Step]( [Traveler_Step_#] [int] IDENTITY(1,1) NOT NULL, [Traveler_#] [int] NOT NULL, [Step] [int] NULL, [Step_Description] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Station_#] [int] NOT NULL, [Sub_Station_#] [int] NULL CONSTRAINT [DF_Traveler_Step_Sub_Station_#] DEFAULT (0), [Kanban_Point] [bit] NULL, [Dependant_Traveler_Step_#] [int] NULL, [Work_Standard_#] [int] NULL, [Kanban_Notify_Station_#] [int] NULL, [WIPStep] [int] NULL, [Enabled] [bit] NULL, [WIP_Status_Order] [int] NULL, CONSTRAINT [PK_Traveler_Step] PRIMARY KEY CLUSTERED ( [Traveler_Step_#] ASC ) ON [PRIMARY] ) ON [PRIMARY] Tag: '800a001c' error Tag: 69464
  - 4
    - Variance on Matrix Report I was looking for some help with a matrix style report I am trying to develop. Example, months accross the top, columns would be product grouping, then year. The detail would be a summation of invoice value. I can achieve this no problem. The issue is when I want to get a variance between the two years, i.e. Jan 2006 vs 2007 as row, underneath each month. Any help would be greatly appreciated. Tag: '800a001c' error Tag: 69459
  - 5
    - URL to export to Excel Does anyone know the URL I can use to export the report directly to excel instead of going through the report viewer? This is what I am using: http://<servername>%2fReportServer?%2f<FolderName>2f<ReportName>&rs%3aCommand=Render&rs%3aFormat=Excel However, it always brings up the report viewer first instead of exporting to excel. Can anyone see what I am doing wrong? Thanks in advance. Tag: '800a001c' error Tag: 69458
  - 6
    - winfax get the data from database I have one project. create 2 tables(customer information and customer fax), if customer information table is update, customer fax table is update too. I complete this. now I must export the customer fax table to winfax, I mean the winfax will get the data from fax table and fax letter to customer at midnight autometiclly. I appreciate someone gives me some information. Thanks!!!! Tag: '800a001c' error Tag: 69451
  - 7
    - Error Message when using Oracle Connection I am getting a <Unable to read data> returning from an Oracle Query in reporting Services. I have tried various ways to get the data but each time it returns with this error in the column. I am basically running the AVG function on a column in a group by query. When I use the Oracle for dotnet provider in Visual Studio the Query returns a value for the function, when using the Oracle, .NET Framework Data Provider for Oracle I get the error. Originally I thought it was the table size 5mm rows, but I cut the query down to 1mm rows and still the Oracle tool provides the answer but the Reporting Services Provider returns the error. I can't find anything anywhere about this error. Tag: '800a001c' error Tag: 69449
  - 8
    - Repeat data on every page Our report consists of two sections - one is a dynamic table where number of rows could vary and the table could span multiple pages, the other is a static table (number of rows/columns fixed) which represents the options the user choose to get the output in the first table. The data for both comes from different tables in the database. We need to repeat this static table on each page. Can this be done using SQL Server Reporting Services 2005? If yes, any guidelines for the same would be highly appreciated. Thanks in advance From http://developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: '800a001c' error Tag: 69448
  - 9
    - Printing a Matrix in Landscape Restarts the PC !! Hello I have a simple report using a matrix data region when i design the report and preview it in SQL Server Business Intelligence Development Studio there is no problem , if i do the following my PC and all PCs i tried on are restarting !! 1. if while previewing the report , a user changes page orientation to Landscape then try to print to a printer or a file , PC restarts 2. if i rename the rdl to rdlc and load the report in report viewer and do exact steps in point 1 PC restarts 3. if while designing the report in SSBI , i set page width indicating landscape size by switching width and height values then preview and print , PC restarts this is apparently a bug , can anyone please confirm having the same problem and does anyone knows a fix for this ? -- Best Regards Bassam Tag: '800a001c' error Tag: 69444
  - 10
    - Percentage of total column in Report Builder Hello, We are the using the end-user tool Report Builder. I want to create a 'Percentage of total' column to a certain table. For example: Value Percentage of total Region A 200 20% Region B 500 50% Region C 300 30% ------------------------------------ Total 1000 100% How can I achieve that? Regards, Jaap Mosselman Tag: '800a001c' error Tag: 69443
  - 11
    - Include link in SQL RS 2005 When I include link in e-mail from RS I get "The report is accessible at the following address:" before the the link. Where do I change this text? Tag: '800a001c' error Tag: 69441
  - 12
    - ReportServicesConfigUI.WMIProvider when config reporting srv 2005 please help I have been using Sql server Reporting services 2000 and i never had these problems I tried firing up my Sql server Reporting services 2005 today i went through the reporting services conf manager and then got to the "database setup" stage and bingo can't get through this error below ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation. ---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3) --- End of inner exception stack trace --- at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos) Looked for some info and got a hint here at: http://blogs.msdn.com/bimusings/archive/2005/08/23/455263.aspx But still can't get it to fox it.. Also with the Encription Keys i anytine i try to delete it BINGO again i get the error above.. These error has been given people nigtmares and it isn't new does anyone know the fix for this error.. Hope someone from Microsoft could help Tag: '800a001c' error Tag: 69438
  - 13
    - Custom Assembly Object initialised from Parameter Hi, In Reporting Services (SQL 2000) I have created a Custom Assembly for my report that reads some additional information from an XML file used to put headers on some columns. It works so far, calling code as below in the report: Dim myChecklist as Checklist Protected Overrides Sub OnInit() myChecklist = New Checklist("C:\Temp\checklist1.xml") End Sub Public Function GetCheckListHeader(ByVal TaskID as Integer) If Not IsNothing(myChecklist) Return myChecklist.GetTaskName(TaskID) End If End Function My next trick is to get the filename to be different for each time the report is run, passed as a parameter. According to a couple of things I found on the web, I should be able to do: Protected Overrides Sub OnInit() myChecklist = New Checklist(Parameters!CheckListFileName.Value) End Sub However when I do that, I get a "Reference to a non-shared member requires an object reference" message. My guess is that the Parameters collection doesn't exist at that point. Is there some other way of instantiating the CheckList object from a parameter when the report runs? Cheers, Iain Carlin Tag: '800a001c' error Tag: 69437
  - 14
    - percentage calculation *** Help I have a commission report Iâ??m working on and it is causing to lose hair fast. I need help customizing this commission report. The current report has a couple conditions: Condition 1: Pay 2% commission of the payment amount if purchased in 2006 Condition 2: Pay 5% commission of the payment amount if purchased in 2007 The new report needs to calculate commission base on the type of item purchased, and the previous conditions. Condition 1: Pay 2% commission of the payment amount if purchased in 2006 Condition 2: Pay 4% commission of the payment amount if purchased between Date1 and Date2 Condition 3: Pay 6% of extended price if ITEM Type is xyz. â?¢The problem Iâ??m having is with this new condition. I canâ??t account for if the customer pays half of the invoice. I need something to catch this and prevent paying the six percent twice for Item type xyz. Any suggestion would be great. Tag: '800a001c' error Tag: 69433
  - 15
    - Problem istalling SQL2000 RS I am trying to install SQL 2000 RS on my Vista box. I have installed VS 2003. But installation program says I don't have IIS running as well as ASP 1.1 framework not being registered or installed. Can someone please help me? Thanks Tag: '800a001c' error Tag: 69432
  - 16
    - Exporting to CSV SQL Reporting hi, I have a report i have written which contains data to be inported into SQL from a SQL report however when i export to CSV the header line which just contains a HDR and date column are repeated on every detail line? i had this problem in Crystal aslo but crystal had a fix any ideas how to sort this in SQL reporting? Many thanks in advance Tag: '800a001c' error Tag: 69427
  - 17
    - static page. Hi, I created a report (let's call it Report1) which has a drill through function. Report1 has 12 pages. After the users click on the hyperlink on the Report1, it goes to Report2. I have the following questions 1. Can I create a hyperlink for users to go back to Report1 without using the "Back" button. I don't want the users to click on the "Back" button provided by the browser. 2. Once they click on the back button goes back to Report1, it "ALWAYS" goes back to Page 1 on Report1. Since it is a 12 pages report, I would like to users to go back to where they were when the report is back to Report1. Can anyone please please help... Thanks Ed Tag: '800a001c' error Tag: 69426
  - 18
    - SQL reporting services Header problem HI, Im currently working with SQL Reporting services 2005. I have a table, which has two header. one as Default table header and another one i created with detailed row option. In the table propertly, General Tab is checked "Repeat header on each row" and "Header should remain visible while scrolling". Now i need the Header which i created using detailed row should be remain visible while scrolling. Pls give your advise on this. Thanks in advance. Frank Tag: '800a001c' error Tag: 69424
  - 19
    - Lists. tables and jpeg I have a preprinted form, saved as a jpeg that I need to populate fields from a query into it. I need to drop the text boxes on the form and then run the report and have multiple forms print for multiple customers. I need to group the dataset, so I have it in a table, in the group 1 row and expand teh form from there. When I run the report all I get is teh first record from the underlying dataset, 3 forms print, for 3 records, but only one has data? I thought possibly putting the table with the form in it in a list? I have no idea. Any help would be appreciated. Thanks Tag: '800a001c' error Tag: 69417
  - 20
    - Date fields causing screen refresh. We have many reports where we have date parameter for a begin and end date. When users either type a date or select it from the calender, it is causing the screen to refresh when they are done with that field. This is very anoyning to the users and is turning them off to RSS. Is there a setting that is causing this? Tag: '800a001c' error Tag: 69413
  - 21
    - forms authentication samples I cant find the forms authentication samples for srs 2005 C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample Tag: '800a001c' error Tag: 69412
  - 22
    - Another Question I want to create a horizontal table as follows: Ingot 12345 12345 12345 Traveler 98786 87657 77675 Pieces 15 20 12 Step 1 x x x Step 2 x x x Step 3 x x x Step 4 x x x Step 5 x x x Step 6 x x Step 7 x x ... Step 19 As you can see the columns for the steps are fixed. I know which step each traveler is on so I want to populate the table with x's until I get to the last step. As you can see from this report, the first and third travelers are about the same and the second is stuck on step 5. The managers can look at this and see that the second traveler will produce a hole later on. So how could I create this table in SSRS? Keep in mind the steps are predefined and will not change. So the information returned from the query would be similar to the following Ingot, Traveler, Pieces, Step 12345 98786 15 7 12345 87657 20 5 12345 77675 12 7 .... Thanks. Tag: '800a001c' error Tag: 69410
  - 23
    - Security questions I understand that SSRS only works with windows security and not sql. Does the windows account need to be created on the sql server in security logins? What is the minimum security for the windows account on sql if so? I am trying to get a few windows authentication accounts access to a report. I see how to add the user or group in the localhost/reports. Thanks, Ryan Tag: '800a001c' error Tag: 69407
  - 24
    - Can't use integer parameter with dateadd? Hey guys I have the following in my SQL statement: DATEADD(hh, @hours, @startTime) hours is an integer and startTime is actually a string, but the thing is that this statement works fine if I use it like this: DATEADD(hh, 8, @startTime) The first version is what I need so that the user can control from a parameter and I get the following error: Error Source: System.Data Error Message: Failed to convert parameter value from a Decimal to a DateTime. Thanks! BJ Tag: '800a001c' error Tag: 69406
  - 25
    - How can I display the text "\n" in a chart's label I loaded an .rdl file into reporting services. The .rdl file needs to display the following text "domainName/norman" in the <label> when displaying the results of a query in a chart. It looks like reporting services is manupulating '/n' in the text as a newline character and hence breaking the text into two lines: domainName orman How can I prevent that from happening since my report needs to display domain user names in the chart's label. Thanks. -- ANeelima Tag: '800a001c' error Tag: 69405
- Next
  - 1
    - Help with a bar chart I have included the sql statements and outputs for help on this. As you can see from the output the first 19 rows are what I want for the Y series label. After that I get the Travelers and the step they are currently on. What I want in the bar chart is to display all 19 rows on the Y axis (using the first query below) and then using the WIP_Status_Order from the last query to plot were the traveler is. The purpose of this chart is to give a visualization of were everything is and show any gaps in the system. Ideally the travelers listed first on the left will have their bars higher on the graph and it should slop to the right. However if a traveler was stuck then it show a smaller bar than the traveler to the right indicating there is a hole coming up in production. Any help is much appreciated. Query to list all steps select distinct step_Description, step, wip_status_order from traveler_step where WIPStep < 0 order by WIP_STATUS_Order Output Step_Description, Step, WIP_Status_Order Weigh/Record 10 1 Grit Blast 20 2 Hard Pickle 23 3 Hot Roll Intermediate 55 4 UT Test 15 5 Beta Quench 20 6 Grit Blast 25 7 Pickle 30 8 Air Anneal 40 9 Grit Blast 45 10 Pickle 50 11 Cold Roll Intermediate 60 12 Vacuum Anneal Hang 80 13 Cold Roll Final 90 14 Vacuum Anneal F/P 115 15 Plane Width 130 16 Machine Shape 140 17 Machine Grooves 150 18 Shear Final Length 165 19 Query for Items at a step SELECT Product.Ingot_Number, Product.Traveler_Number, MIN(Traveler_Step.Step) AS Step, Traveler_Step.WIPStep, Traveler_Step.WIP_Status_Order, Traveler_Step.Step_Description, COUNT(Product.Product_#) AS PieceCount FROM Product RIGHT OUTER JOIN Traveler_Step ON Product.Traveler_Step_# = Traveler_Step.Traveler_Step_# GROUP BY Product.Ingot_Number, Product.Traveler_Number, Traveler_Step.WIPStep, Traveler_Step.WIP_Status_Order, Traveler_Step.Step_Description HAVING (Traveler_Step.WIPStep < 0) ORDER BY Product.Traveler_Number, Traveler_Step.WIP_Status_Order Query Output Columns Ingot_Number, Traveler_Number, Step, WIPStep, WIP_Status_Order, Step_Description, PieceCount NULL NULL 10 -1 1 Weigh/Record 0 NULL NULL 55 -1 4 Hot Roll Intermediate 0 NULL NULL 15 -1 5 UT Test 0 NULL NULL 20 -1 6 Beta Quench 0 NULL NULL 25 -1 7 Grit Blast 0 NULL NULL 30 -1 8 Pickle 0 NULL NULL 40 -1 9 Air Anneal 0 NULL NULL 45 -1 10 Grit Blast 0 NULL NULL 50 -1 11 Pickle 0 NULL NULL 60 -1 12 Cold Roll Intermediate 0 NULL NULL 80 -1 13 Vacuum Anneal Hang 0 NULL NULL 90 -1 14 Cold Roll Final 0 NULL NULL 115 -1 15 Vacuum Anneal F/P 0 NULL NULL 130 -1 16 Plane Width 0 NULL NULL 140 -1 17 Machine Shape 0 NULL NULL 150 -1 18 Machine Grooves 0 NULL NULL 165 -1 19 Shear Final Length 0 U06436L 53086A 15 -1 5 UT Test 5 U06436L 53086B 15 -1 5 UT Test 4 U06450L 53223J 140 -1 17 Machine Shape 16 U06450L 53223K 140 -1 17 Machine Shape 3 U06450L 53223L 140 -1 17 Machine Shape 16 U06460L 53236A 140 -1 17 Machine Shape 5 U06460L 53237C 140 -1 17 Machine Shape 16 U06460L 53237I 45 -1 10 Grit Blast 4 U06460L 53237J 45 -1 10 Grit Blast 3 U06460L 53237K 30 -1 8 Pickle 4 U06460L 53237L 45 -1 10 Grit Blast 3 U06460L 53237M 30 -1 8 Pickle 4 U06460L 53237N 30 -1 8 Pickle 3 U06494L 53248E 23 -1 3 Hard Pickle 1 U06494L 53248F 23 -1 3 Hard Pickle 1 U06494L 53248G 20 -1 2 Grit Blast 1 Tag: '800a001c' error Tag: 69404
  - 2
    - SQL Reporting error Need help figuring out the issue here. One of my coworkers builds an ASP.Net 2.0 Web Site that displays a single SQL Report using the Report Viewer Control. This is the first time she has done this, and we recently got her a brand new machine with a fresh load of all the dev tools (matching the setup the rest of us have). When she ran the project she gets a very strange error page. We spent a number of hours checking all manner of things from the HTML, code, project settings, VS2k5 settings, computer settings, etc., but nothing we did helps at all. She is in the middle of building another .Net 2.0 project, minus the ReportViewer, which works without a hitch. In this project, if she removes just the ReportViewer control, the things runs fine, put it back in, it blows skyward. We tried having her reinstall the ReportViewer Control with no change. I and another developer took her project (making not one change), rebuilt the thing on our machines, and on both our PC's the web site runs without a hitch, the report displays, and all is right in the world. So, without further delay, here is the error text she is getting: <Error> ============================================================ Server Error in '/RR325-1' Application. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: An error occurred loading a configuration file: The network path was not found. Source Error: [No relevant source lines] Source File: \\10.10.78.50\d$\web.config Line: 0 Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 ============================================================ </Error> One thing that jumps out at us and that we have no idea why, is that the IP Address shown above is not the one for her machine. It's like something is repointing the process to some other location. Anyone have ideas, suggestions, etc.? -- Andrew Tag: '800a001c' error Tag: 69403
  - 3
    - Why can't I export my report without it being chopped in half? Why do all the export formats I try result in chopping my report in half? I have not adjusted the standard width of my report (10.25 in) and it ought to be a simple matter to fit it into Adobe. You would think they could come up with a better default than this. Tag: '800a001c' error Tag: 69402
  - 4
    - Security Extension Standard Edition Does RS 2005 Standard Ed support Custom Security Extension Tag: '800a001c' error Tag: 69401
  - 5
    - Integrated to Sharepoint mode - Deploy from VS/BIDS problem Successfully installed/integrated Sharepoint and Reporting services. FROM the Sharepoint reporting services site, I can upload reports and they run well. Problem: When I Deploy TO the Sharepoint Reporting servcies site, I completes the build, but the deploy gets through a ways and then asks me to login to Reporting Services. No matter what account (local or domain) I use (including all the system and domain accounts used to install Sharepoint/RS) it keeps giving me back the login prompt. Any ideas? Tag: '800a001c' error Tag: 69399
  - 6
    - Pie Chart Legend Question Hello, Is there any way to expand a pie chart legend so the legend description is not truncated? Thanks in Advance! Tag: '800a001c' error Tag: 69395
  - 7
    - Printing from Local Processing Mode I have a web app where I am using 2005 Reporting Services with ProcessingMode of Local. The ReportViewer is not showing the print button. I've looked through messages and found that printing was not supposed to be available. However I thought I read that printing functionality was supposed to be added with Service Pack 2. I just installed SQL Server 2005 Service Pack 2 and the Critical Update from Windows update. When I run my web app I still don't see the printer icon. If I change the ProcessingMode property from Local to Remote then I see the printer icon. Is printing from local processing mode supposed to be supported after service pack 2 or did I not read something right. If it is supported, anyone know if there are any special steps I need to do to make it work? Thanks! Terry Tag: '800a001c' error Tag: 69392
  - 8
    - Horizontal growth in rendering problems I am getting sporadic horizontal growth. I am using RS2005. In Browser: Firefox renders fine, IE6 will push the table width out past the printable width. If I print preview everything seems like it fits properly. an example: http://img244.imageshack.us/img244/4885/growthft9.gif pdf exporting seems to render fine, but the width of excel isn't right. It will print the last column on separate pages. perhaps they are unrelated, the width on IE6 is reminiscent of the usual padding/margin woes, but it doesn't happen on all my reports so I am unsure why it would freak out on this one. Tag: '800a001c' error Tag: 69391
  - 9
    - how can i sum date, months not integer Hello how can i sum date? eg. getdate + 1.3 months thanks Tag: '800a001c' error Tag: 69390
  - 10
    - Report parameter - > Select All Option is not coming Hi, I have created a report parameter with multi-value option. In preview mode i can see "Select All option" but once deployed i can not see that option over web. any idea? Regards, Sri Tag: '800a001c' error Tag: 69387
  - 11
    - Sharepoint services 2.0 failed - RSWEBPARTS PublicKeyToken Error Have then following error after removing reporting services from our sharepoint 2.0 server. The RSWebParts, Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 assembly specified in a Register directive of this page could not be found. When I go to the Web Parts Maintenance Page I can see the website pages, but no ide why the error started, or how to fix it. Cheers John Tag: '800a001c' error Tag: 69384
  - 12
    - The RSWebParts, Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 assembly specified in a Register directive of this page could not be found. Have then following error after removing reporting services from our sharepoint 2.0 server. The RSWebParts, Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 assembly specified in a Register directive of this page could not be found. When I go to the Web Parts Maintenance Page I can see the website pages, but no ide why the error started, or how to fix it. Cheers John Tag: '800a001c' error Tag: 69383
  - 13
    - Issue getting data under Reporting Services to Sharepoint's GetItemLists.. Help for a Newbie?? Hi, Ok, I am trying create a simple report for one of my Sharepoint Lists. I am using VS.NET using the Report Server Template when creating the report. Here are my steps: 1) I Create a new Report Server Project under VS.NET 2005 2) I Create a dataset and in that dataset, I set the datasource type to XML, and the Connection String to http://<mysite>/_vti_bin/Lists.asmx I have created the Query String as: <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</ SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>9b93c054-767e-4ddb-8084-8e3451dd00b9</ DefaultValue> </Parameter> </Parameters> <Where> <Eq> <FieldRef Name="LinkIssueIDNoMenu" /> <Value Type="value">@JobNumber</Value> </Eq> </Where> </Method> </Query> Now, when I run it, I get ALL records back, but it seems like it doesn't matter what I put in the <WHERE> options, even if I put something total incorrect, I always return ALL items, rather than the Item matching the parameter @JobNumber. If I take out the Parameter and put in say 21 which is valid, I still get ALL records. Is the syntax correct that I am using and is there some documentation somewhere regarding this? I have looked for days, but cant find anything other than pieces here and there. Can anyone offer assistance as to why the <WHERE> doesnt seem to work, although under a VB app that I tested the <WHERE> with, worked fine and bought back the one record. Any assistance greatly appreciated. Robert Tag: '800a001c' error Tag: 69380
  - 14
    - 2 data sets in one report SQL reporting I am new to SQL reporting and am trying to use two datasets in one report using Visual Studio 2005 Both datasets are from SQL databases and are added to the report fine i can also drop fields from both onto the report the problem i have is how do i link the 2 datasets so i can pull data from both datasets and produce one report? Any help much appreciated Tag: '800a001c' error Tag: 69379
  - 15
    - Reporting Services Architecture question(s) - advice greatly appreciated Hi there We have an emerging set of demands for reporting services 2000 and reporting services 2005 for at least two applications and frankly I too little about it but am in the position of having to make some decisions pretty quickly without the time to play around and experiment. We have two apps requiring Reporting Services One application is fat - .exe on client, database on SQL server 2000 (needs RS 2005) One application is a thin , IIS and SQL server 2000 (needs RS 2000) My preference is to abstract away Reporting Services to its own box rather than installing it on the SQL server. (Server Load, server abstraction - if we want to move database, rebuild server, whatever, the usual stuff) and from there to use one RS box for any emerging RS requirements for subsequent apps bot for production and test. In the fat app we therefore have exe ->RS box -> SQL In the thin app we have client -> client IIS box -> RS IIS box -> SQL box Because of the licensing issues I'd rather centralise Reporting Services rather than install on every IIS app server but therefore adds an extra IIS server into the chain. We have dozens of production SQL servers, databases can move form one server to another depnding on circumstances and I really don't want to install reporting services 2000 and rs 2005 on 65 production servers and alsmost as many test servers Is it a viable to centralise reporting services to act on behalf of any any application that may need it in the future? Does the extra layer add undue delay or complexity? Is reporting server resource intensive or is the load really on the sql server? Can RS2000 and RS2005 happily co-exist on one box? Can I run test (SQL) RS and production RS on the same box? Thanks a lot in advance Barry Tag: '800a001c' error Tag: 69378
  - 16
    - Logon failed during timed subscriptions Hello, Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting services 2000 SP2. Reporting services using account of sql server authentycation with logon name of 'sa' and password. Executing reports from manager working fine, but timed subscriptions failing on execution with the following error: 'Logon failed'. RS log file has the following messages: e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing notification. Logon failed. ReportingServicesService!notification!1094!05/11/2007-03:23:05:: Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False, Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch Inventory-tmp, Attempt 0 ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05:: NotificationPolling finished processing item 63d3f301-ff48-4fc2-9697-578eaf02d5da ReportingServicesServic Dears, what caused notification problems: is it problems with scheduled jobs or is it authentycation problems with SMTP? How to see (or somehow extract) more detailed log from RS? Thanks, Andrius. Tag: '800a001c' error Tag: 69376
  - 17
    - CSV - Visibility/Hidden not working with formulas I use formulas (IIF(condition=true,false,true)) in the Visibility/Hidden property to decide whether to display or hide certain columns in a table. This method works fine for excel reports but I can't get it to work for the CSV renderer. The columns with formulas does not render at all in CSV, even though they display when I run the report through the Preview, or ReportManager on the SQL server. Is this a known issue? Is there a workaround? Tag: '800a001c' error Tag: 69375
  - 18
    - List of color names? I would like to put the names of the colors into the database to allow users to configure how they want a matrix report to appear. I don't think they are standard HTML names are they? Can someone point me to where can I find this list of names, or any other advice with this endevour? cheers, Paul. Tag: '800a001c' error Tag: 69356
  - 19
    - RDLC...Printer Control The icon in the preview bar is missing, what I am doing wrong that I cannot get it to display? Tag: '800a001c' error Tag: 69351
  - 20
    - List & Dataset Hi, i have two matrix in two different lists with two different dataset. i would like to know if it is posible to put one of the list into another list? Please advice. For example, i have a item table with the item no ,price and sub item, item is unique, and i have another table which has the subitem no and item features, each item might have multiple row of feature. let say: Table 1 --------- item price subitem A 2.50 AA B 1.50 AA C 1.00 BB D 2.00 AA E 1.00 CC Table 2 ---------- subitem feature AA a AA b AA c BB t C y i would like to display ------------------------------ subitem: AA feature : a b c ------------------------------ item: A 2.50 B 1.50 D 2.00 ------------------------------ subitem: BB feature : t ------------------------------ item: C 1.00 ------------------------------ subitem: CC feature : y ------------------------------ item: E 1.00 ------------------------------ i tried to link the two table together as one, it will display duplicate item, like below item price subitem features A 2.50 AA a A 2.50 AA b A 2.50 AA c B 1.50 AA a B 1.50 AA b B 1.50 AA c C 1.00 BB t D 2.00 AA a D 2.00 AA b D 2.00 AA c E 1.00 CC y and the result will be ------------------------------ subitem: AA feature : a b c ------------------------------ item: A 2.50 A 2.50 A 2.50 B 1.50 B 1.50 B 1.50 D 2.00 D 2.00 D 2.00 ------------------------------ subitem: BB feature : t ------------------------------ item: C 1.00 ------------------------------ subitem: CC feature : y ------------------------------ item: E 1.00 ------------------------------ or any idea to make the item to be distinct? Tag: '800a001c' error Tag: 69350
  - 21
    - Sorting By Date I am new to this. I was wondering how I could go about sorting a report by date. I have the report to a point where it will generate, but it will not allow me to sort via date. I would also like to be able to sort by date and time. Can anyone help? Thanks Scott Tag: '800a001c' error Tag: 69343
  - 22
    - Please help! "Object reference not set to an instance of an object." I'm getting an error that's baffling our staff, and is quite urgent. The error is: An unexpected error occurred in Report Processing. Object reference not set to an instance of an object. The report is a local report, hosted in a webform, and runs fine in most cases, but fails consistently under certain criteria. It's fed by a proc that works fine. (Did trace & intercepted call, and tested results from proc.) I'm using a SqlDataSource to get the data from the proc. It doesn't appear to be bad data, because if I pull for Minnesota, it fails. If I break that into halves, East MN works fine, and West MN works fine. As for the amount of data, If I pull larger states, it works fine. There are also much smaller areas that fail. They also work individually if I break them into smaller areas. (Any bad data should have appeared in the smaller areas.) I cannot find a common denominator here to explain the trouble. I need ideas. Thanks! Tag: '800a001c' error Tag: 69342
  - 23
    - Parameter question I have a date field as a report parameter. For I am getting all the unique values for the date and the users can select one date or all dates. Now they want to see a drop-down selection of 'Last 30 days'. I supposed I can just UNION in an additional row with value of 1753-01-02 and label of 'Last 30 days'. How would this be coded in the main SQL? I already have: ...AND ((D.sent_date = @sent_date) OR (@sent_date = convert(datetime,'1753-01-01'))) Stephanie Tag: '800a001c' error Tag: 69341
  - 24
    - Percent in Parameter Problem Hi I'm Trying to code the following: User Parameter "Adjust Percent" Here the User enters: 14 but in the code below, if the user enters 14, I want the value of @AdjustPCT to be (.86) how do I do this??? Parameters do not offer decimal in the drop-down box. Then I figured I would try in the expression of (Parameter @AdjustPct) something like: =IIF(Parameters!AdjustPct.Value > 0, 100 - Parameters!AdjustPct.Value / 100 , 1) This doesn't work I get errors. The code looks like: SUM(CASE TT_SUMMARY_GROUP WHEN '0010' THEN PERIOD_NET_SALES * @AdjustPct WHEN '0030' THEN PERIOD_NET_SALES * @AdjustPct WHEN '0040' THEN PERIOD_NET_SALES * @AdjustPct ELSE PERIOD_NET_SALES END) AS PERIOD_NET_SALES, So what do I have to do so that the User enters "14" but in the end @AdjustPct is really ".86" ? Can Anybody offer help? Thanks In Advance Tag: '800a001c' error Tag: 69340
  - 25
    - Export report to PDF programmatically (forms authentication) I use ReportExecutionService class to export a SQL reporting services report to a PDF file. It seems not work, and failed at method â??LoadReportâ??. The error message said: Object moved to <ReportServer Login Page>. I think, itâ??s an authentication problem. The report server is set to form authentication, and I wrote a custom security DLL, and share the auth cookie with ASP.NET Web application. It works fine with ReportViewer. I set ReportExecutionService.Credentials = System.Net.CredentialCache.DefaultCredentials. It looks like my network login windows account (MyDomainName\MyUserName), and of course it is failed. I read the ReportExecutionService class members, and can not find way to pass auth cookie, or some kind of forms authentication object into ReportExecutionService class. Does anyone render report into PDF (HTML) file successfully by ASP.NET code for forms authentication? I search the sample code over internet. The sample code only uses CredentialCache.DefaultCredentials, and it looks a windows authentication credential. Am I wrong? Thanks for any suggestion and advice. Shaw --------------------------------------------- Tag: '800a001c' error Tag: 69338

was editing my website and added a feature in error. I tried deleting it all
to no avail. Then I began getting the following error message:

Microsoft VBScript runtime error '800a001c'

Out of stack space: 'Val'

/admin/content/pages.asp, line 7

The part in /admin/content/pages.asp, line 7 reads:

For I = 0 To UBound(arrArray)
If Val(arrArray(I)) = Val(varValue) Then
Array_Exists = True
Exit Function
End If
Next
Array_Exists = False
End Function

I have no idea what to do about it. Any hint or link to the right direction
will be appreciated.
Thanks.

Top