Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CrystalizeCanada

    Consecutive Reads

    Nice work Paul ! that sounds like a very efficient solution Gordon Crystalize
  2. CrystalizeCanada

    suppressing the second record that matches the formula criteria

    Previous functions work on the detail record and if the day group has multiple records then this would explain the results. So we can use a variable instead. Create a formula placed in the SubjectId Group Header. WhileprintingRecords; BooleanVar Result := false; Create a formula and place it in...
  3. CrystalizeCanada

    suppressing the second record that matches the formula criteria

    I'm not sure why using the previous and next functions would not work in this situation. Have you tried creating a separate formula to mark the records that you don't want to keep. {table.results} = previous({table.results} and {table.subjID} = previous({table.subjID}) then 'Suppress' and then...
  4. CrystalizeCanada

    How to ignore records in a lookup table?

    A formula along these lines may be what you are looking for: if isnull({table.PricingPromo}) or {table.PricingPromo}='' then select {Table.CustomerCode} case 86: select {Table.ProductType} case 'LL':25 case 'LS': 20 case 'PL': 32 case 'PS': 35 default: 1 case 87: select etc...
  5. CrystalizeCanada

    Sub report to return data in correct group within main report

    Create the sub-report and insert it into the ADP Group Header. Link the Sub-Report to the Main Report on ADP Code. Create a formula in the sub-report that captures the value or values you want from the Subreport as a Shared Variable. //This subreport formula captures a field into a variable...
  6. CrystalizeCanada

    Grouping by week in Crystal 2013

    Create a Formula: {Table.Date} - 3 Create a Group based on the Formula Right Click the Group and choose Change Group. On the Options Tab choose Customize Group Name Field: Choose Use a Formula as a Group Name: ToText ({Table.Date}, 'ddd dd MMM yyyy') & ' - ' & ToText({Table.Date}} + 6, 'ddd dd...
  7. CrystalizeCanada

    Force record sort and ignore group sort

    Try the following; Group by Vehicle Id. Leave it as Ascending order (and forget about Original Order as that doesn't seem to be working out) Insert Summary and choose Maximum of the Arrival time for the Vehicle Id Group. Use the Group Sort Expert to now sort the groups based on the Maximum...
  8. CrystalizeCanada

    Subtract previous field value from group of records

    Database, Select Distinct Records also seems to cause the 'original sort' to be lost (on my sample database). If neither Database, Select Distinct Records nor the Record Selection Formula are the culprit then I would experiment with a copy of the report and strip virtually everything out to...
  9. CrystalizeCanada

    Shared Variable Exports Zero (0) to Excel

    Using Crystal Reports 2008 the same behaviour seems to occur i.e. a formula using a shared variable from a sub-report placed in the Page Header section fails to export correctly to Excel when choosing Microsoft Excel (97 to 2003) Data Only. I tried it with a shared stringVar and I got the same...
  10. CrystalizeCanada

    Subtract previous field value from group of records

    The filter may be affecting the order in which the records are returned. Remove the filter and see if the report goes back to 'original sort' order by the group. If it does go back to the order you want without the filter you may want to to take the filter out and use a Saved Data Filter instead...
  11. CrystalizeCanada

    Using Shared Var value in Chart

    As soon as you put a shared variable in a formula it will not appear in the Chart Expert on the Data tab in the available fields section. Consequently it appears that you are not be able to base a chart on formulas that use the shared variable. Shared NumberVar x //This will cause this formula...
  12. CrystalizeCanada

    Subtract previous field value from group of records

    Try: WhilePrintingRecords; //Place in Group Footer if {incident_log.vehicle_id} <> Next({incident_log.vehicle_id}) then ( Time(Next({incident_log.incident_date_time})) - Time(Minimum ({incident_log.incident_date_time}, {incident_log.vehicle_id})) )/60 else 0; Gordon Crystalize
  13. CrystalizeCanada

    RE: Formula Help

    Assuming the report is sorted by OrderId this formula may be worth trying: WhilePrintingRecords; //if the formula works without this line then it may be preferable to remove it StringVar x; if onfirstrecord or {MyTable.OrdId} <> previous({MyTable.OrdId}) then x := {MyTable.OrdQuestion} else x...
  14. CrystalizeCanada

    Reading UP and Down and how to surpress unwanted rows

    One approach using Underlay following section: Create a Group based on Resource Search Create a second Group based on Providers Suppress the details as well as Group footers for both groups. Move the Group 2 Name to the right about 2 inches. In the Section expert choose Underlay the following...
  15. CrystalizeCanada

    the text, ntext and image data can not be compared error

    Try: SELECT "TaskNote"."WOID", "TaskNote"."TaskNoteTypeId" AS 'TypeId', "TaskNote"."TaskNoteCategoryId" AS 'CatId', "TaskNote"."CreateDate" AS 'Date', "TaskNote"."CreatedBy" AS 'Tech', "TaskNote"."NoteText" AS 'Note' FROM "TRACKIT_DATA"."dbo"."TaskNote" WHERE "TaskNote"."WOID" IN ( SELECT...
  16. CrystalizeCanada

    Suppress everything in report by a group name

    If you have to use a Group Selection formula (instead of a Record Selection formula) then yes that is the case - Grand Totals will include values from that group. See note from previous post below: If you end up using a Group Selection formula you may notice that Grand Totals still include...
  17. CrystalizeCanada

    Suppress everything in report by a group name

    Report, Select Expert, Record... {@type} <> 'Own Collection' or not ({@type) like '*Own*') A record selection formula will filter out records (and consequently groups) based on the {@type} formula. If {@type} is not available for Record Selection (this can be the case if the timing of the...
  18. CrystalizeCanada

    Group Issue

    SQL Expressions are not available in the Field Explorer if you use a command in the database expert. The SQL Expressions heading will not appear below the Formula Field heading as it normally does when basing a report on tables. Since you are using a command one option is to modify the command...
  19. CrystalizeCanada

    Create SubQuery with Union Query

    In a UNION join the number of columns must match. The example below will cause an error because I'm trying to UNION 4 fields onto 2: SELECT fielda, fieldb, fieldc, fieldd FROM TableB UNION SELECT this, that FROM TableA Fill in the gaps so that the number of columns match: SELECT fielda...
  20. CrystalizeCanada

    Calculate Headway Deviation

    You're welcome - glad its working Gordon BOCP Crystalize

Part and Inventory Search

Back
Top