Search results for query: *

I am having trouble using range operators with date fields. I have not been able to find any examples of this in the help files. I realize that I am replacing, (in the SUM function) what would normally be a reference to a group, with another type of expression, so there are multiple problems...

Thank you. That was what I was looking for.

The problem with this approach is that it would allow the detail to run down into the area of the pre-printed form reserved for the summary information (instead of to a second page) when there was sufficient detail to cause this. That is the reason for the page footer, which would always...

I am designing a statement printing report for use with pre-printed forms. I want to be able to print in boxes on the bottom of the form (page footer) when I hit the end of the detail items in the customer number group. My thought is to suppress printing of the report footer objects except for...

My thanks to you both and Steve Hewitt too. I will try the suggestions and advise you of the results here. Just by looking, they appear to be right on. Thanks again. Phil

1. Is it possible to set up Win 2000 Server to initially be part of a workgroup as opposed to a domain? That is the way I have it configured, now but I can not see any other computers on the network and other computers on the network can not see the server. 2. Is it possible Win 2000 Server...

I used the running total, just as you said. It worked great. I was aware of it but I hadn't used it much and it seemed redundant in that it seemed to duplicate sub-totals,etc. and frankly I forgot that it existed. Now that I have a good use for it, I'm sure that I'll be using it more in the...

To IdoMillet: I liked your answer best because it is simpler and I will use it. I would like to give it a star but don't know how. To gdillz: Your answer would work too. I very much appreciate the time and effort you both took to offer solutions. In regard to your question about whether...

Here are two ways to do this: 1) Use COPY STRUCTURE EXTENDED to create a new table that contains the original structure, using one record to describe each field in the original. You can then append this table with the data for the new fields. Then use this table to create a new table with the...

I am writing a tax report, based on invoices. The lead table (from which all links originate) is the “invoice item” table and it is linked into the “invoice” table that contains the information about the invoice as a whole (customer number, ship to, method of payment, etc.). The tables keep...

We are a POS company trying to incorporate a customer signature into an existing invoice.rpt. We are having two problems: 1. What is the best way to link the image file to the report when the pathname is dynamic. We can put an alias in a file at a fixed location, but we have to get the alias...

Your reply forced me to think about this a little more. I think this is an impossible task. If the record selection criteria that is passed to the report, is for a period that is less than year to date (for instance the last month), then the record set that crystal uses, after pass 1 of the...

I could use some suggestions about how to use different selection criteria on different columns in the same report. My company develops and markets POS (point of sale) software and a client wants one of our reports modified to add Year To Date sales for best selling products in addition to...

Ken, Thanks for your help. I found a way to avoid using variables altogether. In the detail band, I used the following: Remainder(RecordNumber,20)=0, Which will only allow 20 records in the detail band. Therefore a fixed length detail band. Unfortunately, I would like to allow "can...

Sorry, I don't think I made myself clear. The example I am looking for, would be one that prints a report on pre-printed forms, not one that demonstrates the use of a variable. For instance, using a report header, a fixed height detail band and a report footer that is fixed to the bottom of...

www.dbase2000.com I think you will find answers to your questions here.

I am creating a report to print invoices on preprinted forms. Our normal invoice is done in Crystal for use with blank paper. I am doing a custom for a customer that can't use the normal one. A few days ago (12/28)I posted to this forum and asked for help on how to control the size of the...

I need to count the number of records processed in the detail band. I am assuming I need a global variable to do this, in order to retain the previous count for each pass through the band. In most programming environments you would not declare a global variable here, as it will be re-declared...

This is one of those situations when I must use Crystal even though it is not the most suitable tool. The problem I don't know how to solve, is how to keep the detail band, the same height, regardless of the number of invoice items. Otherwise, I won't be able to hit the boxes in the...