Answer Questions

• toben888 Add spaces to a string value in a cell

  Hi, I am trying to add spaces to a string value in a cell but when I run the report the value is trimmed. Any ideas Here is the expression I am using: = Fields!strVal.Value & " " Thanks, Igor Igor, What type of formatting are you trying to accomplish Are you trying to align text, columns Ham Igor, Can you wrap a LEN around your expression I used this to verify that the spaces where actually there. If the spaces are there then you made have some other issue. Ham I tried and it still comes out trimmed. Igor, You can try a couple of different things (what you have should work, but if not I can only suggest t ...Show All

• ThePatrickP Report Viewer Problem In ASP.NET 2.0

  Hi i have a problem using Report Viewer With SQL Reporting Services 2005. The problem is report toolbar is display but NO DATA is displayed and the report commes out as EMPTY :(. Even the parameters are passed successfully because i can see them in the text-boxes on the report parameters tool bar. But Report is Empty :(. I have the following code. ReportViewer1.ServerReport.ReportServerUrl = new Uri ( @"http://localhost/ReportServer" ); ; string reportPath = @"/MMM_MSRS/WebFormEvents" ; ReportViewer1.ServerReport.ReportPath = reportPath string cmp_id = "3803" ; string vcli_id = "23649" ; string cnct_id = "1" ; Microsoft.Reporting.WebForms. Repo ...Show All

• 13117 Cross assembly or cross domain calls not supported

  If I compile a simple .NET DLL with the following function and register it as an assembly in Analysis Services: public static int MyFunction(object o) { return 99; } When I run the following query I get an error which reads " Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored procedure CSng failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException. " with member test as MyAssembly.MyFunction(CSng("2.5555")) select test on 0 from ...Show All

• Sree Prakash SQL Server 2005 can't be added Active Directory, but the documentation says it can.

  Hi, I've installed SQL Server 2005 on Windows Server 2003 SP1 Standard Edition. Before I install SQL Server 2005, I've configured Windows to be an domain controller with Active Directory. As the documentation said that using Object Explorer and then selecting Properties, I have the property page of Server Properties. But I still can't find the Active Directory page. When I try to run the system stored procedure sp_ActiveDirectory_SCP, I can't either register or update. Is this an error or bug Using SQL Server 2000, I can easily add it to Active Directory. Now I can't do it in 2005 version. Please help! Eriawan Many thanks for your kind reply! I'll inform you whether it's failed or not. Eriaw ...Show All

• David J Oldfield How to insert and split out Parent/Child from string

  Knowing that my @Tab table variable returns data for example like this: ProductID (bigint)   ChildIDs (varchar string of comma delimited IDs) -------------                ------------------------------------------------------ 106731                     105234,105235,105236,105237,105238 107889                     101238, 422635,167236,105237,105974, 230554 108990             &nb ...Show All

• Foxer can't install a CLR stored procedure

  I have written 2 CLR stored procedures. I have a local copy of our database to which I was able to successfully deploy them. When I changed the connection string to our production database, it fails when I try to deploy. It gives me an error... EXTERNAL ACCESS ASSEMBLY permission denied on object 'server', database 'master'. I've logged onto the database server and set trustworthy on for that particular database. I also tried... CREATE ASSEMBLY UpdateJobAdSearch FROM 'I:\DLL\Candidate.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS Candidate.dll is the stored procedure dll. I also read on http://msdn2.microsoft.com/en-us/library/ms345106.aspx about doing something like.... USE master GO CREATE ASYMMETRIC KEY CandidateKey FROM EXEC ...Show All

• AJamil Error while executing reports from report manager

  Hi.. I have deployed reports on to the report server. When I try to open the reports from report server, I get the error," Value does not fall within the expected range." This error message appears as soon as I click on any report on the report manager. I am not able to find the cause of the error. Does anybody have any suggestions Thanks , Viva Viva1 Try checking your C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\web.config and make sure you have the below settings: <appSettings> <add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterfac ...Show All

• Netmaster0000 SSAS 2005 - Role dimension access can't assign 'None'

  I've seen a couple posts on this already so I'm hoping it's simple. I've created a simple cube in SSAS 2005 sp1 and created a role that I would like to customize access to specific dimensions, but in the role editor the Access pulldown only has 'Read' and 'Read/Write' options. I have gone through the dimension data editor and explicitly de-selected all on the dimension members and while the dimension data is no longer displayed the dimesion and members are still visible to the users. The documentation indicates that 'None' is an option for dimension access, but I'm stumped why it's not available in the editor. Thank you, Can anyone help us help!! ...Show All

• ultra03 Anyone know a self extracting tool for a zip file?

  I have a zip file that requires a password to extract the file inside of it. Is there away to do this automatically Can't find any software that does this. Mike Frank, What does the outcome look like in your expression above The spaces in the directory names can cause problems in a command line. from the help file: Wildcards or filenames with spaces must be quoted: "Dir\Program files\*" Dir\"Program files"\* Also need to make sure that the exe is being called from the correct path, or make sure that the exe is in your Path$. also, try to access the help file that came with 7-zip. There is a section titled "Command Line Syntax". This should prove to be invaluable. I'm not ...Show All

• tomwilde SSRS and Teradata

  Is anyone out there using SSRS with a Teradata data source R First on the date thing, I cheated. I made a function that changed the datatype to the Teradata specific format. Function FormatTeraDate(byVal aDate As Date) AS String return String.Format("1{0:yyMMdd}", aDate) End Function I probably didn't need to make it a function, but I am thinking about creating an assembly that will have wrappers for Teradata specific things. On the multi-value, I don't have a good answer. What I do have is a way that work without the ALL option. First, I changed the SQL for the data source to a dynamic string ="SELECT Fld1, Fld2 FROM TBL1 WHERE " WHERE Fld1 in ('" & Join(Para ...Show All

• Tsur Problem Printing local report in Sql reporting services

  I have a local report for which i am binding the Dataset dynamically. I am trying to print this report using a seperate button on the page. I saw in the forums saying that the reportviewer can be converted to an EMF file, bind this to an image control and can Print this image using Javascript. Can anyone help me with the sample code to print local report from the reportviewer (it may be in any approach.) Thanks in advance. Sekhar T What type of printers do you have What are the print drivers I am using reportviewer in local mode, where i am not using sql reporting server. what i meant saying different connection strings is for different business objects from different databases in sql server ...Show All

• Bob Pokorny .ReadInnerXml not returning native entire document?

  what am I doing wrong here in terms of how I am reading the xml doc's contents .InnerXML must be placing additional chars into the string. The funny thing is the document on the file system i am reading had it's content come directly out of the same table I am wishing to insert it back into Thanks guys sqlclr procedure... using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; using System.Xml; using System.Diagnostics; public partial class StoredProcedures { [Microsoft.SqlServer.Server. SqlProcedure ] public static void usp_ProcessResumes() { using ( SqlConnection oInProcessConn = new SqlConn ...Show All

• MMCompton How to cotrol format of datetime attributes?

  There is an attribute that have type DateTime, based on the field type in data source. It hasn't separate name column. The member caption is formatted as yyyy-MM-dd hh:mm:ss. Can I control the format of Member name without giving separate name column. I assigned different format in the format field of key property window, but it had no effect. What I did wrong Thank you, I thought about more sofisticated solution, that can be used in multi culture environment without adding x additional fields with "formatting" of a datetime attribute. I hoped, that the AS2005 is smarter as AS2005 and offers more possibilties. Do you know what is the format field in key properties for ...Show All

• niallhannon Multicolumn Report

  Hello, I have a report that has 2 fields only and takes about 4 pages. I want to create a multicolumn report so, it would not take more the 2 pages. I went to report properties, layout, changed number of columns to 2 and it does not work. Am I missing something here Could anyone help me, please Thank you. It is not exceeding 8.5. I can print or print preview this report the way it should be but it is not displaying correctly. This report will be viewed mostly, not printed. How can I view it correctly Thank you. When you use the column feature you can only see it in pdf. Try viewing it in pdf. Igor, Your total width of ...Show All

• kuria Calling Stored Procedure from SSIS

  Hi I am trying to call a stored procedure which akes 1 input param from SSIS. I am using Execute SQL Task->Expressions->"exec s_Staging '"+ @[User::tblName] +"'" @[User::tblName] is the variable with Data Type:String ,Value:My_table SQLStatement->Stored Procedure Name But It throws an error [Execute SQL Task] Error: Executing the query "exec s_Staging 'My_Table' " failed with the following error: "Incorrect syntax near 'My_Table' ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Hi, Try this out : "exec ...Show All