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

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

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

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

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

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

Does anyone know how to find out what values are needed to barcode a particular function key? I'm trying to streamline the "Pick Ticket" function by barcoding the actual keystrokes needed to process the pick. I've tried '*'+ chr(27) + chr(67) + '*' but it doesn't work. I've looked in...

I need to modify a form's checkbox so that it is defaulted to already being checked when entering the form. I have tried a variety of things and NOTHING works. I am using VFP 7.0 SP1. Anyone know of a simple way to do this? Appreciate any help I can get. NLohrey