Answer Questions

• Shan Ganesh Error on Export to Excel with Bookmarks and Navigation Jumps

  Hello All, We're running RS 2005. I have a problem in a report using two main sections. There's a top level report, made up from 4 tables within a rectangle. The second section of the report contains the detail of the calculations making the top level figures. The second section of the report contains bookmarks and jump links to drill to different levels of the reporting structure. This works fine. The top level of the report also has jump to bookmark links to drop into the relevant section of section two, and display the detail. The problem I'm having is that although the jump links work fine within report manager, the report will not export to excel from report manager. It errors with the error at the bottom o ...Show All

• Dinesh Patel R

  When I am using aggregations design wizard it is stopping at 49%, even through I am asking to go for 100% performance or choose until I stop option. This happens only to one cube, for other cubes wizard works fine. What could be preventing the wizard not to reach 100% Thanks. I am using SQL 2005.  You are right about not needing 100% aggregations in most situations.  My question still is why the wizard not reaching 100% performance.  Is this a bug   Is there any way I can calculate how many aggregations will be for 100% pre aggreagations   If I can calculate that number then I would know if the wizard is showing less than 100% but it actually got all the aggregations. Thanks. ...Show All

• jkirk What is the best way to get the primary key column name of a table in a stored procedure ?

  Hi, I'm writing a stored procedure which manipulates a table whose name must be given as a parameter. The stored procedure needs the primary key column name (by design the primary key must have only one column), and I thought I could get this from the system table instead of having to provide it as a parameter. So I need to put the primary key column name in a variable. The best way I found so far is this : declare @keyname nvarchar ( 1024 ) create table #keys ( table_qualifier nvarchar ( 255 ), table_owner nvarchar ( 255 ), table_name nvarchar ( 255 ), column_name nvarchar ( 255 ), key_seq integer , pk_name nvarchar ( 255 )) insert #keys exec sp_pkeys @table_name = @tablename select @keyname = column_name f ...Show All

• vgvKarthik Using a native printer font in Reporting Services

  I use Crystal reports to send faxes via RightFax. To do this, the report prints to a RightFax printer - AND the embedded RightFax codes in the report must be in a native printer font (non-true type font) for RightFax to "read" the fax number, contact, etc.. Evidently SSRS does not support native printer fonts, as I can't even see them in the font selection and, when I type the font name into the textbox properties, it is ignored and a true type font is substituted. Yes - I have the fonts installed; in fact, in Business Intelligence Development Studio the native printer fonts are available under Tools...Options to use for Text Editer. How can I use native printer fonts in SSRS This is very important as the report faxes to over ...Show All

• furmangg Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

  Any help would be very very much appreciated as I am about 15 hours into this :( Background is a development system with ASP.NET 2.0 and SQL express 2005. The server is SQL 2005 standard edition. Any ASPX pages that connect to a database results in errors. I have 2 identical servers with Windows server 2003, one has SQL Express and the other has SQL Server 2005 standard. that is the only difference between these systems. The scripts that work seamlessly when uploaded to the SQL Express server dont work on the SQL Server 2005 My connection string is  <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Datasource=servername;Integrated Security=SSPI;initial catalog=C:\INETPUB\WWWROOT\test\ap ...Show All

• kabukimaster How can I verify the availability of an SQL server

  Hello everyone, I have an ASP application mainly connected to one SQL database that works great but now I am trying to add some functionality that requires to connect to another remote SQL server. Till now all is fine except that the remote SQL server is not always online and of course when this happens my ASP application stops with the following error: Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. in my Global.asa I setup my session variables for DSN connections and in my pages I call my SQL connection as follow: Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open Session("MySQL") SQL = "my SQL stat ...Show All

• wannabguru How do can I do this?

  Hi, I have this table: colA ; colB 1) 1 2 2) 2 1 3) 2 6 4) 3 6 5) 6 3 6) 6 7 7) 7 6 and I need to select from it only the rows that do not have an opposite pair, i.e. only line (3) as it is 2 - 6 and there is no line 6 - 2, all the other lines have opposites, like line (1) 1 - 2 has line (2) 2 - 1 and line (4) has line (5), etc. any ideas thanks. Thank you, Alan; you caught me. I have missed the EXCEPT join at least once before, too. Please keep after me until I get it right. :-) Dave SELECT b . id , b . colA , b . colB FROM mytest b WHERE b . id NOT IN ( SELECT a . id FROM myTest a INNER ...Show All

• AndyJ_PS If WCF can communicate with ServiceBroker?

  hi, I want tomake wcf and service broker communicate with each other,Are there some resources about that thanks in advance Is this a sample you are willing to share Absolutely. Any preference on where to put it It's not the most amazing work in the world, but certainly it's a starter for ten for anyone looking to bring these two great technologies together. Hi! Can you please let me know the solution, as I also have to use this To be more precise with my problem, I have to extract data from WCF-NET.TCP. I think by using Broker services we can get the data into SQL Server. Can somebody please throw some light ov ...Show All

• JakeBree SQL Server 2005 connection

  Dear All, While I am connecting to my server, Its showing error.. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider) Could anybody can help me!! The complete details as : TITLE: Connect to Server ------------------------------ Cannot connect to SMAHROOF\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this ...Show All

