Attached is the Powershell error I am getting when I try to run a Crystal Report from Powershell.

Can someone tell me how to fix this error?  I am getting the script from a google blog.

Thanks

Glen
PwrShl_Error.txt

Crystal - Need to return all data that is Left, 6 of the string.

Example:  227800kc04142

I want to return "KC04142"

I have found several MID functions but non based on length.

I want  sum of QuantityPerPallets,Pallets,NetWeight,GrossWeight according to group by  ContainerNo , Departmentseal, LinesealNo wise in crystal report .I have attached the table script.


Table Script : PackingLIST_SQL.txt

I am trying to exclude certain records from the report using the select record expert in CR, but when ever I set up the query like this (see bold part of query),

{investor.holdings} and
(not ({receiver.r_ussname} startswith "NON-USS:") and not ({investor.iaccountid} in ["35048"])) and
{trade.mdate_i} > {?Start Date} and
{trade.settle_i} <= {?Start Date} and
(not ({trade.icobbill} in ["B", "P"]) or {trade.iaccountid} = ["10107","12462","15227","10119","19331","10301","32051","32013","32109"])

CR keeps changing the query structure to this:


{investor.holdings} and
not ({receiver.r_ussname} startswith "NON-USS:") and
not ({investor.iaccountid} in ["35048"]) and
{trade.mdate_i} > {?Start Date} and
{trade.settle_i} <= {?Start Date} and
(not ({trade.icobbill} in ["B", "P"]) or {trade.iaccountid} = ["10107","12462","15227","10119","19331","10301","32051","32013","32109"])

and what happens is that it processes the augments separately instead of inclusively.

I am trying to use (not ({receiver.r_ussname} startswith "NON-USS:") and not ({investor.iaccountid} in ["35048"])) as a way to tell CR not to return records where both the receiver.r_ussname begins with "NON-USS" and the accountid begins with "35048". In otherwords, dont return any records where it is both "NON-USS" and "35048".

Not sure why this is happening, but there are two different tables that I am trying to query against in that statement, maybe that is the issue? If …

It does not appear like my code is fully evaluating the criteria. There are blanks where "N" should appear

The way it should evaluate is it should look for the CPT_CODe first, if a match is found then look to see if any of the DX codes exist in any position (DX1-DX6) then it will look to see if COPAY Due is > 0.00 and COPAY Collected is > 0.00. If all is true then "Y".    If anything past the CPT_CODE is not true then "N"

Preventive Y/N column - The blanks appear to be False after the CPT_CODe because no other criteria is found but do not indicate "N" they appear as Blanks and not sure why. See attachment for data.

Using formula Editor - Crystal  

if {Command.CPT_CODE} = ["44388", "44389", "44392", "44393", "44394", "44401", "45300", "45305", "45308", "45309", "45315", "45320", "45330", "45331", "45333", "45338", "45346", "45378", "45380", "45383", "45384", "45385", "45388", "74261", "74262", "74263", "G0104", "G0105", "G0106", "G0120", "G0121", "G6019", "G6024"]
and
(
{Command.DX1} = ["Z01.89","V10.00","V10.05","V10.06","V12.72","V12.79","V16.0","V18.51","V70.0","V72.31","V76.41","V76.50","V76.51","V76.52","792.1","Z00.00","Z00.01","Z01.411","Z01.419","Z12.10","Z12.11","Z12.12","Z12.13","Z80.0","Z83.71","Z85.00","Z85.038","Z85.048","Z86.010","Z87.19","R19.5"]
or {Command.DX2} = …

Hi all.

I'm trying to create a Crystal Report (2011) that displays the AccountNumber, ProductLine and Sales from myTable based on the following criteria:

(1) SalesDate >= {parameter.StartDate} and SalesDate <= {parameter.EndDate}
(2) The AccountNumber can not have already had a sales for the ProductLine one year before the parameter.StartDate

So if the parameters are: StartDate = 02/01/2018 and EndDate = 02/28/2018
Then the ProductLine must have a SalesDate falls between 02/01/2018 and 02/28/2018 AND can not have a SalesDate fall between 02/01/2017 and 01/31/2018. The table (myTable) contains all sales records for each AccountNumber.

Any idea how I can do this Crystal Reports? This report used to be an Access report that used a couple of queries to get the final records but I'm clueless as to how to do it in Crystal Reports, specifically criteria 2.

Thank you in advance!

I need to store 2 values in a subreport to pull into my main report.  The first value is the cost from the prior day the second is the value from the current day or most recent day.

For example:

The subreport stores Product Cost by Date, Time and Product.  I have stored the last record to updated to the file.  What I need to do is grab the prior day or prior date price.

NL - 4/2/18 - 1.828
NL - 3/29/18 - 1.892

I need 1.892 for Prior stored and 1.828 for Current Cost stored.

In the Main Report I will pull Prior day and Current day based on time.

How to I align different types of numbers, decimals and currencies in the same column in crystal reports?

I need to develop a report that uses a Users table to compare against the Created_by and Modified_by fields in another table to report a list of the records that were Created_by or Modified_by each user in the Users table.  

In other words, the Users table has a userid that an application inserts into the Created_by field or the Modified_by field for every transaction inserted into the Transaction table.

I am not sure how to cycle thru every user to either show the transactions that the user created or modified or state "No transactions entered for this user."

Any guidance on how to set this up would be greatly appreciated.

How do i get the percentage from the "total votes"

SELECT
    D.CONTESTID, C.CONTESTNAME, D.CANDNAME,
    NVL(D.VOTES_EV, 0) + NVL(D.VOTES_AB,0) + NVL(D.VOTES_ED,0) + NVL(D.VOTES_EPROV,0) + NVL(D.VOTES_PPROV,0) "TOTAL VOTES",
    NVL(D.VOTES_EV,0), NVL(D.VOTES_AB,0), NVL(D.VOTES_ED,0), NVL(D.VOTES_EPROV,0), NVL(D.VOTES_PPROV,0)
FROM
    ERUSER.RES_CAND D JOIN ERUSER.RES_CONTEST C ON D.CONTESTID = C.CONTESTID

I am using Compulink Advantage version 12.  I have previously successfully created and added custom crystal report to the menu.  Two reports are giving me problems.  They will not launch.  They are visible on the menu.  However, when I launch the reports I receive message, "Unable to Locate Report: [report title]".  Has anyone experienced this problem?