Search results for query: *

I'm trying to develop an MDX report using the Report Wizard. The Report Wizard creats the report just fine initially. I can preview just fine. But when I switch to layout mode and try to expand the columns, then switch to preview mode, VS crashes. Do I need to load some sort of patch for 2k5...

Ok, I've just recently be venturing into MDX scripts and such. I'm learning how to extract complicated info such as rolling avgs and trends. However, how do I deliver this to an end user? I mean, I know about OLAP clients with pivot tables such as XL 2007, but thats only good for pulling...

I'm looking for a good resource to help me develop reports using MSSQL 2K5 for OLAP cubes, specifically using the matrix table. Suggestions?

Hello. I am currently frustrated by Excel's 65k row limit for my portable cube. Some of the cubes I design exceed 65k. Is there an alternative? Perhaps Crystal Report? If so, where do I look. mongr1l

Ok, this is going to sound lame, but here goes: So now that i'm done developing the application (yipeeee!), I now have to create marketing presentation material, complete with screenshots and bullets. ????????? They didn't teach me this part in college, although I'm sure it's soooooooooooooo...

I have a label control that is bound to a field on a table in a dataset. The field is of type decimal. I'm trying to format the field such that it shows 8 decimal places -> ds.somefld.ToString("0.00000000") This works fine so long as there is a value greater than Zero. However, if the value...

is it possible to sort a cube by a value as opposed to a dimension? mongr1l

I'm wondering if anyone can point me to a good link that demonstrates how to wrap up my project into a deployment package. Thanks. mongr1l

Ok, I know how to manipulate the properties of a text column in a DataGrid: Friend With Event someGrDTxtbx as DataGridTextBox someGrDTxtbx = someGrdTxtbxColumn.TextBox someGrdTxtbx.Visible = False But how do I do it for a Boolean Grid Column? mongr1l

Is there a way to do an sql aggregrate on a dataset? Something like "Select Category, Product, Sum(cost) from Products group by category, Product"? I know that DataViews have rowfilter and sort, but I'd like something more direct? Ideas? mongr1l

Can anyone tell me why I'm getting the following error: "Index as outside the bounds of the array" I get it whenever I have code perform a Radio Button click. mongr1l

Is it possible to intergrate a Flash component into my VB.NET app? Is it recomended? mongr1l

Hello. Back when I was developing in ASP, I did many of my menus with rollover effects. However, it was a pain to implement because I had to create javascript functions that basically switched the jpg image for different mouse-move states of the object in question. I'm wondering if there is a...

I'm trying to import into a db a file that is 19 million records big. Each record consists of 20 fields, each nvarchar of 20 in length. I have 115 gigs free space on the drive for the data file, and 115 gigs on the log drive. The log and data are on separate drives. When I DTS the file into...

I have a data view and I want the simplest way to access the first column of the first record. What's the quickest way to do this?

Ok, I'm going need some major big thinking on this one. Here's the problem: I've on the cusp on convincing my employer to move into Data Warehousing. We currently use MS SQL SERVER 2000. I know that SQL 2k5 comes with Business Intelligence Platform, but I don't think my boss will is going to...

I'm trying to convert a varchar field into a decimal(22,6) field, but I keep getting an Arithmetic Overflow error. This is because some of the values look like this: 9.6666666666666666666666666666666666666666666666666666 If tried using ROUND(), but it doesn't work since I need to convert...

Hello. I'm looking for suggestions on how to optimize my SQL SERVER 2000 platform such that it doesn't keep getting hung every time I want to make an elementary modification to a table that has 14 million records. The box is HP Compact DL380, dual processor hyper threading machine with a...

Hello. I'm trying to DTS some tables into a DB. Some of the tables are appends to tables in the destination DB, so I have to first delete the existing records before the new data is appended. However, some of these table are Parent tables in a relationship, complete with foreign key...

Is there a function in sql that formats the date? I'm trying to convert the dates in my table from 'DD-MMM-YYYY' to 'MMDDYY'. Please tell me there's a simple way to do this. mongr1l