Search results for query: *

My data is organized as follows: icitem01.item = item code icitem01.pricesort = primary catalog category icitem01.catcode = secondary catalog category icitem01.mfgcode = additional coding for grouping the items. GP1 groups on {icitem01.pricesort} some lines from gp1 are: if...

I use CR 11. I have a report with 3 groups. Groupings are based on three different formulas (gp1, gp2, gp3). There are a handful of item codes that would appear in two different groups for gp2. How can I group the items so that the same item can be in multiple gp2 groups? This is like a...

Ido - I tried as you suggested, here is my command statement: SELECT `apchck01`.`checkdate`, `apchck01`.`aprpay`,"CHECK" as TYPE FROM `apchck01` `apchck01` UNION ALL SELECT `arcash01`.`dtepaid`, `arcash01`.`paidamt`,"CASH" as TYPE FROM `arcash01` `arcash01` However, when I go to the...

I use CR XI. My data sources are Foxpro tables accessed via ODBC. I have two unique tables which do not link. One is the AP check file; the other is the cash receipts file. I need to do a report in which I sum the total of the checks issued for a period and the total of the cash received for...

You have saved me hours of work. Many thanks.

That works - the only gotcha is that when I change the datasource from data02 to data01 and then the table arcust02 to arcust01 - it keeps the name of the table to arcust02 but if you click properties, it says it is arcust01 from data01. I'm sure this will confuse me one day or confuse someone...

I use CR 11 with MS ODBC for Visual Fox Pro. I have 3 different databases against which I need the same format. For example, one report runs against a table called arcust02 from datasource data02. The format of the elements in the table are arcust02.custno; arcust02.company etc. I need to run...