Try reversing the order of these clauses:
((IsNull({AP_VEND_PMT_ACT.AP_PMT_TYPE_CD}) and ({AP_PMT_DTL_VIEW.AP_TRAN_TYPE_CD}) = "M"))
OR
(({AP_VEND_PMT_ACT.AP_PMT_TYPE_CD} = "D") and ({AP_PMT_DTL_VIEW.AP_TRAN_TYPE_CD} = "I"))
ISNULL must be the first check that you do.
Bob Suruncle
If you're using SQL Server Management Studio, then go to Tools | Options | Designers and turn off the checkbox for "Prevent saving changes that require table re-creation"
Bob Suruncle
Bob Suruncle
I am using 2016 SP6
Should be the same behaviour.
Double-click the text object to put it in edit mode.
Then click the field to highlight it.
Then right-click and choose formatting.
Depending on the field type the dialog will be slightly different.
HTH
Bob Suruncle
Bob Suruncle
I think that you ought to be able to do this fairly simply.
Create your report as usual, connecting to you Sybase db.
Create a new SQL Expression. Give it a Name - MyMaxDate
(SELECT Max(V.Visit_Date) FROM HEALTH_AND_SAFETY_VISIT V)
In your record Selection Formula, add it to the existing...
Hi,
Variables are placeholders, and can make a formula more efficient and easier to read.
Variables can be named with whatever name you want. The only rules are that they must start with a letter, and may not be the same name as a built-in function.
Your variable name can't be "sum", or "len"...
I don't know what would be causing this database error.
I'm testing on Microsoft SQL Server using the codes that you had provided.
Anyone else have any ideas?
Bob Suruncle
Please modify your group so that the report is grouped on this formula.
You can modify the Group so that it displays the original field as the Group Name.
Bob Suruncle
The following should account for all of the values that you sent.
Local StringVar p := {AR_InvoiceHistoryDetail.ItemCode} ;
Local NumberVar i ;
Local NumberVar L := Len(p) ;
Local StringVar txt := '' ;
Local StringVar nm := '' ;
Local StringVar txt2 := '' ;
Local NumberVar x := 0 ;
Local...
Hi,
It looks like you have some data that is different that what you had first described.
Specifically, there are likely ItemCodes that begin with numbers.
The formula that I gave you will choke on these.
I also noticed that one of the examples that you gave has text, then numbers, and then...
APOS Systems has a product called Storage Center that lets you back up your BI system, and then selectively restore content whenever you need to.
Includes reports, schedules, security, universes, connections, etc., etc., etc.
Bob Suruncle
You didn't mention that you'd be grouping on this, just sorting by it.
I think that if you group on it, and the order comes out correctly, you're 90% of the way there.
Next step would be to use Change Group and on the "Options" tab, select "Use a Formula as a Group Name"
In the X2 button, just...
There are around 20 properties, but the number of properties may change on each run.
We're returning the differences between current values and previous values for these objects.
For a given run of the report, 2 or 3 properties may have changed, but it's possible that 15 or 20 properties could...
OK, there may be a prettier and more efficient way of doing this, but the following should work:
Local StringVar p := {'ESL_Svc_Codes_'.Item Code} ;
Local NumberVar i ;
Local NumberVar L := Len(p) ;
Local StringVar txt := '' ;
Local StringVar nm := '' ;
For i := 1 to L do
(
if NumericText...
Sorry, further testing on my system shows that this will only work if the Numbers are the initial part of the string.
Do all of your item codes begin with the same characters, "/ES" ? (or at least do the numbers always start at location 4)
If so, then you could change the formula a little and...
Hi all,
I'm using Crystal Reports 2016.
I have a report that shows the properties of objects.
The data coming into the report has both the Current value of the properties and the Previous value.
e.g.
PropertyName, PropertyValue, HistoryType
ObjectColour, Green, Current
ObjectColour, Red...
Rather than removing the text you could just format the field to interpret the HTML text.
Right-click on the field and choose "Format Field".
On the "Paragraph" tab of the Format Editor, select HTML from the "Text Interpretation" drop-down.
Bob Suruncle
So you have a COMP/WAPPR pair?
What other pairings do you have that you need to calculate time differences for?
Does COMP *ALWAYS* come before WAPPR?
Would there ever be a WONUM without one or the other of these statuses?
Would there ever be a repeat of one of these statuses for a given WONUM...
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.