Neotec's Q&A profile

• SQL Server Lots of stats based on one database table

  Hi, I'm new to reporting services and this is a very general question. I'm working on a large sales stats report with many results. I want to be able to compare many results for two dates. These results include, average sales value per day, average sales per weekday, sales with payment received, etc. So basically there is lots of analysis needed mainly based on one database table (a fairly standard orders table). What seemed the most logical thing to do is get all the relevant order rows for these two date ranges, A and B, and append a period column to the results, and then do all the maths/aggregate functions in Reporting Services. Thus only having to connect to database once. And use a matrix with date period columns. So m ...Show All

• Windows Live Developer Forums Messenger Plug Inn Question

  Hi I wrote a plug in for messenger, it is very simple. It is compile ok, and i install in Messenger. All seems to be ok but it doesn't work. What's wrong I use strong name assemblie Thanks Here is the code: using System; using System.Collections.Generic; using System.Text; using Microsoft.Messenger; namespace AnswerMachine { public class AnswerMachineAddIn : IMessengerAddIn { public MessengerClient m_client; public void Initialize( MessengerClient client) { m_client = client; m_client.AddInProperties.FriendlyName = "Answer Machine" ; m_client.AddInProperties.PersonalStatusMessage = "Envia un mensaje" ; m_client.AddInProperties. ...Show All

• Smart Device Development WM 6.0 - Better handling for managed to unmanaged?

  I was just wondering if 6.0 kept the same model for handling unmanaged to managed code or if anything better had been thought up. Anyone know Hi JR, There are no plans to change the native->managed features in any upcoming release of NetCF.  Our model is fairly consistent with the desktop framework--the biggest difference is that we don't support native hosting, so all calls have to originate from managed code.  I'd be very interested to hear what features you would like to see to added or improved. Thanks, Ryan Chapman .NET Compact Framework ...Show All

• Windows Forms packaging sql server express with .net application

  how can i include sql server express and required database in my setup project Thanks You can set the prerequisity on SQL Express in the setup project properties. So when installing application a message will popup with information and a link from where it can be downloaded. For database, you need to pack .mdf file and also .ldf file. Probably your ldf file is big so it's better to create a new one before packing it. You can pack only .mdf file, but you will have problems with next installations. ...Show All

• SQL Server Drillthrough Query

  I have the following Drillthroug query. i require it to return only those documents that fall within a given date range for a particular customer and worktype. But all the records for a customer and worktype are returned irrespective of the date DRILLTHROUGH maxrows 10000 SELECT [Measures].[TAT] ON 0 , ([Hierarchy].[CustomerName].[ABC], [Hierarchy].[Work Type Name].[EEG] ) on 1 FROM ( SELECT ([Date].[Short Date].[2004-03-15] : [Date].[Short Date].[2006-04-10]) ON COLUMNS FROM [DW]) Return [$Customer].[CustomerName] As [CustomerName],[$Measures].[TAT] AS [TAT],[$Document].[Document ID] AS [Document ID] Hello Reena, First of all bad news: AS 2005 doesn't allow DrillThrough to be performed ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. internal WindowsGameForm class?

  Hi, I was perusing the XNA framework assemblys with Lutz Roeder’s .Net Reflector and noticed the following internal class. internal class WindowsGameForm : Form Name: Microsoft.Xna.Framework.WindowsGameForm Assembly: Microsoft.Xna.Framework.Game, Version=1.0.0.0 Are you considering exposing it in a similar way as you did with GameWindow (i.e. GameForm) This class would seem to satisfy the requests of many people for the abiltiy to use Windows Forms and XNA together (if they want to). This would be especially useful for things like tools, demos, and run-time control of the game using the RAD controls provided by Windows Forms. Right now, I am abl ...Show All

• Visual Studio Express Editions RichTextBox Images Can Stretch

  Hi, I'm using the paste method to insert images in a RichTextBox, the trouble is the user can stretch the images by dragging them with the mouse. Is there anyway to stop this behaviour Or is there another way to insert images into a RichTextBox control that pastes the images with fixed dimensions Well, I take back everything I said. After some more testing, I see that I am able to resize the picture. (It threw me initially because the 'grab spot' is hard to grasp in some places and the cursor never changes shape.) ...Show All

• Visual Studio Problem with dynamic report generation

  I have designed report with A4 size paper and landscape orientation. I have also inserted 10 parameter fields in this report. And then I have entered field values and field titles dynamically with coding. it is working find till now. But I want any no of fields (may be 50, 100 etc) to appear in my report and I should be able to insert these fields dynamically. Also i want only 6 fields on each page, other fields should appear on next page and so on.... Can anybody help me out.... Thanks in advance... I can not help you.. but I've a problem with dynamic report generation. On Form_Load I write this code: Private Sub FormReport_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .L ...Show All

• Windows Forms Need Help for DataGridViewComboBoxColumn

  Hello I have got a problem regarding DataGridViewComboBoxColumn. I have a form and on that form I have put a DataGridView Control. In the DataGridView control I have two DataGridViewComboBoxColumn columns. The first ComboBoxColumn will contain the ID and container type which has been retrieved from databse and got populated using structdata and next ComboBoxColumn will be populated based on the selection of the first ComboBoxColumn. I have done this the following way.. public struct StructData { public string DisplayMember; public string ValueMember; public StructData( string _strValueMember, string _strDisplayMember) { DisplayMember = _strDisplayMember; ValueMember = _strValueMember; } ...Show All

• Visual Studio 2008 (Pre-release) Why no "raise to power" operator in Expression Tree API?

  Hi, Is there any special reason for not including a "raise to power" expression type in the expression tree API VB has such an operator, for instance... Here I show a situation where having such an operator would be desirable: http://www.elguille.info/NET/futuro/firmas_octavio_symbolic_computation_EN.htm Best regards, Octavio Hernandez Madrid, SPAIN The operators designed into the expression trees were limited, not to any particular language, but to the native runtime support for these instructions in MSIL. Everything else is intended to be incoded as method calls, just like your language compiler does. The "raise to power" operator is encoded as a call to System.M ...Show All

• SQL Server Upgraders: How much did tempdb increase after upgrade?

  I came across a passage in a book stating that the SQL 2005 version of tempdb requires "significantly" more disk space than previous versions of SQL Server. I'd like to have your opinion of how much tempdb space increased as a percentage, and what operations you see using tempdb now that didn't in previous versions I'd like to gauge feedback to estimate future growth needs and general concern. Thanks for any info! Read this Article : http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx Madhu ...Show All

• Visual Studio 2008 (Pre-release) WPF on XP?

  What do you loose if you run WPF applications on Windows XP Is there a list of what specifically works/works better on Vista not sure if a list exists. The differences are generally different because of driver model and not because of OS. 1. XP only offers XDDM video drivers and does not have the capability of running WDDM drivers. WDDM drivers can virtualize video memory and run largely in user mode. To read more: GregSc posts on how the Vista Desktop Window Manager (built on WPF's MIL graphics stack) takes advantage of WDDM: http://blogs.msdn.com/greg_schechter/archive/2006/04/02/566767.aspx I write a bit about the differences between XDDM & WDDM here: http://blogs.msdn.com/seema/archi ...Show All

• SQL Server Top predicate optimization question

  Hello, I need to generate a dataset which is the union of a top 10 clause shown in details plus everything else lumped into an "Other" rows. Since this is for a Sub-Report that gets executed many times, best optimization is a must. The query is like that: ALTER PROCEDURE  up_OTSInformationReport @Business as Varchar(85) = '##' , @PTI2 as varchar(4000) = '##' , @Top as int = 2147483647 , @NPDKey as int = 2147483647 --With Recompile as Begin If @Top = 10 begin Declare @TopKeys table(Pkey int) Declare @Allkeys int Insert into @TopKeys (PKey) Select Top 10 i1.PKey  From dbo.meta_OTSInformation i1  where ( @Business = '##' or  i1.Business = @Business)  AND ( @PTI2 = '##' OR i1.PTI2_CD in ...Show All

• SQL Server Plz Clarify my query in SSIS

  Hi There, I have Task in SSIS to import the flat file to the table and break the table and insert and update the other tables in the same database. I searched every where i couldnt find appropriate tutorial for this. Please advice me how to achieve this task. Thanks in Advance Regards Savera Savera wrote: HI Jamie, Thanks a lot. I have some more queries to clarify. I have some complicated criteria like join the tables and set the flag in main table if any of the table updation tasks fails.Will it be done in Conditional split Transformation if its not please let me know how to get this task done. Thanks in Advance. Regards To set a flag in a table you would probably use ...Show All

• SQL Server Complex Transformations (SSIS components vs TSQL)

  Greetings SSIS friends, I have been attempting to implement one of our numerous ETL processes in SSIS but hit a brick wall when I tried replacing a complex stored procedure with a series of Merge Join components. In the end, I had to settle with using a SQL task which merely calls the stored procedure and this proved to be the better option as the other version where I used SSIS components only took forever to run. How do people cope with complex transformations ! Do you guys opt for pure TSQL to perform complex transformations and use SSIS components for control flow+simple(ish) data flow tasks I am confused. dreameR.78 wrote: Yes it has speeded up considerably although I still think I can shave a ...Show All