Search results for query: *

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

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

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

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

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

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

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

Hi, In my Crystal Report (v8), I have a Time-Line running horizontally across the Page Header to determine a 24 Hour Period. The Time-Line is used to express the duration of a vehicle trip (there could be several trips by the same vehicle within the 24 Hour frame). I need a vary-length (width...

Hi Folks, At present, if a user has encountered a screen error message within ‘Windows’ (2000), we it the IT dept have to scurry to the specific workstation and address/resolve each individual message box. The company boss wants the users to refrain from using the ‘CRTL+ATL+PRINT SCREEN’...