Brian Kramer's Q&A profile

• Visual Studio Automatically Generating a Crystal Report to PDF

  Hi Guys I need to think up a way to automatically generate a few reports. It is sales figures that i get from a production system. I got the reports, I just need a way for it to be automatically generated and emailed off to a certain email address. So far I had no Luck. Just cant think of a way to do this. All I need is a way to do this whole process without user intervention, hence automatic. I got reports that is needed so its just a matter of getting a way for the reports to run automatically. I got the code that can export it to pdf and probably can get it to be emailed. just need something that will do the automatic generation of the report. Thank you in advance. oh I am using visual studio 2005 and SQL Server ...Show All

• SQL Server How to write Prediction Query for TimeSeries Algorithm

  hi,I am a novice SSAS Programmer.I need a prediction Query in time series algorithm, so that it should predict for a particular date.I dont know how to use where condition in a prediction Query. Thanks Karthik hi yimin, Thanks for your reply.Its very helpful for me.I am having one more doubt.How to use where conditions in prediction Query. FOR example for 200807 I need the Expression.Amount.How to get that. Thanks, Karthik ...Show All

• Windows Forms Presenting List-and-Edit for best user experience

  There are a few ways to do this. I am wondering what people consider to be the best or most standard way. List / Dialog . This way, a ListView control shows the names of several objects (records) of one type. When the user activates an item (double-click, right click, some other button, etc.), a modal dialog box opens with a form to edit the details of the object represented by the selected item. If the user OKs the dialog, the changes are saved and the ListView refreshes. List / Details Pane . This works like List/Dialog, except instead of using a dialog box, the details of the object to be viewed/edited are displayed in a panel located directly below the list. The panel contains a form which is normally disabled (grey-ed out). When ...Show All

• SQL Server WMI Event Watcher Task

  I am trying to setup a WMI Event Watcher Task. I want it to look in a particular directory for a specific file type. My following query parses OK, but does not notice new "err" files. SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"c:\\\\temp\"" and TargetInstance.PartComponent="CIM_DataFile.Extension=\"err\"" What am I doing wrong here Thanks! ...Show All

• Visual Studio Express Editions Can I use VBE 2005 classes in Excel 2003 VBA code?

  I have a class library that I'm developing in Visual Basic Express 2005. I can use the classes in other projects in VBE, but I would also like to use them in VBA code in Excel 2003 (i.e. in the VBA code I want to be able to create instances of the classes from the class library).  If that is possible, can someone please give me step by step instructions I'm hoping Abel will reply as I'm only just learning this. But I think the error you are getting is the one I got before I strong-named the assembly. Did you definately check "sign the assembly" on the Signing tab of the project's properties page, and then use the Choose a Strong Name Key File box to create a key When you do ...Show All

• Community Chat Lokad.com - time-series forecasting with .Net

  We have released www.lokad.com a few weeks ago; Lokad specialize in business time-series forecasting. Lokad has been entirely developed in .Net. It was quite a lot of fun actually, see the page about our technology . Lokad is a mix of data mining, grid computing and social networking (somehow). The recipe includes Web site with ASP.Net the new WebApp and Ajax . Grid computing with the PowerShell . Continuous integration with CruiseControl and the MSBuild tasks . Part of maths relies on Math.Net . Best regards, Joannes http://www.vermorel.com ...Show All

• .NET Development execute stored procedure on only selected rows

  using inventorytableadapter.updateQuery1("itemno") I'm able to subtract Invoicedetails "Qty" from Inventory "Instock" but I need to add a where clause to this query so that only the selected rows are updated here's my query UPDATE Inventory SET InStock = Inventory.InStock - InvoiceDetails.QTY FROM Inventory INNER JOIN InvoiceDetails ON Inventory.ItemNo = InvoiceDetails.ItemNumber; where ( Itemno=@Itemno ) SELECT ItemNo, ItemDescription, InStock, Units, Cost, ItemID FROM Inventory WHERE (Itemno = @Itemno) Any Ideas Thank You! I'm not able to try it right now, I'm trying to install sqlexpress with advanced servic ...Show All

• Visual FoxPro Record repositioning

  To debug this, try running the app yourself with the Debug window open and a breakpoint on RECNO("the affected table"). Most likely, it's a command like COUNT or something else that moves the record pointer. Tamar ...Show All

• Visual Studio Express Editions VB Express and SQL question...

  Hi, I am a new programmer and so I was following a guided tour about creating my first database from this address... http://msdn2.microsoft.com/en-us/library/6147aah4(VS.80).aspx The directions say this: "In Solution Explorer , select the FirstDatabase.mdf node" but the firstdatabase.mdf isn't there. I followed all of the directions to the letter. I tried looking inother places but with no luck. Can anyone give me some pointers please Hi Matt, Your listing didn't include the directory path. I don't know exactly what you done before that lesson. I don't know if you're supposed to working in a multi-project solution or not. But here is the way to add that database to your project: 1.) Put your cursor on the ...Show All

• Internet Explorer Development BHO without VS

  hi, is there any possibility to build a BHO without using VS Yep, with enough searching you will find an example written in VB6 or Delphi. All you have to do is incorporate a typelib in your project that implements isetsite. Regards. ...Show All

• SQL Server Dynamic columns

  Hi, In my report iwant to display columns to the user.So he can select which columns to display in the report.How to display those clumns list to the user.There is no check box in the report toolbox. How to achieve this Thanks in advance ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What is System.OutOfMemory.Exception mean, and how should I fix this in debug?

  Please read question above. /\ I would look for places where you're creating many objects. Namely, are you creating a large amount of objects, or are you retaining references to objects you no longer need Also, it could also be from your computer having a lack of system memory. ...Show All

• Visual Basic Data Binding an RTF Textbox (VB.NET 2003)

  Hello! How do I bind an rtf textbox Can you please provide some code samples I would really appreciate it :) Thank you, Shawn Whats the problem binding to a richtextbox shouldnt be anything strange. Here's a simple example that creates a datatable and binds it to a textbox, richtextbox and a combobox. As these are all bound to the same datasource, changing the item in the combobox causes all the other items to update. As the data bindings can allow you to bind to any property - normally we bind to the text property but there is no reason why you cant bind to almost any property on controls. Public Class Form1 Dim dt As New DataTable Private Sub Form1_L ...Show All

• Visual Studio 2008 (Pre-release) Intellisense Problem in XAML

  Hi guys, I have a problem with intellisense in XAML file. When I declare any object type in XAML of the same namespace but located in different file, same project - there is no more intellisense after this declaration. May be someone is familier with this problem. Appreciate your help, Irina <Window x:Class="LadarUI.Window1" xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " xmlns:ladar="clr-namespace:LadarUI"> <StackPanel> <ladar:LadarStatusBarCtrl /> </StackPanel> At this point, the Intellisense support for XAML is still flaky. I find that whenever a custom data ...Show All

• Windows Forms General paths problem

  Hi there, I'm fairly new to winforms dev and I'm stuck on something I'm sure someone can help me with: I am using a 3rd party spellchecker control which requires an external dictionary file. The problem is that simply supplying the bare filename (without any form of path) works until the application's working directory changes. For example, if somewhere in my program the user invokes an OpenFileDialog and selects a file, the app's working directory is set to wherever the file was located (e.g. the Desktop). After this, the spellchecker pukes because it can't find the dictionary file in the Desktop. I could set an absolute dictionary path each time the spellchecker object is created but this seems like a bit of a fudge as it's used in ...Show All