Recent content by BobSuruncle

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

In the ToText function, make sure that you use upper case M for the month. Lower case m is for minutes. HTH 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"...

Yes, that seems correct. I'm unsure why you'd get a database error like this. Bob Suruncle

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