Search results for query: *

While Crystal allows for parameters with combinations of distinct and range values, the report viewer I am using does not support that type of input. I would like the end user to be able to enter a single string parameter with distinct and range values i.e. 'A', 'B', 'D' to 'F' So that the...

Is anyone out there using a hosting service for their Macola and/or Synergy installs? I have someone looking to completely outsource the hosting and management of their Macola ES and Synergy solution and I am looking for any hosting company recommendations, or problems/pitfalls to be aware of...

I have a stored procedure that uses the SQL2000 TEXTCOPY function to insert a BLOB image. The stored procedure is; CREATE PROCEDURE sp_textcopy ( @srvname varchar (30), @login varchar (30), @password varchar (30), @dbname varchar (30), @tbname varchar (30)...

I have a series of folders containing PDF documents that I want to insert into a SQL table. I can get this to work for a single fixed document, but I am having trouble making the file path and file name dynamic. Here's what I have that works; insert into Image_Table ( Customer...

I have two sales order tables; a header table that contains customer information for each order (one per order) and a line table that contains item information (one or more per order). I'm trying to update a field in the header table that contains the total value of any active orders from the...

I have a table with records like; Customer Month 1 Month 2 Month 3... -------- ------- ------- ------- AB001 100.00 120.00 98.00 BC001 212.00 126.00 88.00 . . . I would like to create a view that would 'flatten' the table into; Customer Month Amount -------- -----...

Hi, I've developed this SQL statement and it runs fine in MS/SQL Query Analyzer; Update OEORDHDR_SQL set OEORDHDR_SQL.tot_sls_amt = (Select SUM(Round(OEORDLIN_SQL.qty_to_ship * OEORDLIN_SQL.unit_price * ( 100 - OEORDLIN_SQL.discount_pct ) / 100,2 )) from OEORDLIN_SQL where...

I have a table that has an 'image' type field (BLOB) and I want to append the records to another table that also has an 'image' type field. Both fields are defined identically. My query runs successfully, and the new records look to have image type values in the 'image' field, but the fields...

I am much more familiar with doing reports in Crystal, so bear with me; I am trying to do a report in MSAccess on a table that holds machine start/stop information for each day. In most cases a machine is started in the morning and stopped in the evening so I only get 1 record per machine, per...

Hi - I have a subform that is a datasheet for collecting serial numbers. I want to check that a serial number is entered, and that the serial number does not already exist. I have the following code in the 'After Update' event: Private Sub Serial_Number_AfterUpdate() Dim str_serial_number As...

I have created a simple application to receive inventory items from a previously entered purchase order. The main-form captures the PO information i.e. PO Number, PO Line and Qty. Recieved. I have a sub-form that is active if the item number on the PO is a serialized item i.e. the item number...

I have the following statement that creates a file from the output of a function - it works perfectly: insert into Flattened_BOM_SQL (low_level,Par_item_no,Comp_Item_no,Qty_Per_Parent,Extended_Qty_Per_Parent,Processed,sort_order) select...

Anyone have a SQL stored procedure or view to 'flatten' a BOM? Peter Shirley http://www.srhconsulting.com

Added a new network printer; Ricoh Aficio 3035. When the print dialog window appears in Macola, anything printing to this printer shows A4 as the paper size. No combination of 'change defaults', 'reset printer' or 'use print dialog' will change it from A4. We've initialized the printer...

I've tried the macro 'deleteobject' function, but it returns an error message if the table is not present in the database. I've tried SQL e.g. IF EXISTS( SELECT * FROM MSYSOBJECTS WHERE (((MSYSOBJECTS.Name)='CREXPORT'))) DROP TABLE CREXPORT But this gives me an error if I use it in a SQL...

I have a simple form. When the values on the form are filled in I have a button with an event that runs a macro that contains several append/update queries. One of the append queries adds a record containing the informtation entered on the form. Within the table being written to is a document...

I searched the archives but couldn't find an answer; I have a simple main form that captures part number and qty. and stores it in a table. When a new part number is entered, I want to display the part description and UOM - this data exists in a different table, linked by part number on a 1-1...

Thought I'd start a new thread dealing with 7.6.300A issues; When a PO with multiple lines is received using the 'Receive As Ordered' button, the cost from the first PO line is used on the remaining lines when generating GL transactions for the IM Asset and Receiving Accrual accounts. Peter...

Hi, We've been a consulting partner with Crystal Decisions for many years. When we went to the expense of becoming a partner, we assumed there'd be ongoing benefits to the relationship other than the use of the 'Certified Partner' logo. However, it hasn't worked out that way - we've NEVER...

Thought I'd let everyone know of a solution we've been working with to automatically fax Crystal reports. About two years ago we had a request from one of our clients to automate the faxing of their OE sales order acknowledgments. They would take approximately 250 orders per day, then print...