help!!...sp1 or sp2

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
    - Iff OtherValue = 0 then MyFont = Bold Hi, For one of my reports I should have a given field getting a Bold font, when another value in the DataSet = 0 (or whatever value). How can I set the Font/Bold-proeprty at runtime? Via an expression? Thanks a lot, Pieter Tag: help!!...sp1 or sp2 Tag: 52037
  - 2
    - Report Parameter Display Problem Hi, I am developing several reports, I want to pass one parameter from Report1 to Report2 and also make the same parameter selectable on Report2. However I figured out that if I pass the parameter from Report1 to Report2 and Report2 has the same report parameter, then the parameter bar on the top of Report2 is not displayed. Moreover if I click the Report2 on the report folder then the Report2 parameter bar is displayed. How can I force Reporting Services to display the parameter bar on the Report2? Configuration: Win2003 Standard Edition (Latest SP) SQLServer 2000 (SP2) SQLReporting Services (SP2) Visual Studio 2003 (SP1) .Net 1.1 Alp Eren YILMAZ Tag: help!!...sp1 or sp2 Tag: 52034
  - 3
    - URGENT: Error while executing the report Hi, Please Help........ Im having problem with report creation.I tried creating a report with the Stored Procedure and its gives me the following error. "An error occured while retriving parameters in the query DeriveParameters requires an open and available connection.The connections current state is closed". The stored Procedure is quite big. Any body who can suggest a solution for this? Thanks a lot....... Tag: help!!...sp1 or sp2 Tag: 52033
  - 4
    - Printer Delivery Error Hi, I have installed the printer delivery sample extension on my report server. It works fine, reports print as required and there are no obvious errors in the log files however, the status shown against the subscription says "Done: 1 processed of 1 total; 1 errors." i.e. it thinks there was an error. This is annoying because the admin people who check the schedules say they have not worked even though they have printed the reports. I suspect this could be caused by a problem in the VB code where it returns an error code even though there was not an error, but not being a VB programmer, I don't know how to find let alone fix the problem. Even though there are no errors in the error logs, I did notice a line which says: Notification ...... completed. Success: False, Status: Report printed to ..... It says report printed, which it did, but I think the "Success: False" part might be where the problem lies. Other subscriptions say "Success: True". Any ideas on fixing this would be appreciated. Tag: help!!...sp1 or sp2 Tag: 52031
  - 5
    - Cannot deploy to report server When accessing report server by IE, following error occurred: Reporting Services Erro -------------------------------------------------------------------------------- An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors -------------------------------------------------------------------------------- SQL Server Reporting Services Checking logfiles at report server shows this SQLDumper_error: 03/29/06 17:56:47, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514) 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4076 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL> 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL> 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL> 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL> 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used 03/29/06 17:56:47, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0001.mdmp 03/29/06 17:56:47, ACTION, w3wp.exe, Watson Invoke: No Pls advise how to fix this error, probably invoked by w3wp.exe ? The report server machine has dual cpu installed. Tag: help!!...sp1 or sp2 Tag: 52027
  - 6
    - Automated client report rendering My company would like to write an app that does on-demand rendering of certain reports. Is there a .NET client report rendering library that is not dependent on IIS (as the SOAP/URL apis are), nor WinForms (as the ReportViewer is)? Thanks, Eva Tag: help!!...sp1 or sp2 Tag: 52026
  - 7
    - Crystal ate my Report Manager Everything was fine until I had to uninstall and reinstall Crystal. After that, RS lost it's encryption key. I reset the connection properties and it said that the database version was old, so... I uninstalled, removed the databases and reinstalled (sucessfully). Then I redeployed all my projects/reports from VS. The first time I pulled up Report Manager, I could see all the folders, but when I tried to pull up reports, it couldn't find them (404). And now, I can't even get to the report manager. When I look at the IIS logs, it seems to be cycling with win 32 status of 302 0 0 I'm really puzzled because we've been using RS for a long time on this and other servers without problems. I've compared IIS configurations and examined the RS logs, but find nothing. Any ideas? Please! -- Thanks, CGW Tag: help!!...sp1 or sp2 Tag: 52025
  - 8
    - ActiveX renderer? Does anyone know of a (possibly, even probably 3rd party) report renderer ActiveX control? It would be like the ReportViewer control, but not .NET dependent. I realize that the existence of such a control would mean someone wrote an entirely new rendering engine in unmanaged code, so it's a long shot. But I'd like to know if anyone's tried, or is trying it; my company would purchase it. Thanks, Eva Tag: help!!...sp1 or sp2 Tag: 52024
  - 9
    - Grouping across Hi all, I have to create a report from the following data: Person status $ person1 confirmed 100 person1 pending 200 person2 pending 100 person2 completed 100 The report needs to display like: Person [confirmed count] [conf $] [completed count] [comp $] [Pending count] [Pend $] person1 1 100 1 200 person2 1 100 1 100 Any thoughts would be MUCH appreciated! -Thanks, D Tag: help!!...sp1 or sp2 Tag: 52023
  - 10
    - Custom Assembly in SMDL I have created Custom Assembly that I am using in the Reports that I created in Report Designer, it works and everybody is happy. Question is how can I use this same custom assembly in my SMDL, so that I can use this function in the DSV column defintion. Where can specify the Custom Assembly reference. I am trying to get some help on custom assembly and SMDL in the internet, No Luck. Please Help!. Thanks, Tag: help!!...sp1 or sp2 Tag: 52020
  - 11
    - hierarchies in a report model off a cube As I'm sure most people know, you can create a report model (for use in Report Builder) off a cube by using the "Generate Model" button on an SSAS datasource in Report Manager. However, none of the hierarchies in the cube (user defined or parent-child) are exposed in the resulting report model. All you get are the attributes. Does anybody have any workarounds or hacks they can suggest? (Any chance I could hack into the XML of the multidimensional report model manually and expose these hierarchies?) There are features of hierarchies (like ragged hierarchies or parent-child hierarchies) that I really need to expose in Report Builder. FYI... they're looking into enabling hierarchies in Report Builder in a future release.. http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=b51d55fd-502a-4067-b9e9-b68a216da943 Please vote for that suggestion if you feel this is important. Tag: help!!...sp1 or sp2 Tag: 52018
  - 12
    - Moving the Tables Up Hi All, I have a List containing some textboxes and three (3) tables. I would like to know how to be sure the bottom-most table will not display if there is no data returned for it. It seems to work correctly in "Preview" but when I deploy (Start > Production) the report and view it in IE6, there is a space where the table would be. Any ideas are appreciated. Thanks! Fred Tag: help!!...sp1 or sp2 Tag: 52017
  - 13
    - How to view SQL being sent to the server? Using SQL Server 2k5 Report Designer. When I run a report, how do I view the SQL generated by the report populated with parameters that is/was/will be sent to the server? Thanks Tag: help!!...sp1 or sp2 Tag: 52016
  - 14
    - ReportViewer in SSRS2000 Is it possible to restrict the ReportViewer export options to only a select few ? Thanks Tag: help!!...sp1 or sp2 Tag: 52014
  - 15
    - Using CLR Stored Procedures with Reporting Services I was able to create some T-SQL Stored Procedures, and call them from the Data tab in Reporting Services. All I did was type in the name of the stored procedure under the Data tab. This works great. I created a CLR Stored Procedure in Visual Studio by creating a database project, then a stored procedure. I click deploy, and I can see the clr stored procedure in SS Enterprise Studio. I can run the stored procedure in Enterprise Studio. I can also run the stored procedure from the test.sql in Visual Studio. When I enter the name of the CLR Stored Procedure in the Reporting Services data tab, I get the following error: The stored procedure 'StoredProcedure1 doesn't exist. (System.Data) Any pointers on running CLR Stored Procedures from the Data tab in Reporting Services? Thanks, -- Randy Tag: help!!...sp1 or sp2 Tag: 52013
  - 16
    - Legend and Pie Values(Point Labels) - Poor Visibility I am using SSRS2000 and have 2 problems. 1. The values displayed in the legend are mostly hidden and are cut off mid word with '...' appended which makes it useless and most of the time the values are unreadable - can I correct this ? It doesn't seem to matter where I position the legend it will just never display in its entirety making it a pointless feature. 2. The Point labels on my Pie are often unreadable in smaller segments. I changed the position of the Point labels in Visual Studio 2003 which renders it exactly as I want with a line coming off the segment indicating the values. However, the report server chooses to ignore this for some reason and just renders the labels in an unreadable format on the pie itself. I am at my wits end with this product at the moment as it seems to make the slightest things unnecessarily difficult. Any help or guidance would be very much appreciated. Thanks, Simon Tag: help!!...sp1 or sp2 Tag: 52003
  - 17
    - How to handle linked report embedded on the web application? Is it possible to STOP the linked report opening in a NEW windows? I embedded the reporting service in my web application. It opens the reports in the report holder, however it opens a NEW windows for the linked (drill through) report. Can I code the linked report so that it only opens in the report holder in my application? Why is that when exporting report to Excel it opens a BLANK windows and when I close the Excel the BLANK windows stay? How can I tell what service pack I installed on the Reporting Services? I am using Sql 2000 server on a Windows 2003 Server and Sql 2000 Reporting Services Evaluation version is installed on a Windows XP workstation. Can I download the proper standard version of the Sql 2000 Reporting Service for my Windows XP computer? Many Thanks! Tag: help!!...sp1 or sp2 Tag: 52002
  - 18
    - Using report parameters as field names in a SELECT Hi, I am having a problem in Reporting Services 2005. I want to use report parameters as field names in a select statement, but the query just returns the value of the parameter. Ex. SELECT @pField1 FROM customers returns the actual string value of @pField1 I'm entering this query in the Generic Query Designer as the command text for my dataset. Is what I'm trying to do possible? The reason I'm trying to do this is, I have a report with a Matrix on it. For the Columns data, I'm using Branch/Division. For Rows, I have days of the month selected. Then for the data area, I need to select the data as per a filter entered by the user via a droplist of pre-determined values (in the Report Parameter). The problem is that for each possible value in the filter droplist, that's a different field in the DB table. So, for the report parameter, I have each different field name in the DB as the value for each different filter option. That way, when the Report Parameter gets it's value from the filter, the data fields would automatically update in the Matrix. If this logic is wrong, please let me know, as that negates the original question. Thanks very much in advance. Tag: help!!...sp1 or sp2 Tag: 52000
  - 19
    - How to build an expression for a textbox? Can I build an expression on a textbox with a "Sql Select" statement based on the dataset? There is a parameter user selected on the dropdown and it generates a dataset from the store procedure. This parameter is used on a subquery for this dataset in the store procedure and it will return with the records containing other parameter IDs. However I need to assign a record on a textbox and require to filter out the record with the same parameterID user selected in the dropdown. Thanks. Eg. Parameters!Person.Value=2 selected in the dropdown Recordset: SearchName PersonID LName FName 1 Doe John 2 Doe Peter 3 Doe Jane I need to assign the the name Doe, Peter on a textbox. Tag: help!!...sp1 or sp2 Tag: 51999
  - 20
    - What would cause a report to refresh ~ every 9 minutes. Looking in the IIS logs I found that when a report is opened in IE it refreshes or there are entries in the logs every 9 minutes. I tried to change the auto refresh on a report from 0 to 3600, redeployed the report and it still refreshes every 9 minutes. The reports are run from an ASP.NET 1.1 web page with a web control to view the reports. I looked at the web page and control and did not see anything that would affect the refresh. Other than AutoRefresh in the report properties what would cause a report to go back to the web server every 9 minutes. -- Mark Tag: help!!...sp1 or sp2 Tag: 51990
  - 21
    - looking for the sample rss scripts i'm trying to get a peek at the sample *.rss script listed in the SS BOL help for Report Services. I can't find them. I think I've installed everything from the VS2005 DVD disk. I've searched the microsoft download site. I've downloaded the .NET SDK....to no avail I am looking for the following: AddItemSecurity.rss Demonstrates how to use a script to set item security policies in the report server namespace. CancelRunningJobs.rss Demonstrates a sample administration script that cancels jobs that are running on a report server. ConfigureSystemProperties.rss Demonstrates a script that can be used to set system-level, report server properties. PublishSampleReports.rss Demonstrates a script that publishes the sample reports to a report server. Can someone spell out the steps I need to get these items on my harddrive? Thanks. Tag: help!!...sp1 or sp2 Tag: 51987
  - 22
    - One report Parameter is based on another Is it possible to have a query with a report parameter to be a query for another report paramter? Tag: help!!...sp1 or sp2 Tag: 51986
  - 23
    - A solution: pop-up window/dopdownlist when clicking on an item I've been looking for a way to give the user of a report the choice between several actions when clicking on an item. A pop-up window or a drop-down-listbox with the different option, from which a user can choose would be great. I've created a solution for this (if MS has already provide something in RS 2005 you can stop reading here). My solution creates a menu that apears at the location of the mouse-click and that offers the user a list of options. When an option is selected an action is performd and the RS page is reloaded. The action in this example is: updating a table, but the example can easely be modified to make the RS page rederict to another URL. ------------ Report ------------ In the RS report the folowing code is inserted in the "jump to url"-property (where you want the menu to appear) ="javascript:void(window.open('http://ibissrv/beleidsinfo/DropDownList.aspx?Item=" & Fields!XXX.Value & "&DDL=RendaTypeStatus','_blank','titlebar=no,menubar=no,scrollbars=no,location=no,status=no,toolbar=no,resizable=yes'))" This calls a asp.net page "dropdownlist" that takes two parameters: (1) "Item" identifies the itme you want to change (in this case the primary key of a table (2) "DDL" (DropDownList) is the name of the dropdownlist you want to make appear Note: if you only want to change the URL (and no update action) you migth use the first parameter as a parameter in the target URL The list with the window options: "titlebar=no,..." is important. It makes sure that the menu looks like a pop-up window ----------------- aspx client side ----------------- The setup of the page is simple: <%@ Page Language="vb" AutoEventWireup="false" Codebehind="DropDownList.aspx.vb" Inherits="dropdownlist.WebForm1"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>WebForm1</title> <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1"> <meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> </HEAD> <body MS_POSITIONING="GridLayout" onload="return Resize(event)"> <form id="Form1" method="post" runat="server"> <asp:Table id="Table1" style="Z-INDEX: 101; LEFT: 0px; POSITION: absolute; TOP: 0px" runat="server" BorderStyle="None" BorderWidth="0px"></asp:Table> </form> </body> </HTML> It contains an empty table that we will use to put the menu-items in. It contains an "onload" event ("Resize") for the body that we will use to resize the page to the size of the menu en to put it at the place of the mouse click ----------------- aspx server side ----------------- The page_load event looks like this: ------------------------------------ Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Dim lv_startupscript As String 'read the parameters gv_item = Request.QueryString("Item") gv_ddl = Request.QueryString("DDL") readrecords() lv_startupscript = "<script language=JavaScript>" lv_startupscript += "function Resize() {window.resizeTo(115," & (gv_ItemsCount * 25) + 30 & "); " lv_startupscript += "window.moveTo(event.clientX,event.clientY); }" lv_startupscript += "</script>" Page.RegisterStartupScript("ResizeScript", lv_startupscript) lv_startupscript = "<script language=javascript event=""onstop"" for=""document""> opener.location.reload(1)" lv_startupscript += "</script>" Page.RegisterStartupScript("EndScript", lv_startupscript) End Sub (1) First we read the parameters of the page and put them in two global variables (2) We then create the menu with the "readrecords"-procedure (cfr. infra) (3) Then we add "Resize" function to the page. This script uses "gv_itemscount": the number of items in the menu, to set the size of the menu correctly. "gv_itemscount" is set in "readrecords". The script then moves the menu to the place that the mouse was when you clicked the report (or miliseconds after). (4) We then add a client-side event for when the menu is closed. This script ensures that the RS report is reloaded from the server (it forces RS to refetch the data from the server) This is nececary because we will update the data as a result of the user selecting a menu-item. If you only change the URL of the report you dont need this event. The Readrecords procedure ------------------------- This will read the basic information from a definition table "rs_dropdownlists_definitie". This table (I work with oracle - sorry) contains: (1) the sql to select all the menu-items (2) the sql to identify the default menu-item (2) the sql to be executed when an item is selected The second sql can use "#Item" in the sql reference the value of the page-parameter "Item" (f.e. to fetch the current value of the field you wan't to update) The last SQL can use "#Item" and "#SelectedItem" (the value of the selected menuitem) cfr. infra So what we do is: - we fetch the information from the definition table (in c_DDLList) - we fetch the default value (in c_SelectedValueList) - we fetch the menu-items (in c_ItemsList) Private Sub readrecords() Dim lv_DDLSql As String = "Select * from renda.rs_dropdownlists_definities where dropdownlist_id = '" & gv_ddl & "'" Dim lv_DDLAdapter As System.Data.OleDb.OleDbDataAdapter Dim c_DDLList As New System.Data.DataSet Dim lv_SelectedValueSQL As String Dim lv_SelectedValueAdapter As System.Data.OleDb.OleDbDataAdapter Dim c_SelectedValueList As New System.Data.DataSet Dim lv_ItemsSql As String Dim lv_ItemsAdapter As System.Data.OleDb.OleDbDataAdapter Dim c_ItemsList As New System.Data.DataSet Dim lv_NewTextBox As Button Dim lv_tablerow As TableRow Dim lv_tablecell As TableCell lv_DDLAdapter = New System.Data.OleDb.OleDbDataAdapter(lv_DDLSql, conRenda) lv_DDLAdapter.Fill(c_DDLList) gv_sql = c_DDLList.Tables(0).Rows(0).Item("UPDATE_SQL").ToString lv_SelectedValueSQL = c_DDLList.Tables(0).Rows(0).Item("SELECTEDVALUE_SQL").ToString.Replace("#Item", gv_item) lv_SelectedValueAdapter = New System.Data.OleDb.OleDbDataAdapter(lv_SelectedValueSQL, conRenda) lv_SelectedValueAdapter.Fill(c_SelectedValueList) lv_ItemsSql = c_DDLList.Tables(0).Rows(0).Item("SELECT_SQL").ToString lv_ItemsAdapter = New System.Data.OleDb.OleDbDataAdapter(lv_ItemsSql, conRenda) lv_ItemsAdapter.Fill(c_ItemsList) gv_ItemsCount = c_ItemsList.Tables(0).Rows.Count Then we start to create the menu-items (in the table to get the layout rigth): For i As Integer = 0 To gv_ItemsCount - 1 'creeer een nieuwe textbox en zet hem op de form lv_NewTextBox = New Button lv_NewTextBox.Text = c_ItemsList.Tables(0).Rows(i).Item("NAME") lv_NewTextBox.Attributes.Add("runat", "server") lv_NewTextBox.Attributes.Add("onclick", "ItemSelected") lv_NewTextBox.Attributes.Add("autopostback", "true") lv_NewTextBox.Style.Add("cursor", "hand") lv_NewTextBox.ID = "MenuItemId" & i lv_NewTextBox.BorderColor = Color.Blue If lv_NewTextBox.Text = c_SelectedValueList.Tables(0).Rows(0).Item("Name") Then lv_NewTextBox.BackColor = Color.LightYellow Else lv_NewTextBox.BackColor = Color.White End If lv_NewTextBox.Font.Size = FontUnit.XSmall lv_NewTextBox.Height = Unit.Pixel(20) lv_NewTextBox.Width = Unit.Pixel(100) lv_NewTextBox.ForeColor = Color.Black AddHandler lv_NewTextBox.Click, AddressOf ItemSelected lv_tablerow = New TableRow lv_tablecell = New TableCell lv_tablecell.Controls.Add(lv_NewTextBox) lv_tablerow.Cells.Add(lv_tablecell) Me.Table1.Rows.Add(lv_tablerow) Next end sub and in the process we add a "onclick" event to each menu-item and define our own handler "ItemSelected" (cfr infra) and we give the default menu-item a lightyellow backround Note: (1) Add("autopostback", "true") is necesarry (2) readrecords shoul be executed every-time (not only on "not postback") The procedure ItemSelected -------------------------- This will do the work when a user slects an item: Public Sub ItemSelected(ByVal sender As Object, ByVal e As EventArgs) ExecSQL(gv_sql.Replace("#Item", gv_item).Replace("#SelectedItem", sender.text)) Response.Write("<script language='javascript'> { self.close() }</script>") End Sub It starts by executing the update-sql (which we saved in gv_sql, back in de readrecrds procedure) and changing #SelectedItem by the value of the selecte menu-item ("sender.text") The execSQL is just a general purpose procedure: Private Sub ExecSQL(ByVal p_sql As String) Dim lv_command As System.Data.OleDb.OleDbCommand Dim lv_con As System.Data.OleDb.OleDbConnection conRenda.Open() lv_command = New System.Data.OleDb.OleDbCommand(p_sql, conRenda) lv_command.ExecuteNonQuery() lv_command.Dispose() conRenda.Close() End Sub The seconde line of "ItemSelected" then closes the menu and thus forces the "onclose" event (reloading the report). If you only want to change the URL you would change the ItemSelected in: Public Sub ItemSelected(ByVal sender As Object, ByVal e As EventArgs) Response.Write("<script language='javascript'> { window.opener.open(""" & gv_url.Replace("#Item", gv_item).Replace("#SelectedItem", sender.text) & """) }</script>") End Sub Presuming you would have fetched and stored the URL in the same manner as the update-sql. Hope I've helped someone with this. Antoon Tag: help!!...sp1 or sp2 Tag: 51983
  - 24
    - Internaional Date Formatting for Birthday I am currently taking a US standard date/time then using a passed in parameter to determine language. Changing for example from 'en-US' to 'en-GB'. Now I need to go from the format of MM/dd to dd/MM to reflect birthday only not date of birth. Tag: help!!...sp1 or sp2 Tag: 51976
  - 25
    - Client-side print ActiveX Some of our clients have disabled workstation ActiveX plugins downloads and install. Is there a way to install the RSClientPrint.dll manually? TIA. Tag: help!!...sp1 or sp2 Tag: 51974
- Next
  - 1
    - Report parameters I have a datetime parameter. Also I have a listbox with available jobs to report for. I want to filter the listbox on the selected date. How can I do that? Thanks Tag: help!!...sp1 or sp2 Tag: 51973
  - 2
    - Userrname reverts after name change We have a user that was entered into the domain incorrectly and added to reporting services with that name. The problem was corrected by changing the name in the domain and reporting services. The SID remains the same. Every day or so (I'm not sure exactly how often) the UserName in the Users table of the reporting services database reverts back to the old name. Does anyone have any idea why this would happen? Is it updating that table from somewhere? -- Neil Tag: help!!...sp1 or sp2 Tag: 51971
  - 3
    - filter using operator IN I would like to know how to make a muti-value parameter work with a filter. I tried using the in operator with join(Parameters!concept.Value,",") as the value. I have also tried adding parenthesis to the value with no luck. I have also tried just hardcoding it, but cannot figure out the format and cannot find any documentation. I tried "(PH,KF)" How do I get this to work? Tag: help!!...sp1 or sp2 Tag: 51968
  - 4
    - Datasource information retrieved from a database Hi everyone, I have an assembly deployed on my report server that contains a number of functions used by my reports. The assembly has full trust and all of the functions work fine except one. The purpose of this function is to query a database table for the correct connection string for the report datasource. The code that returns the connection string works correctly in a test windows app. When I run the report through report manager, I get the following error: Does this mean that a report server can only use the database where it stores its server information? This would be inconvenient and I would like to avoid it if possible. Also, I would prefer my assembly not to have full trust, and instead only have the permissions necessary to allow it to read from the database where the connection string information is stored. So far, I have found plenty of sample code describing the XML that I need to add to grant FileIOPermissions, but nothing on database-related permissions. Can anyone point me in the right direction? Thanks in advance, Ed Allison Tag: help!!...sp1 or sp2 Tag: 51965
  - 5
    - Complex Case Statement Hi, I have Score Field for each each month of the year like the following: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Goal 100 80 99 Score 99 100 89 - - - - - - - - - Form the database I hold the LatestMonth in a textfield. Say for ex, since this is March it is 3. I compare the Score value to a Goal Value and then set the color. The data for the remaining months won't be there. For those remaining months I need to set the BackgroundColor for the Score to "White". Off Course the LatestMonth may change to 4 after we publish the ScoreCard in April. How can I do this using Custom Code. Any help will be greatly appreciated.. Suresh Tag: help!!...sp1 or sp2 Tag: 51964
  - 6
    - Installing Report Designer I am developing an application with VS2005. We would also like to develop reports with this app. We will have SQL Server 2005 on a separate box as a development server. Is it possible to only install the report designer on my machine and not install the rest of SQL 2005? I have tried to only install the tools, but the checkbox for Reporting Services remains inactive and I am unable to select it. WinXP Pro SP2 VS 2005 Pro Also, is it something to do with IIS? I have not installed that service. Tag: help!!...sp1 or sp2 Tag: 51963
  - 7
    - SSRS 2005 Date Formats I am having problems with date formats in report manager. I am in the UK and want the dates displayed as dd/mm/yyyy. When I enetr the date in the parameter field it changes the month and day around and if I try to enter any number above 12 an erro is given. It ia also not picking up the correct date parts when using the day or month function. Any idea ho to solve these problems? Tag: help!!...sp1 or sp2 Tag: 51960
  - 8
    - Setting Default Printer for report I have one report that is only ever printed on one specific printer. In MS Access we could specify a printer for a report so when the print button was clicked the report would automatically print to our special printer (or default to that printer). In Reporting Services I am not sure if this is possible. This will be a huge pain for our users to have to switch the printer each time they run this report to print it. Any ideas? Tag: help!!...sp1 or sp2 Tag: 51959
  - 9
    - parameters with multi value and navigation Hello. I have a report with parameters include multiple value. I configure "Jamp To Report" under navigation and I would like to forward to a new reports the same parameters user select in the source report undel multiple value parameters. in the text box I use =join(Parameters!Ds.Label ,", ") but how can I forward the selected parameters to the new report Thanks Idan Tag: help!!...sp1 or sp2 Tag: 51957
  - 10
    - How to make sure background color on details group always start on the same color? Is it possible to control start color when doing alternating background colors on a details group in a table? If alternating between White and Green, I want the first detail row to be white, and the next green, regardless of row number. I've tried using both this expression: =iif(RowNumber(Nothing) Mod 2, "White", "WhiteSmoke") and this: = iif(RunningValue( Fields!MyField.Value, CountDistinct, Nothing) mod 2, "White", "WhiteSmoke") They both work, but they both seem to count row numbers, regardless of grouping. If I try using the detail group name instead of nothing, I don't get any color. = iif(RunningValue( Fields!MyField.Value, CountDistinct, "tbl_DG") mod 2, "White", "WhiteSmoke") Is it possible to control this? Any advise appreciated! Kaisa M. Lindahl Lervik Tag: help!!...sp1 or sp2 Tag: 51954
  - 11
    - Matching groupings on same page from different datasources Hi, I have a report that is layed out as follows: Table Header: Team Detail: Team data grouped by day (grouped in OLAP query) Grouping Footer: Totals per team Table Header: Team Detail: Team data grouped by week (grouped in OLAP query) Grouping Footer: Totals per team What I want to achieve is for each Team, 1 page displays the team totals by day and the team totals by week. I can get each table on a separate page, but not combine the same team for the daily and weekly data. Any help is much appreciated. Thanks in advance. Tag: help!!...sp1 or sp2 Tag: 51950
  - 12
    - Report manager error; The request failed with HTTP status 401: Unauthorized. Hi all, We have recently created a new deciated reporting server for reporting purposes to our outside customers. My problem is that whenever i try to connect from either the internet, or local to the Report Manager, the Report Manager such as https://secureserver.ourdomaincom/Reports responds with an error "The request failed with HTTP status 401: Unauthorized". However, connecting to https://secureserver.ourdomaincom/Reportserver works perfectly. Some facts about the server settings at this moment: * Windows 2003 Enterprise Edition SP1 * IIS is set to authentication Integrated Security, basic authentication (for reports & reportserver virtual directorys) * Reportserver was freshly installed. * The local domain user we use for admin & terminal server logon is in the adminstrators group. * In IIS is a valid serverside certificate. Clients dont need certificate. * The RSwebapplication.config has <ReportServerUrl>https://secureserver.ourdomaincom/ReportServer</ReportServerUrl> set up. * The RSwebapplication.config has SecureConnectionLevel=3"" set up. * In both the report manager and -server the <authentication impersonate="true"> in web.config. * For local NTFS security, the ASP.NET machine account have got read, write and execute right on both the \SQL Server\Reporting Services\ReportManager and -ReportServer directorys. * The Sql Server 2000 is on a remote machine in the same domain, set to mixed mode authentication. Here is a short cutout from the Reporting Services logfile <<<<<<<<<<<<<section start>>>>>>>>>>> w3wp!library!1770!3/29/2006-11:24:21:: i INFO: Initializing SecureConnectionLevel to '3' as specified in Configuration file. w3wp!library!1770!3/29/2006-11:24:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!ui!1770!3/29/2006-11:24:22:: e ERROR: The request failed with HTTP status 401: Unauthorized. w3wp!ui!1770!3/29/2006-11:24:22:: e ERROR: HTTP status code --> 500 -------Details-------- System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) <<<<<<<<<<<<<section end>>>>>>>>>>> In various posts on internet it seems that many other people experience the same trouble as per my description. I have been unable to locate a clear cut solution yet.. Possibley the trouble is apparentley possible the report manager webservice cant communicate with the reports webservice..? If you know an answer to my trouble then TIA! A similair post here on google groups is more-or-less the same as the problem experienced here. [url]http://groups.google.nl/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/d7195eaca3c8a0c5/c117ccba1064ee98?lnk=st&q=Report+Manager+401&rnum=6&hl=nl#c117ccba1064ee98[/url] Tag: help!!...sp1 or sp2 Tag: 51949
  - 13
    - Long report generation --> Cannot find server or DNS Error Hi all. I use some RS report with several Oracle queries. One of them is quite complicating and it's taking quit a long time to run it. While I generating report through RS2005 I get error: >>> Cannot find server or DNS Error <<< In Report Properites/Execution I've checked option "Do not timeout report execution" So, any ideas why I get error and how I can resolve problem? Tag: help!!...sp1 or sp2 Tag: 51948
  - 14
    - Deployment problem - Insufficient Rights Dear friends, problem with Deployment Reports to Server. when i click the deploy, i am getting the following error. The permissions granted to user 'domain/machinename' are insufficient for performing this operation. pls assist me. murali Tag: help!!...sp1 or sp2 Tag: 51940
  - 15
    - Where can download VS2005 Reporter viewer as tile, Please! Tag: help!!...sp1 or sp2 Tag: 51935
  - 16
    - NewLine and Carriage return issue in PDF format If I insert the following expression in a textbox it will display correctly in HTML format but not in PDF format. Can anyone show me how to accomplish the same thing so that it will display correctly in both HTML and and PDF format. vbCrLf & vbCrLf & vbCrLf & "My Text" In HTML format, it will display "My Text" on the 4th "row". Whereas in PDF format, it displays "My Text" on the first row of the textbox. Tag: help!!...sp1 or sp2 Tag: 51933
  - 17
    - SoapException: Invalid XML Hi, I recently converted a 1.1 .NET app which was using the SOAP webservice to integrate with SQL Reporting Services 2000 to .NET 2.0. After the conversion, I get the following error. I was wondering if someone has came across a similar problem. System.Web.Services.Protocols.SoapException: The input XML does not conform to the schema. XML grammar is described in the API documentation. For XML in reports, refer to Report Definition Language syntax. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidXmlException: The input XML does not conform to the schema. Tag: help!!...sp1 or sp2 Tag: 51928
  - 18
    - RS editions Is it possible to use Reporting Services 2000 enterprise edition with SQL server 2000 standard edition? We were using RS std. edition but found out that inorder to use Forms authentication we have to have RS enterprise edition. But now when I try to install service pack 1 and 2...it keeps giving me errors about database version not matching application version. So I would like to know whether I am getting that error because my RS version and SQL server version are different and whether I can use Reporting Services 2000 enterprise edition with SQL server 2000 standard edition. Also, If any of you have been able to successfully use Forms authentication to integrate RS into your application, please let me know what versions of RS and SQL server you use and what configurations you use to get it Forms authentication to work properly. Tag: help!!...sp1 or sp2 Tag: 51924
  - 19
    - Urgent, please help: Can not start Report Server Web Service for 2 I have spent several days trying to figure it out, I am out of options now. I have a SQL Server 2000 Standard, patched with SP4, installed on Windows Server 2003 SP1, I installed Report Server 2000 Standard edition (Report Server and Report Manager components). At the end of installation, I got a warning saying that I have to manually initialize Report server for the first time for it to work. But when I tried somethng like http://localhost/ReportServer, I received "Service Unavailable". I have made sure ASP .Net v1.1.4322 is registered with IIS (6.0 SP1), use Network Service account for ASP .Net, etc. From the event log, itsaid W3Wp encounterd an application exeption, there was no log for ReportServer. I really don't know what if going on here as it worked perfectly on another Windows Server 2003, the difference is that I has Visual Studio .Net 2003 installed on that machine, but I think VS is only necessary if you want to install Report Designer. I read through a lot of newsgroup, tried all those suggestions, but still not be able to fix it. Thanks in advance for any info. Tag: help!!...sp1 or sp2 Tag: 51919
  - 20
    - Please help: Can not start Report Server Web Service for 2000 I have spent several days trying to figure it out, I am out of options now. I have a SQL Server 2000 Standard, patched with SP4, installed on Windows Server 2003 SP1, I installed Report Server 2000 Standard edition (Report Server and Report Manager components). At the end of installation, I got a warning saying that I have to manually initialize Report server for the first time for it to work. But when I tried somethng like http://localhost/ReportServer, I received "Service Unavailable". I have made sure ASP .Net v1.1.4322 is registered with IIS (6.0 SP1), use Network Service account for ASP .Net, etc. From the event log, itsaid W3Wp encounterd an application exeption, there was no log for ReportServer. I really don't know what if going on here as it worked perfectly on another Windows Server 2003, the difference is that I has Visual Studio .Net 2003 installed on that machine, but I think VS is only necessary if you want to install Report Designer. I read through a lot of newsgroup, tried all those suggestions, but still not be able to fix it. Thanks in advance for any info. Tag: help!!...sp1 or sp2 Tag: 51918
  - 21
    - problem deploying report - can't connect to server? Hello, I am relatively new to reporting services. I was experimenting with some already developed reports on a workstation and trying to figure out how things work. The reports run fine, and I can deploy them from the solution folder where the reports exist. Then I tried creating my own report in my own solution folder. I was able to create a basic report with a paramenter and run it in the IDE. But when I tried to deploy it, I got an error message that the service could not connect to the server. Is this like asp/aspx where you need a virtual directory or something like that in IIS? What do I need to do to deploy my test report from my new solution folder? Thanks, Rich Tag: help!!...sp1 or sp2 Tag: 51917
  - 22
    - Excel Drill Down not showing all details In my report, I have one group and details. The group has two rows, with the 2nd row's visibility toggled by one of the textboxes in the first row. The detail row is also toggled by the texbox in the top group row. (the second row of the group has the titles above the detail row). Anyways, when this report is run, all of the details show as expected when you drill down. However, when you export this report to excel and drill down, only the second group row appears. None of the detail rows appear in excel. Is there a work around for this? Tag: help!!...sp1 or sp2 Tag: 51915
  - 23
    - Print Prompted Values in Filter Conditions Hi, I am hoping this is a stupid question but is there any way of printing a users entry when they are prompted for a filter condition at runtime? For example, suppose you have a date range filter on a report and you want to print at the top of the report the date range the user has entered at runtime. Can this be done in the Report Builder or must it be done in VS? Thanks in advance, Aaron Tag: help!!...sp1 or sp2 Tag: 51914
  - 24
    - Blank pages due to hidden columns please help! I have a report that has hidden columns based on the year. (If it is Mar--I only show J-F-M) But potentially I can have all 12 months. Because I am only showing J-F-M right now, the rest of the year is hidden but when I export to PDF the report is still accounting for those columns even though they are not shown, with blank space. Does anyone know of a work around for this? Tag: help!!...sp1 or sp2 Tag: 51913
  - 25
    - Dynamic Queries Errors in Report Manager I am trying to replicate the use of Dynamic Queries in SQL Server 2000 Reporting Services documented in the "Hitchhiker's Guide to SS 2000 RS." I have done everything the book has told me to do. I can build and run the project in test mode, and deploy to my test server (http:\\localhost\ReportServer) without error. I have already set up the datasouce for the application in the Report Server when I try to run the deployed project. Every time I run the project I get the following: 1) An error has occurred during report processing. (rsProcessingAborted) Get Online Help 2) Query execution failed for data set 'dsCustomers'. (rsErrorExecutingCommand) Get Online Help 3) Line 1: Incorrect syntax near '='. I think it's pointing at my Data set in my data tab, but am not sure why it will point there when it worked in test mode! Does anyone know how to fix this problem? Tag: help!!...sp1 or sp2 Tag: 51912

After I install SP1 of SP2 for reporting services, I get the following
error:

The version of the report server database is either in a format that is
not
valid, or it cannot be read. The found version is 'C.0.6.54'. The
expected
version is 'C.0.6.43'. To continue, update the version of the report
server
database and verify access rights. (rsInvalidReportServerDatabase)

I am currently running RS enteprise edition with SQL server 2000
Standard edition.
When I used to have RS std. edition with SQL server 2000 std.edition,
I've applied both service packs and didn't get the error.

Can you help me with this problem?

Thanks,

Top

Re: help!!...sp1 or sp2 by Robert

Robert
Mon Apr 03 17:37:58 CDT 2006

If you already installed SP2, you can not install SP1 afterwards and
you do not need to.

Service Packs are cumulative - they contain everything from prior
service packs.

bevarg wrote:
> After I install SP1 of SP2 for reporting services, I get the following
> error:
>
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.54'. The
> expected
> version is 'C.0.6.43'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
>
> I am currently running RS enteprise edition with SQL server 2000
> Standard edition.
> When I used to have RS std. edition with SQL server 2000 std.edition,
> I've applied both service packs and didn't get the error.
>
> Can you help me with this problem?
>
> Thanks,

Top