crazyabtdotnet's Q&A profile

• Visual Studio Detected Dependencies

  Hello, I'm having a problem running a report on a client machine. I'm developing in VS 2005 using VB. I have a simple VB form using Crystal Rerport Viewer. When it tries to run, I get error: "Could not load file or assembly 'CrystalDecisions.Windows.Forms, Version=11.5.3700.0". In my Setup project, in Detected Dependencies, it includes crystalreports11_5_net.msm. However, I have read where it should be using crystalreports11_5_net_2005.msm. Any Ideas or can I provide more information THANKS, Carl don't use crystalreports11_5_net.msm, use crystalreports11_5_net_2005.msm. I rarely trust the detected dependancies in Visual Studio for third party components. ...Show All

• SQL Server How to use iif in Filter expression

  I am want to do a count distinct of an ID where fieldInt is not null in a table. This is how I am doing it... In Layout view, click the table, then right click Properties on Filters tab, for filter I do the following: In Expression column: = Fields.fieldInt.Value In Operator column: = != In Value: 'null' But this is not working. How do I solve this problem. You can write this in the expression = iif( Fields.Fieldint.value is nothing, 0, CountDistinct(Fields.Fieldint.value)) This should get you your count distinct where values are not null. Hammer ...Show All

• Visual Basic Copying similar rows into different sheets in Excel

  I have a spreadsheet wth numerous rows of data. These rows are grouped together by a unique number in the first column. After sorting, how can I automatically cut the rows with the common numbers into a new sheet. In other words, if I have 15 rows with the number 1 in the first column, 23 rows with the number 2 in the first column, etc. how can I separate those rows into different sheets Thanks. Excel.range("A1").select Dim TheValue as Integer = Selection.Value Dim NumberofSimiliarRows as integer While Selection.Value=TheValue selection.Offset(0,1).select NumberofSimiliarRows +=1 end while that will give you the number of alike rows based upon the values in column A ...Show All

• .NET Development System.Messaging MulticastAddress

  Does anyone have sample code on how to utilize the MulticastAddress capability with System.Messaging In other words, I'm looking for examples on how to send messages to multiple destinations using the Message class and the MulticastAddress property. The only examples I have found use MSMQDestination and MSMQMessage. What I want to utilize is the Message and MessageQueue classes instead. Thanks in advance, Jose... ...Show All

• Software Development for Windows Vista Where to download regdump.exe and regdiff.exe?

  Hi all, I am looking for these 2 tools mentioned in the "Certified for Windows Vista Test Cases," regdump.exe and regdiff.exe. They are part of "Vista Logo Test Tools" but I can't google them. Does anyone know where I can download them Regards, David both files avilable with the Windows NT Workstation Resource Kits: http://www.microsoft.com/technet/archive/ntwrkstn/reskit/03tools.mspx mfr=true By the way I found it using Live Search ...Show All

