MSP.Saami's Q&A profile

• SQL Server ParallelPeriod MDX function not working

  I created a calculated measure called [Previous Year Percent Rejected]. I used the following expression: ( ParallelPeriod ([Year],1,[Time].[Time Hierarchy]. CurrentMember ),[Measures].[Percent Rejected]) The syntax checks out fine. However, when I try to use the calculation, I get an error message -- with a #VALUE! in the column. The error message reads " The parallel period expression expects a level expression for the argument. A hierarchy expression was used." I tried many different variations but I'm always receiving the same message. Any suggestions David If you're using AS 2005, the problem could be that there is also an attribute hierarchy associ ...Show All

• Windows Forms Windows forms with database

  How to populate data from database to windows forms and save as xml file with TABLE's AUTONUMBER as the file name. you can fill a dataset with data from the database using a DataAdapter for your connection (SQL or OleDb) and then save the data using the dataset WriteXml() method. There are many examples on these forums on filling a dataset from a database query   it would also help if you specified what language you are using to develop with as well as the framework version ...Show All

• SQL Server Upgrade PDF version from v1.3 to v1.4

  Hi Can the PDF version in Reporting Services 2000 or 2005 be upgraded to v1.4 from the current version v1.3 We have certain reports that are generated from RS 2000 in PDF v1.3. We need these reports to be generated in PDF v1.4 so that these reports could be read and modified by some other 3rd party tools. Do let me know if this is possible. Thanks, Rita Hi Rita, There is no way to change the version exported for PDF rendering. Changing the version would be a large undertaking. We are looking at this for future versions of Reporting Services. ...Show All

• Visual C# using Word = Microsoft.Office.Interop.Word

  Hi, I am having problem with the [Interop] word I was prompt for not exist. are there any reference I should add jbattat I dont see any error in your code for object initialization. I would suggest you the following to change; 1.When Application is set to invisible then document should be also invisible. ( i.e in your case for doc1, Object visible=false; ) 2. I dont see any usage of this code; doc1.CheckSpelling( ref optional, ref optional, ref optional, ref optional, ref optional, ref optional, ref optional, ref optional, ref optional, ref optional, ref optional, ref optional); Because, you are getting error count from the Proofreading object. Better would be comment ...Show All

• SQL Server strange lookup behavior

  I have a data flow two lookups components (call them lookup1 and lookup2). They both query the same relational table but with different values. Each has a single row result set containing one column and the each of the two columns is mapped to a corresponding package-level variable. The original data flow sequence had lookup1 executing after lookup 2. Each component redirects errors to a separate text file. Lookup1 succeeds but lookup2 fails on every row which populates its error text file; however I can construct a sql query from the lookup2 values that returns the expected result. If I reverse the sequence of components (lookup2 followed by lookup1) lookup2 still fails on every row. Whenever both lookups are present in the dataflow ...Show All

• SQL Server Can I add a record number as data passes through

  Hello. In SSIS, is it possible to add a record number to each row of data as I copy it from the source to the destination. An example of my source data is below, For each MemberID want to record the number of times it occurs in the table.  MemberID 2898  2899 2899 What I want it to look like when it gets to the destination is: MemberID     RecordNumber 2898     1 2899     1 2899     2 Like an Identity column I suppose, not for the whole table but for each MemberID. Thanks     bobbins wrote: Ok, the component works great but it is not putt ...Show All

• Windows Forms Binding to a Business Logic Layer

  Hi, The question is more for designers and architects. The question is about working with data, specifically about Binding to a Business Logic Layer. With introduction of typed datasets in .net 1.0 and especially in .net 2.0 I started to ask myself - isthat really necessary to create a class that is a mapping for a db table. I will explain what I mean. Take for example database pubs , table authors. With basically one click VS2005 creates for you a typed dataset, let's call it authorsDataSet , which incapsulates a complete object model of authorsDataTable , authorsDataRow and even multiple tables with their relationships. Notice that authorsDataRow IS an complete object model of an author. Besides, there is a authorsTableAdapte ...Show All

