Recent content by goolawah

I have learned something. I have added more records to my test database to provide a more representative sample. I can get the result I am looking for by deleting the link on Location so that there is only one link (Item). I then added another selection criteria Table_1.Location =...

That seems to be a problem. That option is greyed out, presumably because I am accessing the DBase files directly. I did try setting up an ODBC data source to see if I could discover anything by that route, but the problem persisted and the report was extremely slow to run. Probably unacceptable...

Thanks for feedback so far. It prompted my to try a couple of ideas, unfortunately without success. In response to the questions above - I have created a simplified 'dummy' report to make it easier to work through this. The full SQL select statement is as previously outlined and repeated...

Thanks for that. The complete selection formula is as follows - trim({OeDet.ITEM})= "LA196____C" and {OeDet.TYPE}= "I" Oedet is Table1. It is linked to Table2 by fields Item, and Location. The selections above are to limit the output to just one item code (LA196____C) and to just invoices...

I thought I should also mention that when I use a Left Outer join I get all the records in Table 1, but the information required from Table 2 is only shown for the two records that match the first record in Table 2. (Does that make sense?)

I'm using Crystal v10 with DBase IV tables. Table 1 is transaction detail and includes fields- Number, Item, Qty, Location. Table 2 is stock status and includes fields- Item, Location, OnHand. I am using a left inner join to link Item and Location in Table 1 to Item and Location in Table 2...

No. I've been trying, unsuccessfully so far, to do something like that. I can't figure it out. I'd appreciate some input.

I am printing some mailing labels using a 2 x 7 label format on an A4 sheet. All works fine, but occasionally I have to print a single label and have been trying to figure out a way of defining which label to start printing so I can skip labels that have already been used and removed. This...

I am writing some Crystal XI reports for an applicatiion, written in Delphi using DBase files. One file causes a problem and, on further investigation, it appears that it is a DBase7 file (I think the others are DBase 4). Without going into the specific problem too much, one solution would be...

With a bit of help from searching this forum I have figured out how to dynamically link images to specific records in a table so that I can (for example) list stock items together with their associated images. This works really well in CRXI. I am wondering whether a simlar approach can be used...

I have upgraded from Crystal v7 to CRXI Professional, and have converted existing reports, which previously used direct access via ddfs, to use ODBC. Installed on user's site yesterday. When I ran the first report other users on the network, using the application from which I am extracting...

Many thanks, 'dgillz' and 'mertheil' for very helpful responses.

I have been getting help with Crystal XI from the Business Objects forum but hope members of this forum will have more experience specifically with the Pervasive ODBC Interface. Before I upgrade to CRXI Professional to get full ODBC connectivity, I wanted to confirm from other's experience that...

Great,thanks fellas, I'll download the eval.

Thanks for the responses. I understand that CRXI Standard does not support ODBC(RDO), but as far as I can see it does support OLE DB(ADO) and this provides access to the data source I need. It's just that I get this error message before the report runs. I'm not sure how I can have any...