Search results for query: *

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...

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...

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...

I am trying to use CRXI Standard Edition to create simple reports for an application (Sage/Pastel Accounting) that uses the Pervasive database engine. I have set up an ODBC data source using OLE DB(ADO) - Microsoft OLE DB provider for ODBC Drivers as this iappears to be the only suitable ODBC...

I have been using Crystal V7 for years because I had users who preferred the free run-time distribution it provided. Have now (finally) upgraded to Crystal XI and, so far, it looks pretty simple to convert my knowledge, and reports, to this version. Some users will now purchase Crystal XI but...

Hi all, I continue to use Crystal V7 because it provides all the functionality I need, and it it so easy to create report distributions with free run-time. The target application uses the Pervasive database engine. I use the "Data File" option rather than SQL/ODBC. This points directly to the...

I have searched these forums for an answer and, while the topic seems to be addressed in various threads, I haven't been able to apply any of the information in my particular environment.[reading] I am currently using Crystal V7 because it does all I need PLUS it is easy to distribute reports...

I have two ODBCData Adapters, one using the Microsoft Text Driver, and the other using the Pervasive SQL Driver and both work correctly as I can preview the data. The Pervasive SQL Data contains several tables which are linked (SQL JOIN). The schema of the resulting DataSet looks like this -...

I have a simple Access application with uses two ODBC linked tables to read data from an external database. I now need to add two more tables but Access rejects the link. I have discovered that the problem seems to be due to the fact that each of the new tables (unlike the existing ones) have...

I am wondering if there is a maximum number of fields that can be selected in an ODBC Data Adapter query? If I select more than (approx) 100 the data adapter wizard rejects the Select statement. The actual limit is probably not going to be a problem except that I would like to be sure that I...

In setting up an ODBC link to some external data I have a couple of tables I cannot open if I include fields that have a Date format. VB.net rejects the format. The data is in a Pervasive database and the date format used it mm/dd/yyyy. If I omit these fields from my ODBC Data Adapter query...

I am trying to master creating an ODBC connection in a VB.Net project. It was all working pretty well except that there were a couple of tables in a Pervasive ODBC Engine database that I could not load. In trying to diagnose this problem and, in the process, I seem to have done something that...

I have developed a simple application in in Access (and it works fine) but must now convert it to VB .Net so that I can extend its capabilities. In the process I am learning VB .Net. I need to import a text file, do some data manipulation and merging, then export the result as a text file in a...

I have a simple application working fine in MS Access with some VBA code. It reads a text file generated by another application "A", uses (Pervasive ODBC)linked tables to look up additional information (prices etc) in another application "B" and outputs a "merged" text file ready to be imported...

I have a simple Access application which includes two tables linked via ODBC to data files in another application and it all works fine. I now need to add two more, similarly linked tables. One of them is fine but when I try to add the other one I get the following error - I can open the...

I have a simple ACCESS application that outputs a text file in a particular (odd) format required for importing into another application. The output file has Header and Detail records. The Header contains information on customer code and order number while the following Detail records have...

I need a rough and ready way to parse out Last Name in an excel file where the number of words in the name field is unknown, but I want to get the last one. This will then enable me to sort by surname. For example "Robert Louis Stevenson" becomes "Stevenson" "Robert Ludlum" becomes "Ludlum"...