Search results for query: *

Hi Ian, I've created the 1st part and dropped it in the report 'Details' section and then added the 2nd part in the 'New Page After' Section Expert but it still restricts the output. Also, the 1st page is now blank. I do appreciate your help though. Neal

Using Crystal 10. Hi, In a report I need a page break on every 23rd record. There are no Groupings in this report and I have tried the following code in the Section Expert (New Page After): not (onfirstrecord) and (RecordNumber MOD 23) = 0 However, due to other formulas, the Record Number is...

Excellent... Many, many thanks.

Hi, I'm using Crystal 10 and need to create a formula that outputs a date (dd/mm/yyyy). I have a start date and a numeric field which represents the Date increment. What I need to do is output the result of Start Date + Numeric - but incrementing using a count of 'Working Days' (Monday to...

Hi, I need some help regarding total counts in Crystal 10. I have a field called 'Status' in a table named 'Sample'. Currently there is a formula at 'Record Selection' level which filters/returns all records equal to 'U'. This is the correct requirement (see below). There are several values...

Is there a method of populating the 'discrete value' drop-down box of a parameter using Basic Syntax?

Thanks Dave, I was hoping that I'd be able to over-come this using a formula, but sounds like it's a wild-goose situation without the up-grade. Thanks again,

Hi, Using Crystal v.10 I'm trying to create a series of four parameters based on field values from 'tblMill' a SQL server table (ODBC connection). The fields have a relational hierarchy structure within the table. The fields are 1. Company 2. Division 3. Site 4. Plant and I need a parameter...

Thanks. Unfortunately, I still have a problem with this. (if {?Product} <> "All" then {SAMPLE.CL_BMS_PROD_CODE} = {?Product} else if {?Product} = "All" then true) The {SAMPLE.CL_BMS_PROD_CODE} string is 50 chrs long - but only populates the first 4 chrs. First If I select 'ALL', OR, if I...

Above should read 'Crystal' Syntax, NOT 'Crystal Basic' Syntax.

Crystal 10. Hi, I am need to create a {?Product} parameter that can be several individual product code values and/or a range of the same product code values. This is in 2 parts. Part 1 When editing the parameter, I believe that I need to select the follow options: 1. 'Allow Multiple values'...

K, Many Thanks! Neal

Hi, I'm using Crystal 10. When outputing details Lines, I need to limit the amount of lines to 15 per page (before the Report Footer). If there are 16 to 30 lines, these have to be displayed on the second page (31 to 45 lines on the third page, etc). I believe that this can be set in the...

To explain further.... Basically, the 'Total' field is adding the supressed values to the final amount. The 'Detail' field contains Positive and Negative values (as well as supressed values). Other 'Total' fields within the report are OK where 'Detail' fields Positive values and supressed...

Hi, Please can someone help? I need to display a Group Total (Running Total/Sum of) of all fields shown. But - it must exclude the 'supressed' values. Do I need to use a formula? If not, what do I need to set? (NB: The supressed values are duplicated values). I'm using Crystal Version 9 (and...

Hi, I am trying to get a 'Count' of field occurrences at group 2 level - but at present it is always being reset to '1'. How do I 'Count' the field occurences at group 2 level? For example if: Group 1 = Employee's Name Group 2 = Duties performed Group 3 = Time taken AND.... Joe Bloggs...

I am using XML Version 1.0 in Windows 2000 and XP. I am converting XML output from Crystal Reports (version 10). Having produced successful xml output in XMLSpy using a prefix (thanks to previous advise from Michael Kay), I have since found that a third party 'message router' application will...

Many thanks, Neal

Hi, I have a database field of 'Customer', and need to establish how many times the customer appears in a report-total field. Do I need to create a 'running total' field and base it on a 'distinct count'? The report should show that a Customer has appeared x times and I need the Customers...

Thanks guys, Just one more thing, How do I determine the 'x' positioning of a field? If, for example, my base(starting position) for field 1 is 4.010cm how do I determine the twips equivalent for the Top/Left position, as well as the field width in twips? Thanks, Neal