Search results for query: *

I have a report that shows information for products (product name, number, cost, sell, etc). Each product can have one, or several, colors attached to it, with a quantity for each color. So, if there are 4 colors attached to one product, I'll get 4 records returned for that product; one for...

ASP.NET/VB.NET 2.0 I have a webform that has a gridview bound to a stored proc using the SQLDataSource. I need to set the visible property of records based on a value in the datasource. My initial thougt (when I thought it was bound to a dataset) was to do a select against the datatable, and...

In my where clause, I need to compare a field in table_1 to a field in table_2. My problem is that the field in table_1 is a text field, and the field in table_2 is a numeric id...so... table_1.type = "blue" and the equivalent in table_2 would be table_2.type_id = 4 So I essentially need...

I can set the datasource of a Crystal Report to a DataSet, and it works just fine. If I try to set it to a particular DataTable, I get the error "Invalid Table Number" Any ideas why this would happen?

I have an application that was recently run through the migration wizard to bring it from VB6 to VB.NET 2k3. I am having some issues with one particular thing... The application accesses the registry using functions in ADVAPI32.dll. In VB6, everything works fine, and the API function...

I'm having an issue filling a dataset from an excel file. Creates an OleDB connection to the spreadsheet (no problem), then generates a Select statement to read the worksheet in to the dataset. It works great IF all the relevant fields in the spreadsheet contain data. The select is a simple...

Crystal Reports XI Oracle 10g I'm writing a report that is supposed to show how much time it took to go from one status to another. Not a big deal. My issue is that Crystal is only displaying the date, not datetime. If I query the db using WinSQL, it shows datetime. If I query the db using...

C# I have a form with 2 textboxes. I want to add a button by each text box to count the characters. I can do this the really easy way by creating 2 buttons, and coding an OnClick for each button. I'd rather check to see which button is clicked, and count the characters in the appropriate...

C# My goal is to validate the text entered in to textboxes to make sure there aren't any illegal characters before it gets written to the database. My thought is to pass a page (and all it's controls) to a class, loop through the controls on that page to identify all the textboxes,validate...

I'm looking for a report that will show all of the following: within a date range, grouped by product; total $ for orders placed (invoiced or not)and total $ for invoiced orders. Do any of the standard reports cover this, or is it a custom report? Thanks!

Crystal Reports 8.5 Pro, 10 Pro, and 11 Pro... When connecting to a SQL Server 2000 database via ODBC, only the stored procedures are showing in the Database Expert window. It's only one database that's doing this. Other SQL Server 2000 database will show tables as well. Any ideas as to...

Is there a difference between decimal x = 1.00m; and decimal x = 1.0m; ?

Does this data in this field change at all when an order moves from SOP10100 to SOP30200? Like, if I'm looking for all orders placed within a given date range, I should look for at these two tables and filter off the ORDRDATE field in each table, right? Thanks!

In what table(s) would I find information on orders that haven't been invoiced yet?

I'm writing some Crystal Reports for a company against GP 8. I'm having a hard time excluding voided invoices. I assumed that the field that held the void status was VOIDSTTS, but checking against this field my totals are still incorrect. Is this the proper field? Should I be checking...

Can we use Visual Source Safe to control our Crystal Reports?

CR 9 Is there a way to conditionally suppress the page header, and then when the user drills down have it appear with the field titles?

Is there a way to use the SQL LPAD function in an Access query?

I'm pulling 2 columns from a table on a SQL Server database in to a dataset, the ID, and a charfield. The char field has to be 10 characters, so I'm checking the length, and appending leading 0's where necessary. What's the fastest way to write the changes back to the table in the database...

Just wanted to know if anyone has installed both Visual Studio 6 and Visual Studio .NET on the same PC before. If you have, were there any problems you encountered? Are there any steps needed to take in order to install both? Thanks!