Search results for query: *

Hi, This is Crystal XI and I have a subreport that shows all of the serial numbers for items I have in stock. This could be several hundred items and each serial number is a 'next line' record. Is there a way to wrap the text in this condition to reduce the length of the report? Thanks, Rob

Hi All, This is Crystal XI sp2 running on a Progress Database. I am trying to select on a numer field and get records that are a zero. So, in the select expert, I choose the field (QtyShipped) then the condition (is equal to) and enter zero in the field. When I click OK, I get an error...

Hi All, I am working with a database that will show a dash (-) in a numeric field when the value is zero. I would like to show the zero on my report. I have tried to create a formula field with: If {TableName.FieldName} = "-" Then 0 Else {TableName.FieldName} When I do this I get an error...

Hi All, I have run into a situation where I need to group by pieces of a list field. This is a sales commission report and in the invoice record, there are two list fields, one for the sales rep code and one for the actual commission dollar amount. I found a formula to split the codes out into...

Hi, This is a pretty common sales report, with sales dollars grouped first by salesman then by product group. This part was pertty straight forward. I would like to now total all sales by each product group. This is not so straight forward. I tried to use a Select statement by my syntax must not...

Hi All, I have looked at several examples of triggers that fire on update of a column, but I would like to fire a trigger on the the update of a column of a particular record. Ideally my trigger would look something like this: CREATE TRIGGER test_trigger ON [dbo].[IMINVLOC_SQL] FOR UPDATE...

Hi All, I am using FrontPage 2000 and edited my live website yesterday evening. I tried to open the website again today and got one of those 'encountered a problem and needs to shut down' messages. I can get into other sites on the host server, as well as webs on my local machine. I have un...

I have an executable that is trying to connect to a SQL database through and ODBC connection. It is failing to connect with the following error, and I am hoping that all I have to do is sync up user names and passwords in SQL but I am not sure. The failure is this: [Microsoft][ODBC SQL Server...

Hi All, I am trying to help a friend of mine out with web maintenance and the last person to work on it was a DreamWeaver user. Consequently, I cannot see all of the htm pages or graphics or anything that normally come down from a website when you do an import from a URL. Does anyone have a...

I would like to talk with someone who is currently working with the Exact SDK particularly with e-Synergy. I have an application I would like to discuss and need to find out if what I want to do is technically feasable with the SDK or not. Thanks, Robert Cytec Corporation rbrown@cyteccorp.com

Hi All, I am looking for a product that will monitor a SQL database and in some way, record the table and fields hit during an application transaction. For example, if I add a customer to a CRM package, what fields in which tables will get read, updated or possibly deleted during the...

I have a Flex project that needs to make a folder in a file path if one does not already exist. This is for a log file function. The folder name is coming from a variable, and the MkDir command works fine except that it creates a folder name with single quotes around it. So for a folder name...

I was wondering if anyone else had seen a significant degradation in performance after upgrading to 7.6.200. I just sat and timed the deletion of a routing that took 2 minutes and 50 seconds. Just closing the routing entry screen consistantly takes close to two minutes. Exact has suggested...

This was something that was prevelent, as I understand it, during the Progression 7.0 days. I was not around then so I have no idea where to start looking. Any suggections would be great. This is a 7.0 installation running some very old version of btrieve. Thanks, Rob Cytec Corporation...

Hi All, Has anyone installed the download from the Exact site that addresses the 7.6.200 printing issues? Does it fix the printing issues, and more importantly, does it break anything else? Rob Cytec Corporation rbrown@cyteccorp.com

Does anyone have this hot topic patch? I was told by Exact tech help that it should be on a 7.6.100 or 100a CD under a folder called hot topics but I could find no such folder on any of my discs. Thanks in advance. Cytec Corporation rbrown@cyteccorp.com

I have a date in the form of a datetime data type in a filed in sql (MM/DD/YYYY) and I want to put it in the form of yyyymmdd as an integer. Is there an easy way to do this with a sql statement in query analyzer? Cytec Corporation rbrown@cyteccorp.com

Hello All, Since Peachtree has refused to provide any sort of data structure information, I was wondering if anyone has converted Peachtree data to Macola and if so how difficult was it. This will be a current version of Peachtree going to Progression, rather than ES. Cytec Corporation...

Hi All, In Enterprise Manager, you can highlight a table in a database, right click and choose Properties and get the field names, data type and size. Is there a way to print this out? It would sure make writing data conversion code alot easier. Rob Cytec Corporation rbrown@cyteccorp.com

Hello All, This is my procedure. I have looked at books on line but cannot see where the Convert command is actually supposed to go. Thanks in advance. Rob Declare @Date1 as DateTime Set @Date1 = getdate() INSERT INTO maccat.dbo.INTERFACE_PO SELECT Data_03.dbo.POORDLIN_SQL.ord_no...