Crystal Reports Forum

Cross Tab Report- Suprressing unwanted columns

Thu, 05 Feb 2026 06:29:19 GMT

The best way I found to handle such scenarios is to create a grouping formula where the viable data would be grouped as one label (like "Display"), while the rest in another (like "Ignore").
You then insert this formula at the top-level column of the crosstab and in the sort order choose "Specified Order" and select your "display" valued group while ignoring the "Other".
This method serves several purposes, mainly does not require adjustments to the selection logic and not having suppressed empty columns which still occupy space in the crosstab.

Isolating Part of a Date Field

Mon, 30 Jun 2025 04:07:06 GMT

Thanks. The issue that gave rise to my question ended in December, but could come up again. I'll be sure to remember this!

Isolating Part of a Date Field

Fri, 27 Jun 2025 08:15:19 GMT

Long past the ask.

I would have used mid({field}, 11, 1) = 8 or 6.
Would have made the mid({field}, 11, 1) a local variable as I hate typing.

Just a thought

Converting multiple rows (CPT Code per Encounter)

Fri, 27 Jun 2025 08:12:44 GMT

Hi,

I am sure that you found an answer.
What I would have tried is to make a subgroup for the encounter and have that grouped by CPT code and only display the header or footer of the CPT group.

Just a thought

Count in Group Footer Showiing in Group Header

Fri, 21 Feb 2025 06:10:27 GMT

Hello All,

I found the answer in another post. I used the formula;
sum({table.field_to_summarize, {table.field_you_are_grouping_on}) and it worked.

Thanks.

Count in Group Footer Showiing in Group Header

Fri, 21 Feb 2025 04:37:40 GMT

Hello All,

I have a Running Total Field that shows the count in the Group footer. How do I get that count to show in the Group Header? I want to hide the Details in the report and just show the Group Header. I have tried WhilePrintingRecords, but it shows that count in the next Group.

Example;

GroupHeader-xyz-customer (Count=3)
   Detail-Job123
   Detail-Job124
   Detail-job125
   GroupFooter-(Count=3)

Hope this makes sense.

Converting multiple rows (CPT Code per Encounter)

Mon, 27 Jan 2025 10:22:53 GMT

I have been asked to try to covert unique records such as MRN that’s been grouped in crystal already, but the issue is that its listing the CPT code for the same encounter in multiple rows. Checking to see if there is a simple way to convert those multiple cpt code rows into its own respective column. See example below……

Currently as

Patient 1 (Grouped)     Enc # 111111     CPT 714.5
     Enc # 111111     CPT 700.5
     Enc # 111111     CPT 800.0
Patient 2 (Grouped)     Enc # 222222     CPT 900.4


Would like to convert to

Patient 1 (Grouped)     Enc # 111111     CPT 714.5
CPT 700.5     CPT 800.0 ALL ON ONE ROW
Patient 2 (Grouped     Enc # 222222     CPT 900.4 ALL ON ONE ROW



Thank you! Any advice would be greatly appreciated!

Accessing SOS Legal database from Crystal Reports

Tue, 14 Jan 2025 04:46:45 GMT

Does anyone know how to access SOS Legal from within Crystal Reports please?

Isolating Part of a Date Field

Mon, 30 Sep 2024 04:22:33 GMT

I have a need to compare values in a table, but only report on those where a part of the data is a mismatch. The data in the field in question would be in the format of 010-4XXXX-8XX. This is for properly recording the general ledger account number for invoices. I'm only interested in instances when the 8 in this field isn't the same in all line items for each invoice number. There will be cases where some of the entries for the invoice have an 8 there and other entries for the same invoice will have a 6 there. The rest of the digits in the field are irrelevant. I only need to report on those where there's a 6 and an 8. All sixes or all eights are correct. There will be at least two, and maybe more, line items in the table. The constant in the table is the invoice number.

No clue how to query for this. Any suggestions? Thanks,

Grouping totals by consecutive dates

Wed, 10 Jul 2024 06:49:19 GMT

I realize this is a somewhat old post and I hope you were able to figure this out.

It looks like you're trying to get the daily and weekly sums of the number of units. If that's the case, here's what I would do:

1. Add two groups on the date field - the first one is at the weekly level and the other is at the daily level.
2. Suppress the details section and both group header sections
3. Create a sum of MANUM using the following as a template an put it in the Daily date group footer:


sum({table.Unitsfield}, {table.datefield}, "daily")

Put the date field and this formula in the daily date group footer.
4. Create a similar summary formula for the "weekly" date group footer that will contain the "group of XX units for date range for same MANum" text.

-Dell