Search results for query: *

I don't see why that wouldn't work. Is it throwing an exception or just not returning any records?

Yes, the formula is correct. It may be throwing an exception because you have either a null value in the field or some of the names don't have underscores. Try doing a check on the field first: IF Not IsNull(searchfiled) THEN formula ELSE "" If that isn't your problem, you will have to check...

Left (searchfield, InStr (InStr (1, searchfield, "_") + 1, searchfield, "_") - 1)

Thanks for the reply. With a little manipulation, your formulas worked well except the linecnt variable is still calculated by record. I wasn't able to figure out any way to make it total by section. So, if I wanted only 7 lines and part A had 2 lines, part B had 3 lines, part C had 3 lines...

That was the approach I was taking, however; there may be more than one line per record and I haven't figured out how to get the running total to work by section. I have 5 detail sections set to supress on blank. detail1: part number and description detail2: description2 detail3: special note...

I'm creating an invoice report using CR10. I have about 3" of space for the invoice items, which I'm puting into the detail section. I want to start a new page after the order items fill up that 3" of space. How can I do that?

Awesome, thanks.

You need to add an open relay to the IP address of your job server on your exchange server or whatever email server you are using.

I'm running CE 10 with 2 job servers installed on a dual xeon machine. How can I determine which reports are currently running without going through all 300 report objects? I can tell how many jobs are running on each server, but not exactly which. Thanks, Mike

I'm Using Visual Studio 2005 Beta with the .Net Framework 2.0 Beta. I want to access a public property on an aspx page (MyPage) from a user control (MyControl) loaded on that page. I can access the Page property on my user control like so: this.Page; This returns the Page object, but I'm...

Does anyone know where I can get a copy of the Excel Add-in for CE 10? All of my documentation says that I can download it for free, but BO's web site is telling me I have to buy live office. Can someone email it to me or point me to the download so I can try this thing out? Thanks, Mike

Can this be done? I have a memo field that I want to be edited in a datagrid on a win form. I want to be able to show three lines at a time and use returns. Here is what I've tried. [code]DataGridTextBoxColumn colFullInfo = new DataGridTextBoxColumn(); colFullInfo.MappingName =...

I have a datagrid that gets populated with true/false info, but the checkboxes allow the user to click through all three states: true, false and null. I don't want them to be able to select the null state. I format the DataGrid by Adding a table style. The true/false columns are formated...

We are going to be using a new time and attendence system that hourly employees can use to clock in and out at their desks. We pretty much have everyone trained to shut down or log off before they leave, so is there a way to send a windows prompt (yes, no and cancel) when they try to shut down...

Great idea. Thank you very much, Mike

Can you pass information to a child window from a parent window opened with the ShowDialog() method? Mike

I have an oleDbDataAdapter select command that joins 2 tables. I then fill a dataset and attach it to a datagrid. Is there a way to update both tables in the oleDbDataAdapter update command? I tried separating the UPDATE text with a semi colon, which didn't return any errors, but the data...

I haven't found any documentation stating that you can't fill a dataset with a memo field, but I am having trouble doing so. I'm using a dataadapter to connect to a Visual FoxPro database using the OLE DB Provider. I have no problem filling the dataset until I add a memo field to my select...

Is it possible to get the current value of a crystal report input parameter? I've tried everything I could think of but I can't get the value of a partameter field that was saved with a report. This code only returns "CrystalDecisions.Shared.ParameterDiscreteValue&quot...

I'm trying to use one DataSet between an odbcDataAdapter and a sqlDataAdapter, but it isn't working. I'm using the odbcDataAdapter.Fill method to populate the DataSet, which works fine. I then try to use the sqlDataAdapter.Update method with the DataSet filled by the odbcDataAdapter, but none...