• Ion101 Generate script of ALL database objects

  I need to be able to programatically generate the CREATE scripts for all objects for a given database. Basically, I need the same results as if I generated the script using SSMS and choosing to script all objects in the selected database. I'm hoping I could do this using the Scripter w/in the SMO Utility Classes. Can anyone help me out Thanks in advance! Hi, use the transfer method of the scripter: http://blogs.msdn.com/mwories/articles/smosample_transfer.aspx HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Well, yes, I see your point, but then wouldn't I have to write a decent amount of conditional code to to determine if I need a "GO" line or ...Show All

• Jamie Thomson Line Chart in RS - simple design question

  I have a simply data file that I want to make a time-based line chart and I can't seem to get charts in RS to do it. The data file structure is as follows: (first line is column labels and each row is a case with three data points - one for each year) school 2003 2004 2005 SchA 100 122 133 SchB 121 145 115 SchC 98 112 120 I can't seem to get the right series, category, and data fields to get a very simple line chart for each school (one trend line for each school connecting the three data points all one the same chart). It's trivial in Excel and using pivot tables, but RS charts is not structured the same way. The fields in the SQL result set returned are School ...Show All

• aybe Presentation Problem

  Hi all kindly help me with a solution i have the following result Total Users 474 Total registration for 20/12/06 90 No of Avtive Users 235 Users Who Opted for MS 62 Users Who Opted for WL 154 But i need to display it as Total Users New Registrations No of Active Users Users Who Opted for MS Users Who Opted for WL 472 88 234 62 153 in short i need to display the rows as columns and columns as rows Thanks in advance Jacx Thanks for the solution Jacx If there is single set of rows on your table then the following query will work..(SQL Server 2000/2005)   - ...Show All

• wessen AS 2005 and OWC10 pivot table fieldlist problems

  Hello, I have an AS 2005 cube set up which I can connect to via OWC10. I would like to try to reorganize the fieldlist and group the dimensions. The problem is I don't seem to have much control of the field list. For example; in the code below, the first alert box displays 23, yet the second alert box within the loop is never executed. Why am I unable to loop through the fields in the fieldset Also, I think the best thing for me would be the ability to replace the fieldlist with my own fieldlist, but how do I do this so the user can still drag things from my fieldlist to the pivot control Thanks. (jscript) pTable = Form1.pivot alert(pTable.ActiveView.FieldSets.Count) for (var fSet in pTable.ActiveView.FieldSets) { alert(f ...Show All

• sticksnap How to split a transaction table to create training and testing set for AR

  Hi all, I have a transaction table that has a composite key made up of transaction id and product id. where multiple products were purchased under same transaction, transaction ids got repeated. I would like to split the table randomly into 70%, 30% ratio to create training and testing set respectively in such a way that it does not split a same transaction under which multiple products were purchased (rows with same transaction id should not get split). is it possible if possible what is the idea It would be of great help. Thanks. Fakhrul Hi Bogdan, In the said Transaction table, all transactions contain multiple items. The table need to be randomly (unbiased) split into two sets with ...Show All

• fbalas Lack of vbscript support for SMO?

  It is my understanding that Microsoft is abandoning support for vbscript by not giving it full SMO compatibility. Is that true Are my years of vbscript programming and all those scripts now a dead end What will Microsoft abandon next What do I tell my employer about his plans to migrate to Sql Server 2005 I'm not quite sure what you mean by including PowerShell "as an option for stored procedures." I've successfully converted a number of my VB.Net SMO programs into PowerShell scripts, and recently presented a session at our local SQL Server Users group on using PowerShell to access SQL Server. It works great. For example, to create a database using my own guidelines (rather than the defaul ...Show All