...the form of Pty Ltd, Pty. Ltd. and P/L
What is the syntax for using an IF OR statement? I think the one I figured out is an AND statement (where all three conditions must be met).
{IF {<<Offender>>}= "*PTY. LTD." IF {<<Offender>>}= "*PTY LTD" IF {<<Offender>>}= "*P/L" "" {<<Offender>>}}
Thanks
...teh following formatting I am still seeing all the results, and this includes those where the offender name contains "Pty".
{IF {<<Offender>>} = "*pty*" "" {Offender}}
What I would like to see is that if any Offender has a Pty at the end of their name, then they are considered a Company...
...If the {offender} is not a company, then use the {offender} details.
I have started with the following however when I merge the document, I am still seeing results with PTY LTD at the end.
{IF{Offender}={"*PTY LTD"} "" {Offender}}
What am I doing wrong?
Any help would be appreciated.
Thanks
Hi,
I am trying to create a select query which will show me only the records which have a value in 2 fields. I have tried the below and it seems to work okay except that i am still getting some records which have an 'empty' Text17. In the example below I do not expect to see the 2nd and 3rd...
Hello,
I am hoping someone can help with a code or similar to import csv files into Visio 2003/2007 (we have both).
We have a document management system (DMS) which has a workflow engine. Long story short we need to get these workflows out of the ECM and process mapped in preparation for a new...
I wasn't getting anything at all.
I retested it and found that there is actually a space before WW which I couldn't see. I copied the data directly from the table and then found the space.
I then amended the "WW" to be " WW" and it works fine.
Thanks for your time :)
...which I want to identify which ones contain 2 specific values.
my formula is as follows:
if {Jobs.Site} = "WW" and
{Jobs.CustomerName} like "ABC*" then
"Accept"
So within my Jobs table, I have two things I want the report to look for and if they BOTH match, to use that result. It cannot...
Hi,
Is there any way to create a field etc to allow the name of the user who printed the document to show?
For instance
Report Printed by: {@username}
We create the reports through CR 2008 and they are run by end users on terminals (they log into the terminals using AD) through an MIS. We...
Hello,
We are currently using CR Server 2008 to schedule reports that are created in CR 2008. All working fine from that perspective.
One of the finance guys has asked about the repository and saving data in there which can be used with various reports (from what I can tell, he believes that...
Hello,
We are currently using CR 2008 as well as Crystal Server 2008. One thing we have found is that CS is fiddly when it comes to updating existing reports.
The process we are currently following is as follows:
1. Develop report in CR 2008 on separate server.
2. Log into Crystal Server and...
I went another way with this which kind of sorted my problem.
I grouped by job number and then used the maximum of the journal entries (based on date) to give me the most recent description.
Because there are many types of journal entries, I used a formula
if ({Journals.Description}) =...
...not need to appear on the report.
I thought I could have something like
@Restarted
if {@On Hold} = "On Hold" and
if {Journals.Description} like "*In Progress"
then "restart"
However I think my syntax is out as I get an error "The keyword 'then' is missing"
What is the proper syntax...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.