Search results for query: *

Can you have an ODBC data source path to more than one directory for the files you want to use in a crystal report? I am trying to create a crystal report form ACCPAC Pro Series data (VFP5.0) and the data is grouped in seperate folders according to the module: ARDATA for all accts rec data...

I am having difficulty with the syntax for a simple "left outer join" select statement. Can anyone give an a quick example of the exact syntax? Something like this--- Select a.custno, a.name, b.code; From custno a, secno b; Where a.custno = b.custno ; Into table newcust I'm not...

I am having difficulty with the syntax for a simple "left outer join" select statement. Can anyone give an a quick example of the exact syntax? Something like this--- Select a.custno, a.name, b.code; From custno a, secno b; Where a.custno = b.custno ; Into table newcust I'm not...

After using CRW for some time, I am realizing I could benefit from some formal training. Question is, I would like some opionions on what is the the best (and cheapest) way to go. Classroom? On-Line? CD Tutorial? What are your suggestions?

I wasn't familiar with a data identifier "P", but the formula ="*"&A1&"*" worked just fine! Thanks for the help!

I'm trying to create a Spreadsheet template that will have daily Inventory Receipts dumped into it. I want to list the Item number and have a formula in the next column to display the barcode of that item. I've tried a few ways but none are working. Does anyone know the exact syntax for a...

Ken, That solved it!! Thanks for explaining it! Nadine

I am using the record selection option to exclude the records from the report. That is why I am at a loss as to why the total is off. I did try running total and I get the exact same result as the sum field. I will try and take the report apart and see if I can find out why the total doesn't...

My report reads a detail file and selects only records with a transaction date within a given date range. It also links to the matching header file and grabs a numeric field when the job# matches.... therefore not every header record in the file would be listed on the report. The selection works...

It wouldn't work using free tables, but once I selected the "Visual FoxPro database (.DBC) and pathed to C:\directory\*.dbc it worked fine.

Bingo! Did not realize I had to setup the ODBC to path to the Database container path. Thanks for the reminder.

I have never tried to access a VFP7.0 table (usually deal with Mas90 data or SQL) so I tried to create a quick report to test it out. I created a data source named Visualdata and had it point to the folder where my DBF's are. When I go to select the DATABASE (using the wizard) and select the...

Thanks for your quick response... I'm assuming an Oracle client is some software that would be being used already by the end user for whatever they are doing. I just want to make sure that we cover all parts of what is needed to get them started creating Crystal Reports with Oracle. Again, I...

I have to create crystal reports using an Oracle database(know nothing about Oracle). Is the ODBC driver for Oracle something that I must purchase seperately from Crystal? Does it come with all the other ODBC drivers? Is there a guide or manual that could help explain how to use CRW with an...

My report uses 3 subreports to calculate a balance field. The report is grouped by agent's number and the sub-reports are executed in 3 different sections in each group footer. The 'netbal' field is then calculated from shared variables and printed in the 4th section of the group footer. Is...

Not sure what requirements, but most likely Standard will be fine. Thanks-

Does anyone have thoughts on which version of Crystal Reports to use? The two are "Standard" and "Professional" and their website gives a list of the features, but I'd like someone else's input. The price difference is about $200. Do you really need professional to create...

Is there such a thing as an 'executable' report. In other words, can I email an executable crystal report to someone and they can run it w/o having Crystal installed on their system?

I've written a report that displays a balance forward - then lists all charges (subreport)-- then all checks(subreport)-- then new balance at the bottom. Its a statement for vendors. To get the opening balance, I use 2 subreports, one to get the sum of all charges and pass the value to the main...

Thank-you for your response, however, I probably didn't make myself clear enough. I am modifying a Pick Ticket form using Crystal Reports. The actual software that is reading the barcoded fields is Radio Beacon (WMS) and one of the reguired keystrokes is an F9 key. I'm trying to create a...