Search results for query: *

Hello! Here's my (super simple) formula: if {oeordlin_sql.item_no} startswith "3.10" then "Blue instruction sheet enclosed." else if {oeordlin_sql.item_no} startswith "2.10" then "Yellow instruction sheet enclosed." I need a third condition, where if an order contains more than one item, and...

I need to know which table contains the default expiration date that is used when reporting production from within Macola Progression POP. Please see the attached for exact field location.

Hello - I have a BOM where we are only using a percentage of the component to create the item. For example - I have a carton of flooring that we are cutting up to create a take-home sample. Each carton of flooring creates 21 samples. So, I have 2 components for each sample: the label and .048...

Hello - I'm looking for a list of integrated crystal reports. More specifically, I need to know what the name of the report that references the "reprint posted invoices" ICR. I can't open it because I am running Crystal 8.5, and of course all of the ICR's use Crystal 11.

I'd rather not upgrade our version of Crystal Reports because of what I've heard about the more expensive lisensing and developer issues, but need to upgrade the OS.

Trying to install Crystal 8.5 onto a new workstation with Exact Progression SQL version 7.7. "Special" Macola fields don't seem to be there, like the MACOLARemoveZeroes (, )and other functions specific to Macola. Are we missing some sort of driver? I know that we are supposed to have moved to...

Hello, Trying to change font defaults for user, the font dialog and "change default" function doesn't work, all of her picking tickets are printing using an italic font. Help!

Have an employee who hates it when a report opens in design view, she wants her reports to open in the "preview" view only. I can't find the stupid little check box - can anyone help? >:-<

Trying to figure sales tax when counties have different tax rates.... I'm getting a "boolean expected here" (??), fairly new to if-then-else statements. What have I got wrong here? Writing in Crystal Syntax if {oelinhst_sql.item_no} in ["REC001", "REC001A"] and...

For example, Again - we ship books. The charge to ship the first box is $4.25, then it is $1.00 for each additional box. If I have a total of 10 boxes, (thanks lbass....), what formula should I use to calculate the total charge?

A full carton of books shipped = 5 books. We are trying to bill our customer for full and partial boxes of books shipped, and I need for Crystal to ALWAYS round up to the next number unless the quantity of books sold is >5. How can I get this formula to NOT return a quantity of 8.4 for an...

Hello, Trying to chop up and use a report that used to be an integrated report as a custom report (those integrated ones were so wordy.... too much info). When I refresh the report, I'm getting a "Memory full" error, and then "Not a 4.X or earlier version of Crystal Reports". How can I get...

We have noticed that when you convert a quote to an order in OE, you lose the ability to go back and look at the quote. Does anyone know why this happens, or if there is a work-around for it?

Hello, Wondering if someone can give me instructions on how to change my existing Crystal Reports to read our database after our conversion to MSSQL 2005 from Btrieve/Pervasive 2000i this weekend. I am running Macola version 7.6.400 and Crystal version 8.5 Developer. I know that our integrated...

We are planning an migration to mssql, and have some third party applications that access our Macola databases. I am assuming that the actual table structure isn't going to change with this migration, but my programmer has the following questions, can anyone help? Will the SQL server database...

Thinking of (finally) upgrading to Pervasive 9 - will Macola 7.6.300b run on this platform? We don't want to upgrade to a more recent version of Macola just yet because of the conflicts with Crystal 8.5. We don't want to upgrade to a higher version of Crystal just yet because of the problems...

I am "dumping" hundreds of orders into Macola daily, and am currently having to bill them each separately in order to invoice them. I thought that I could turn on the Manifest option in System Manager and use that instead of billing them individually, even though I'm not using clippership or...

Running 7.6.300b on Pervasive. I am using a third party developer to generate pick tickets(long story why...) and I need to know exactly what tables and fields are written to and updated when a pick ticket is generated through Macola so we can duplicate. Most interested in changes to IM...