• Visual Studio Express Editions VB6 - VBExpress

  Does VB6 coding work with VB Express 05 I'm guessing it doesn't as it isn't work for me I'm trying to follow this tutorial (http://bot-depot.com/about2022.html - Couldn't post a hyperlink for some reason)  but: 1) I can't find "Messenger AddIns type library" in the add resource list. 2) The code Produces errors. Any help is greatly appreciated. Maybe this old sample on GotDotNet will help. ...Show All

• Visual Studio Tools for Office multithreading - aysnchronous - workers in VSTO solutions?

  I'm looking for documentation/guidance on using additional threads in VSTO task pane solutions (Word). Is this supported Are there limitations Are there examples / best practices We have a large app and we are trying to leverage bakground threads for some longer running processes, but running into some unexpected behavior (like Word crashing under certain circumstances). Hi There are really no documented scenario's that are relating to threading within VSTO, one of the main areas to bare in mind is that you are marshalling between COM and Managed Code and as such there are already threads running for UI elements and as such would suggest you highlight specific issues you are having for review. Generally ...Show All

• SQL Server Dynamic queue receive sql ?

  Hi There My activation sp must be able to read of various queues. I load a variable with the queue name that activated the sp btu i cannot get the syntax working to receive or get a conversation group of a queue name that is a variable. I have tried: WAITFOR ( RECEIVE message_body , conversation_handle , message_type_name , message_sequence_number , conversation_group_id FROM @callingQueue INTO @msgTable WHERE conversation_group_id = @conversationGroup ), TIMEOUT 2000 ; But i get this error: Incorrect syntax near '@callingQueue' . Looks like you cannot use a variable. So i tried the following: SELECT @SQL = N' WAITFOR ( RECEIVE message_body, conversation_handle, message_type_name ...Show All

• .NET Development Ultra-fast deserialization/serialization

  Hi, I'm wondering if there is a way to speed this up: I have objects that implement the following methods: public void Serialize(System.IO.BinaryWriter writer) { writer.Write(this.price); writer.Write(this.size); writer.Write(this.dateTime.Ticks); } public MyObject Deserialize(System.IO.BinaryReader reader) { return new MyObject(reader.ReadDouble(), reader.ReadInt32(), new DateTime(reader.ReadInt64())); } That's what I use for serialization & deserialization. Currently I manage to write 10,000,000 objects in 5.5 seconds, however my Raid 0 drives can write up to 140MB/s, so I think there should be some upside left (10mio objects result in 195MB file). I guess the problem is that the .Write ...Show All

• SQL Server Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

  I Have been doing the sql server 2005 report builder lab and got to step 5: deploy the report model project and got this error. TITLE: Microsoft Semantic Model Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head><title> Untitled Page </title><link href="Styles.css" rel="styles ...Show All

• Windows Live Developer Forums VEMap.GetMapView Method

  Hi, I'm trying to maintain the state of the map during postback and found a nice thing: VEMap.GetMapView() This could be an easy way to do it, but I cannot find any detailed documentation, about the object that is returned... ! The only sentence I found is: "Returns: An object that represents the current map view. " (http://dev.live.com/virtualearth/sdk/Ref/HTML/M_Namespace_VEMap_GetMapView.htm). Maybe someone can help me to get a few infos ! ! - thx cheers hafi23 How would you go about doing this with a BirdseyeScene Is there a way to determine the LatLong's of the top left and bottom right of the scene, similar to what you can do with the normal map I've tried using something like this, but it doesn't seem to be wor ...Show All

• SQL Server =Sum(ReportItems!FinalCost.Value, "group_1") in group footer problem

  Hi, Im currently writing a report in SSRS which requires to take data in the fields, manipulate and perform functions on it then display it within its own textbox. For example the field Cost is manipulated so that a column will show the cost depreciated after 5 years. Cost Final Cost 500 250 1000 634 700 500 Footer: Totals 1384 My problem is that within each group (as the data is grouped by its type) I need to have a sum of the Final Cost data. As this is NOT a field I cannot use =Sum(Fields!FinalCost.Value, "group_1") but rather I need to use =Sum(ReportItems!FinalCost.Value, "group_1"). I know that SSR ...Show All

• Internet Explorer Development Is this the correct forum ??

  Hi All, I'm new to this forum and IE/Jscript development. From the welcome message, I thought it was a IE/Jscript development forum. Can some please point me to a good IE/Jscript forum where questions about activex/Jscript and Jscript/IE can be answered I don't want to waste a bunch of time on Opera and Firefox resolutions or run the gauntlet of anti-IE comments. I have posted 2 technical Jscript questions, but no developers responded, well one did and he was in about the same position I was on the one subject. Looking at most of the other questions posted and the subsequent responses, this forum seems to be geared more towards IE administration than develpment. Info on registry entry changes, dll versions, patches... This ...Show All