Recent content by CrystalizeCanada

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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