• Visual Studio Calling a recipe inside another recipe???

  Hi All, I wanted to know whether it is possible to call a recipe inside another recipe. Say for example, I have 1 recipe each to create a business entity project, data access layer project etc., Now, say for creating a solution, is there any way where I can say my CreateSolution recipe will call BusinessEntity recipe, DAL recipe etc. .. Or the only way is to specify as individual actions grouped together .. Any help is appreciated.. Regards, - Santhoo Morning :) I've tried the suggestions you've made above and I still get exactly the same error ( The element 'Recipes' in namespace 'http://schemas.microsoft.com/pag/gax-core' has invalid child element 'Recipe' in namespace 'http://schemas.mic ...Show All

• Windows Forms Sort columns in datagridview

  Hi all. Does anyone know how to sort the order of columns in a datagridview. My datagridview is using a datatable as datasource. This datatable contains columns "A","B","C","D". I want my datagrid to display the columns in another order. I Want column1 = "B", column2 = "C", column3 = "A". Anyone Lars This only works sometime. If column nr 2 in the datatable shoud have a displayindex = 1 a run-time error occurs. I can understand this. I am using this function on "ColumnAdded". Is that wrong. Shold i do this some where else Another funny thing is that the event "ColumnAdded" runs 2 time for each column i the datatable whi ...Show All

• Visual Studio 2008 (Pre-release) Base Class in xaml

  Hi, I'm trying to build a user control in xaml that would serve as base class for other user control. I searched the forum for answers but didn't find anything that was working, so if anybody has a working example or can explain it in details out to do it, would be great. Thanks in advance. I have tryed this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=995567&SiteID=1 For current bit of WPF, you cannot subclass from xaml generated class, but you can work around this by doing something like the following: First off, create an custom WPF control library project, and then declare your custom window this way: namespace CustomControlLib { public class CustomWindow ...Show All

• Visual Studio Express Editions Visual Basic Drop Down Calender

  I have the need for a drop-down calender to select a date on some text box options. I have the program set to find the current date and fill in the box wiht the current date, but would prefer to have it defualt to todays date and have the option to click on a date in a drop-down calender format as so many other programs do. Thanks In Advance. Nick Getz If you want to default back to the current date, For the DateTimePicker: just set the DateTimePicker.Value to Date.Now. Me.theDateTimePicker.Value = Date.Now   For the MonthCalander: Me.theMonthCalander.SetDate(Date.Now)   I am a bit unclear but if you wanted to set a textbox.Text property to show the current Date: Me.theTextBox.Text = Date. ...Show All

• Visual C++ The Laundry List

  As the subject line implies, I have a whole laundry list of questions. However, it seems to me that the best way to utilize this resource is by starting small with a single question. With a little luck, I'll be able to leverage the initial answer to help me fill in some of the other blanks on my own, and then I can home in on further questions. I'm transitioning my Augmentative and Assistive Communicaion app, Xpress-It,  from VS 2003 to VS 2005. Xpress-It is a fairly typical MFC MDI critter with some of it dating back to VS 5. For that reason, I have been using the InstallShield version that came with VS 6. Nice and fairly simple. Obviously, certain changes with 2005, such as manifests, significantly muddy the water. But again ...Show All

• SQL Server SQLCE - Getting started Questions....

  I am trying to soak in all this information regarding SQLCE and was hoping someone could set me off in the right direction. Scenario: I have an Windows Mobile 5.0 data collection application that I need to sync with a desktop database. I will need the ability to sync 1 or more Pocket PC's with a desktop database. Questions: 1.) Assuming I need to sync the data, is using a SQLCE database on the device AND the desktop a viable solution 2.) If not, would my only other option be to use SQL Server Express (SQL Server is not an option, $$$) 3.) Keeping simplicity in mind, what would be my best choice of syncing technology RDA Merge Replication Microsoft Synchronization Services for ADO.NET Generally speaking, I want to know if YOU were sta ...Show All

• Visual Studio Team System Cannot edit TFS Reports with Visual Studio Report Designer

  Hi you all, I'm having a problem while opening Reports provided by TFS (such as WorkItems.rdl) with visual studio. When I try to "Preview" the report I get the error: An error occurred during local report processing. Query execution failed for data set 'IterationParam'. Incorrent syntax near 'Measures' I get the same report for different datasets if I try to check other reports. The datasources (TfsOlapReportDS and TfsReportDs) are well configured in both the report server and the visual studio project. These reports work well on the report server, but I need to edit them. Any suggestions Many thanks in advance.   Hi Nick! I've still problems with the default value for ExplicitPro ...Show All

• .NET Development Original table of view column

  I need to know the underlying table of a column in a view. Using getschema("Columns") i can get a list of the columns in the view, but not the table that they come from. Using getschema("ViewColumns") gives me the table that they come from but not if they are visible or not in the view... it includes all columns from all tables in the view regardless if they are visible in the view or not. What I need is to get a list of columns in the view and the table that they belong to. What's the best way to do this Any advice Hi siftee, I think you have to use the the information_schema views from SQLServer - if you are using it - Here is a link where you can find how to use them Bes ...Show All

• Commerce Server Base/virtual catalogs and related products

  Hi all, I am attempting to determine the best way to set up base and virtual catalogs and I'm having some confusion on how the related products are being handled. We have a base catalog containing all of our available products. Originally we also had our related products defined there, but when we went to add products to a virtual catalog, it used the related products from the base... but didn't allow you to remove the relationship in the virtual catalog (which we might need to do if a related product isn't contained in this catalog). Soooo... because of this, does that mean related products are typically defined in the virtual catalog instead What if you want to create a virtual catalog that is a subset of another virtual catalog You w ...Show All

• Software Development for Windows Vista WF on Orcas March CTP

  Hi, I created a new Workflow Project and tried to open the workflow designer. I got this error:   Microsoft.VisualStudio.Shell.WindowPane.GetService(System.Type) Does anyone knows about it Is there a workaround Thanks, Guy Burstein http://blogs.microsoft.co.il/blogs/bursteg/ You’re welcome. - No, I don't have a blog. Thanks Roman p.s. My articles are located on the codeproject . ...Show All