Crystal Reports Forum : Report Design

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.

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?

Using QR Codes in a report

Thu, 28 Mar 2024 07:04:31 GMT

Anyone have any luck finding a QR code font to use in Crystal?

I have the one from ID Automation and the report takes over 7 minutes to print.

Curious if anyone has had any luck with that?

SAGE WrkTable formulas not working

Fri, 23 Feb 2024 09:11:22 GMT

I'm using CR 2016 for SAGE. The report I'm using can take up to 7 minutes to print. I chatted with another CR expert recently who said the more tables I add, the slower it'll print and that I needed to move all the fields to a work table, which I did.

I placed all the fields that are used in the report in the report header b so I can see if the data is coming to the report ok and it is. The issue is that none of the formulas involving any of those fields work. It's like there is not data there, but I can see it in the header.

Here's an example:

The header displays
{PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} as "PLY"

In this case:
{PM_WorkTicketWrk.UDF_SHIP_LOC1} = PLY
{PM_WorkTicketWrk.UDF_SHIP_PALLET1} = ISPM28X36

Here's the formula (it's in the group header 2a section):
if {PM_WorkTicketWrk.UDF_SHIP_LOC1} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET1}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC2} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET2}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC3} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET3}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC4} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET4}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC5} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET5}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC6} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET6}
else ""

I won't bore you with the other 6 values since the formula should generate a value of ISPM28X36 since it matches in the first if statement.

I put the fields {PM_WorkTicketWrk.UDF_SHIP_LOC1},
{PM_WorkTicketWrk.UDF_SHIP_PALLET1} in the same report section as the formula is in and it doesn't display that either.

The report is very technical and I don't want to re-create it. We print multiple times a day and at 7 minutes per instance it gets aggravating.

I'd appreciate any help! Thank you!

SQL expression formula

Sun, 05 Nov 2023 23:53:54 GMT

I need to set a formula that in sql is like that

select * from anagart where codiceart not in (select code from historycode)

in order to have a list of codart..

How can i do that?

thanks

how to summary from distinctcount result

Thu, 05 Oct 2023 15:53:57 GMT

note:
Total Visit using formula distinctcount(sessionAMPM, episodeno)

how to summary from distinctcount result

Thu, 05 Oct 2023 14:19:38 GMT

Hi,

I have a report as below.
--------------------------------
Group1 dateadm
Group2 episodeno 1                      total visit=2 (AM, PM)
     serviceitem 1    morning (AM)
     serviceitem 2    morning (AM)
     serviceitem 1    afternoon (PM)
     serviceitem 2    afternoon (PM)

Group2 episodeno 2                      total visit=1 (AM)
     serviceitem 1    morning (AM)

Group2 episodeno 3                      total visit=1 (PM)
     serviceitem 1    morning (PM)
     serviceitem 2    morning (PM)
-----------------------------------------

I like to summarize for the total visit in group dateadm.
so, it will be like this:

Group1 dateadm       total visit=4
Group2 episodeno 1                      total visit=2 (AM, PM)
     serviceitem 1    morning (AM)
     serviceitem 2    morning (AM)
     serviceitem 1    afternoon (PM)
     serviceitem 2    afternoon (PM)

Group2 episodeno 2                      total visit=1 (AM)
     serviceitem 1    morning (AM)

Group2 episodeno 3                      total visit=1 (PM)
     serviceitem 1    afternoon (PM)
     serviceitem 2    afternoon (PM)

=======================================

How to achieve it?

thanks in advance.
emir_w

Edited by Emir_W - 05 Oct 2023 at 2:24pm

Repeating Groups

Mon, 25 Sep 2023 09:54:28 GMT

Because all of the data is joined to the fleet ID and there is no apparent relationship between PO, Service Order, and Sublet other than the Fleet ID, you'll need to use subreports for this. Here's how I would set up the data:

1. Main report - Group by fleet ID and show the PO data in the group header.

2. Add a fleet ID group header section below the one where the PO data is located. In that section add a subreport that shows the Service Orders and use the fleet ID as a subreport link to get the service orders for the specified fleet ID.

3. Add a third group header section and put a subreport that shows the Sublet Reference data, using the fleet ID as a subreport link to show just the sublets for the current fleet ID.

-Dell

Asking report to show null along with other data

Mon, 25 Sep 2023 09:48:29 GMT

Add the Employee table to your report and create a left outer join from that table to the inspection table. Use the employee name from employee table and the count of inspections from the inspection table to get what you're looking for.

-Dell