Search results for query: *

First of all, lbass, I thank you so very much for your never ending help! From your instruction here, I would have to say I now have a basic understanding of how to work an array into just about any report. Thanks again, LB!

Actually, both groups TopN sorts are based on Sum of @DollarsScrapped. The GF2 is Top 10 parts and the GF3 is Top 2 reason codes. The user has preferred to not include ties on the reason codes at this time. This may be included at a later date.

I am using CR10 and a 3rd party database. I have not yet been successful at arrays. This is one instance where I believe I must use them. I need to show the header and just Group Footer 2 in the report. The information I need to get into an array is in Group Footer 3. This is actually from...

I am using CR10 and a 3rd party database. I have not yet been successful at arrays. This is one instance where I believe I must use them. I need to show the header and just Group Footer 2 in the report. The information I need to get into an array is in Group Footer 3. This is actually from...

I have CR10, Windows XP and am unable to create a function. My needs are quite simple, yet complicated to me. I have three groups and in the detail I have a one field using a subreport and another field which is a calculation based on the value passed from the subreport. Both of these fields...

Let me begin with letting you know that after I add the test for only selecting positive values in the Record Selection and run the report, I always have a window popping up from Crystal, "No data has been found for your selection criteria.". This comes up before the label(s) print. I am...

Unfortunately, LB, I have tried all of your suggestions, but to no avail. There must be something I have overlooked. Anyways, thank you for trying to help, I appreciate it!

I am having a problem with preventing a new page from printing in Crystal Reports 10. This was not created from a template since it is specific to our use. We actually print two of the same labels on the same page (letter size). We call them labels for their purpose. I only need the...

I am using CR10 and do not use Access, nor the repository. We use Progress Software Corporation's database. We have one table containing many parts with a unique id for each. Then this unique id is used to link it to another table which contains 9 text fields which can hold the location of...

When I export a Report Definition, I am usually missing several of the formulas. Of the formulas in the exported report, there are normally several duplicate formulas. Is there a way to get a correct and complete listing of all formulas used in any given CR10 report?

When I export a Report Definition, I am usually missing several of the formulas. Of the formulas in the exported report, there are normally several duplicate formulas. Is there a way to get a correct and complete listing of all formulas used in any given CR10 report?

Thank you, lbass! I really did not realize the importance of order with null tests. It works! Thanks again!

I just tried it and received an error message - "Failed to open a rowset"..."Invalid date escape.". Here is my code (less the actual table name): ( {Table.Date} in {?FromDate} to {?ToDate} or {Table.Date} = date(0,0,0) ) What is wrong?

CR10 I have a date field in a table which is not always filled in, therefore, it is blank. There is also a date range parameter which I must test for. I know how to test for the entered date range, but am not sure what to do about the blank date field. I have tried using IsNull, but it did...

Well, I finally got it to print at the correct label, but it does not print the first record. What am I still doing wrong?

Sorry about that. My initial project is with a part master. The user needs to print a range of parts and be able to start printing at the first available label on the sheet. As for your example, I started over again, but did NOT select the Customer Master AND create the command. It still...

Maybe the better question is the following: Can I force the RecordNumber to be 1 when the following is set? In another attempt, I have set up no command in the database. I have a parameter for finding what label to start printing at, StartAtLabelNo. In a formula, named, LabelCounter, I add 1...

Here is a copy of the SQL Query: SELECT `Customer`.`Customer Name`, `Customer`.`Address1`, `Customer`.`City`, `Customer`.`Region`, `Customer`.`Postal Code`, `Customer`.`Country` FROM `Customer` `Customer` WHERE `Customer`.`Country`='USA' Union All Select Null,Null,Null,Null,Null,Null From...

I started all over again and cannot make it work. I followed your instructions above with the Command, sort, and suppressing blank sections x+2, yet it does not work. Since I am unable to get this work, is there somewhere I can get a copy of a working report?

If I cannot have another parameter, than this will not help. What I amt trying to really accomplish is printing inventory labels. The user is to select the part number range and also what label number to start printing at on the first page of labels. Is this possible in Crystal Reports 10?