Answer Questions

• Alagu Thirunavirkarasu Rookie needs help with what to do after installation.

  Any guidance to get me off the ground would really help Are you trying to install SQL Server Eval edition If so, after install, launch Books Online (the documentation) and read a bit of the intro there. That can help you get started. Thanks, Sam Lester (MSFT) After you have installed what If you are talking about Visual Studio and programming... Examples are some of the best way to learn. Check out some of the VB/C# examples for the basic operations or some more robust examples as found in the Starter Kits . Also there are 101 Samples for Visual Studio 2005 which is a robust, initial development tasks to more involved tasks for winforms, web development etc. This is the answer to this ...Show All

• JillN Analysis Server database stop responding...

  Hi, everyone, I'm new in SSAS... Yesterday I mapped a new hierachy to a perspective and then the database died... I tried to connect to it in Visual Studio and open it in Management Studio, however, neither responsed, then the delay notification appeared... Database engine and analysis service are alright, the tables are quite small (less then 50MB). Dose anyone have ideas about this Thanks a lot. The version of my SQL Server is 9.00.2047.00, runs on Windows 2003 Server SP1. Ed: Thanks for your reply. I think I've found the reason. This is not caused by my modifications on the SSAS db, one of our databases grew too fast and makes the server running slowly, our DBA has solved this proble ...Show All

• Uranya Turning off "Select All" in SP2

  Does anyone know if there is an easy way to turn off the "Select All" option from appearing on reports with multi-selects I am going to have a hard time getting the development staff to update all of our reports AGAIN after making them conform to SP1. Please let me know if there is a way before I install SP2. Thanks. This is my last attempt. I am BEGGING for a Microsoft representative to just tell me one way or the other. If it isn't possible, just let me know so I can get the developers started on a new copy of all their reports. I would like to do that knowing that it is my only option. Thank you. I am interested to know also. Thanks ...Show All

• MauriceSibrandi HELP!I'm not clearly that why the query string both in codes and a report(rdlc) file?

  http://msdn2.microsoft.com/en-us/library/aa337091.aspx Viewing Reports in Local Processing Mode The following example demonstrates how to render a report that is part of the Windows application and has not been deployed to a report server. This example also uses the Sales Order Detail report from the AdventureWorks Report Samples project. To add the Sales Order Detail report to a Web Site Open the Web Site that the report will be added to. From the Website menu, select Add Existing Item . Browse to the location where the AdventureWorks Report Samples project is installed. The default location is C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples\Adven ...Show All

• shishio displaying % in value

  Hi I am calculating percentage using expression. I want to display % at the end of the result. If I use P1 or P0 somehow it multiplies the result with 100 I guess. Here is what my calculated value is 15.384515 and I want to display 15.38% Using P1 or P0 I am getting 1,538.5% How can I get the desired result Any help would be appreciated. Regards Amit Yeah I always thought that was funny the way RS handles formating %. You can try dividing your value by 100 and them formating it. I think the percent format requires a number between 0 and 1 e.d =format((field.value)/100,"P0") that should give you "15%" Hi niallha ...Show All

• Tryin2Bgood How to Refresh a Data Source View and autogenerate/Re-Deploy the corresponding Report Model

  Hi everyone!, Our team is new to SSRS and we are trying to figure out how to refresh the data source view, autogenerate the corressponding report model and Re-Deploy the Report Model (rewrite existing Report Model) on the server on a periodoc basis or trigger the whole action whenever there is a change in the database on some specific tables. We prefer to do this action through a Agent job ( a diff approach is also welcome). Are there any stored procs out there Appreciate your time. -PN Hi, My project requirements goes the same way. I was trying to refresh the Report Model in the way mentioned by Teo. But the GetModelDefinition will fetch the report model SMDL. How to get the ...Show All

• U_T_A Remote connection failed, even with proper configuration

  I am unable to connect to a SQL instance on the server from a workstation on the same network. SQL Express SP1 is installed on the server, and allows mixed authentication. The instance name is <SERVERNAME>\SQLEXPRESS. Both the Database and Browser services are running. Local and remote connections are enabled under SAC. I also used sp_configure to make the same changes. All Protocols for SQLEXPRESS have been Enabled using the Configuration Manager. The firewalls on both machines have been disabled. Rebooting the server or restarting services after various changes hasn't affected the outcome. Local connections made directly on the server are always successful using either authentication mode. SQL Native Cl ...Show All

