<a href=https://matchnow.info>Find Beautiful Girls in your city for night</a>]]>

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,]]>

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

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?]]>

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!]]>

I have a report that I would like to sum on consecutive dates and show that total, then restart the sum and begin again within the same MANum group .

The report looks like this

GH #1 County

GH #2 Service code

GH #3 MANum unique Id contains the reset formula ttlunits:= 0

Details fields: Number of Units, rate, begin date and the below formula

GF #3 MANum contains sum of all units and the sum of consecutive units

GF #2 Service Code

GF #1 County

example output:

7/1/2023 10 units

7/2/2023 5 units

group of 15 units for date range for same MANum

gap

7/5/2023 5 units

7/6/2023 3 units

Group of 8 units for date range for same MANum

I use this formula in the details section:

whileprintingrecords;

numbervar ttlunits;

if onfirstrecord

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday) in [1 to 7] and

{Billings.Begin Date} = previous({Billings.Begin Date}) +1 and

{Billings.Begin Date} = next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday)=1 and

{Billings.Begin Date} = previous({Billings.Begin Date}) +3 and

{Billings.Begin Date} = next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday) in [1 to 7] and

{Billings.Begin Date} = previous({Billings.Begin Date}) + 1 and

{Billings.Begin Date}<> next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday) in [1 to 7] and

{Billings.Begin Date}<> previous({Billings.Begin Date}) + 1 and

{Billings.Begin Date} = next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if {Billings.Begin Date} <> next({Billings.Begin Date}) - 1

then (

ttlunits:= 0;

)

else

if onlastrecord

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

ttlunits:= {Billings.Number of Units}

numbervar ttlunits;

if onfirstrecord

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday) in [1 to 7] and

{Billings.Begin Date} = previous({Billings.Begin Date}) +1 and

{Billings.Begin Date} = next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday)=1 and

{Billings.Begin Date} = previous({Billings.Begin Date}) +3 and

{Billings.Begin Date} = next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday) in [1 to 7] and

{Billings.Begin Date} = previous({Billings.Begin Date}) + 1 and

{Billings.Begin Date}<> next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if not onlastrecord and

dayofweek({Billings.Begin Date}, crSunday) in [1 to 7] and

{Billings.Begin Date}<> previous({Billings.Begin Date}) + 1 and

{Billings.Begin Date} = next({Billings.Begin Date}) - 1

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

if {Billings.Begin Date} <> next({Billings.Begin Date}) - 1

then (

ttlunits:= 0;

)

else

if onlastrecord

then (

ttlunits:= ttlunits+{Billings.Number of Units}

)

else

ttlunits:= {Billings.Number of Units}

For the most part this formula works but there are some anomolies IE:

Units date formula calculation

24 7/1/2023 24

25 7/2/2023 49

gap

24 7/5/2023 73

24 7/6/2023 97 should be 48

Any help would be greatly appreciated and thank you in advance.

Steve

I have some basic formulas I use for reporting that don't seem to work for all.

The two fields below can have null values in them. The default is null, if checked, value is "Y", if checked and then unchecked, the value is "N":

{CI_Item.UDF_PK_ORDERBYKIT}

{CI_Item.UDF_PK_ORDERBYSWK}

I'm doing a very simple calculation for

if {CI_Item.UDF_PK_ORDERBYSWK} = "Y" then ({SO_SalesOrderDetail.QuantityOrdered} - {SO_SalesOrderDetail.QuantityShipped})*{CI_Item.UDF_PK_QTYPERSHRINK}

else if {CI_Item.UDF_PK_ORDERBYKIT} = "Y" then ({SO_SalesOrderDetail.QuantityOrdered} - {SO_SalesOrderDetail.QuantityShipped})*{CI_Item.UDF_QTYPERBOX}

else ({SO_SalesOrderDetail.QuantityOrdered} - {SO_SalesOrderDetail.QuantityShipped})

Most of the items in my report will work, but will make any new items

if also created null value type formulas to force the N and Y and substitute them into the above formulas and have the same result. I've used this in reports over and over and have no idea why this doesn't work here.

My null value type formulas look like this:

OrderByBoxIsNull:

if isnull({CI_Item.UDF_PK_ORDERBYKIT}) then "N"

else If {CI_Item.UDF_PK_ORDERBYKIT} = "N" then "N"

else "Y"

OrderBySWKIsNull:

if isnull({CI_Item.UDF_PK_ORDERBYSWK}) then "N"

else If {CI_Item.UDF_PK_ORDERBYSWK} = "N" then "N"

else "Y"

When I put these fields in the report they show up correctly on 90% of the items, but the rest show 0.

What am I missing? Thanks for the help!

I have limited knowledge of what the Exceptions for Nulls selection does. Currently, that is what is selected in the formula editor.]]>

Hi

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

]]>
Good morning, an employee is attached to a particular cost centre code in our org. If they move to different department they are attached to new cost centre code.

Cost centres and the effective date are stored in two separate tables.

I have tried to use Maximum({Eff_Date}) but this gives the error "Boolean required"

I have a group for the cost centre code and one for the effective date but I cant seem to get a formula working using "Maximum" Does anyone have experience with this?]]>

note:

Total Visit using formula