• Please help with my query. How to change default database 'root directory' ?

  Hi folks, Can you please tell me how should I change the default root directory (used for db storage) in SQL 2005 Std. Edition. Currently its configured to: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL and I want to change the drive letter here. Thanks in advance. Cyk -- Try this: declare @SmoRoot nvarchar(512) exec master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE' ,'SOFTWARE\Microsoft\MSSQLServer\Setup' ,'SQLPath' ,@SmoRoot OUTPUT print 'Old root dir: '+ @SmoRoot set @SmoRoot = ' C :\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL ' exec master.dbo.xp_instance_regwrite 'HKEY_LOCAL_MACHINE' ,'SOFTWARE\Microsoft\MSSQLServer\Setup' ,'SQLPath' ,REG_SZ ,@SmoRoot exec master.dbo ...Show All

• Meng CHew Error installing SQL Server 2005 editions on Windows VISTA

  There are numerous posts regarding this error when installing SQL Server 2005 on Windows Vista RTM thus I am starting a new thread in order to get resolution one way or another: SQL Server Setup failed to execute a command for server configuration. The error was [SQL Native Client]Windows user or group "\USERNAME\SQLServer2005MSFTEUser$USERNAME$MSSQLSERVER" not found. Check the name again... The error occurs when installing SQL Server 2005 Developer Edition, SQL Server Express SP1, SQL Server Express SP2 CTR (with or without the SP2 Toolkit package installed beforehand). The error occurs with or without UAC. The installation then fails. Please advise if you have any insights. SQL Server Express SP2 CTR was announced as a workable v ...Show All

• DQM 2 Records in one page

  Hi.. As my subject indicate, does anyone have any idea on how to display two pages of report in one page I mean, for example you have a report that generates a certificate of a certain student. I sort of need to display 2 certificates in one page only. It'll be easier if its the same record but no, i have to display 2 same report bearing different records. Can anyone help me with this Thanks in advance.. ...Show All

• webrod No CSS property for textbox?

  We want to use our styles say "mystyle" on a report. I am surprised that we do not have cssstylename as a property for a textbox Ideally, i should be able to add that style in the styles.css file and reference the style name on the textbox. All that would be needed is that it would add an attribute to the rendered html. I wonder if it already exists and i am missing some information CSS is not supported in the current version. Hopefully it will be there in the future Is this feature available..or does any one have a work around I need this feature to give developers created template so that they need not change the font of each control whenever they create a new report. Thanks, SqlNew ...Show All

• Raulsassaa Error in SSRS Expressions

  I am having an expression which is supposed to give me the values selected in a multivalued input parameter. I have tried following options however everytime it gives me error. Could someone let me know what might be the issue here. 1. Expression : =Parameters!i_Category.Label Output: The Value expression used in textbox ‘textbox47’ returned a data type that is not valid. 2. Expression : =Parameters!i_Category.Label.ToString() Output : System.Object[] 3. Expression: =CStr(Parameters!i_Category.Label) Output: Error: Conversion from type 'String()' to type 'String' is not valid. Thanks Ian. It helped me a lot. Take a look at this link for more information about parameters and working with multi-va ...Show All

• Enkht SQL reporting - An internal error occurred on the report server. See the error log for more details. (rsInternalError)

  I have created an RDL file programatically. When I execute the code I get the error as mentioned below: Error: Sub report cannot be shown. An internal error occurred on the report server. See the error log for more details. (rsInternalError) When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result. Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer. Any Suggestion/feedback is highly appreciated. Thank You. The code of the sample RDL is shown below: < xml version="1.0" encoding="utf-8" > <Report xmlns=" http://schemas.microsoft.co ...Show All

• Bnjneer Procedure expects parameter which was not supplied...?

  I have this SP definition and below that the code to execute it from .Net. But I'm getting this error: Procedure 'GetNewId' expects parameter '@Key', which was not supplied. Saw an solution on some site which said to set the value of the output param to NULL before calling it, but that didn't do anything. Anyone have any ideas why this may be happening Thanks in advance. CREATE PROC GetNewId(@TableName varchar(32), @Key bigint OUTPUT) AS Declare @NextKey bigint BEGIN TRAN SELECT @NextKey = NewID from ID where TableName = @TableName IF (SELECT @NextKey)IS NULL BEGIN INSERT INTO ID(NewID, TableName) VALUES(0, @TableName) END UPDATE ID SET NewID = NewID + 1 Where TableName = @TableName SELECT @NextKey = NewID from ID where TableName ...Show All

• JohnBurton using query read xml from a xml datatype column

  hi, i have a table(t1) with column (c1 int, c2 varchar, c2 xml) i want to read the xml data in the column (c2) from the table t1 using query and insert into a #temp table please help me out, Sunila Hi below is an example using XQuery which is available to use in SQL 2005 create table jsTEST ( c1 int , c2 varchar ( 256 ), c2x xml ) insert into jsTest select 1 , 'test' , N '< xml version="1.0" encoding="UTF-16" > <Fruits><Fruit><FruitName>Orange</FruitName><FruitDescription>Round Citrus</FruitDescription></Fruit> <Fruit><FruitName>Bananna</FruitName><FruitDescriptio ...Show All