Search results for query: *

Hi, Using Cr9, accessing Lotus via ODBC Form/Table is Care Plan & holds details for recurring shifts for a service user, with start & finish times for each shift. Field names: {CarePlan.BedMondayFrom1}, {CarePlan.BedTuesdayTo1}, {CarePlan.LunchTuesdayFrom2} etc. There are potentially 56 shifts...

Hi, I'm usng Crystal 9 & accessing Lotus Notes via an ODBC connection. I'm calculating shift durations from a form which has the start time & end time of the shift, but doesn't calculate shift duration. Most shifts start & finish on the same date, but I have some shifts which start at 22.00 &...

Hi, Our accounts system groups our sales into nominal codes, where the third number = sector. Is there a way I can write a Selection Formula to only return records from SL_Analysis.SACODE where the third number = 3 (for example). I've currently trimmed the field of the first 2 digit & am...

Hi, I have a field of user actions, such as below: Staff Member NF selected by CW Client Confirmed with HELEN with Ref : 0909004045. Entered by CW Booking Edited by CW Staff Cancelled reason working 3 nights wants two days off by KP staff member was NF Booking Edited by KP Name Change Set By...

Hi, Our IT dept can't fix this on the database (Lotus Notes 6.5 accessed via ODBC) for me at the moment, & the job is quite urgent, so need a work around for poor data entry. I'm using this formula numberVar dur:= datediff("s",{@ShiftEnd},{@ShiftStart});//get the seconds between 2 dates...

Hi I am using Crystal 9 to read an Notes database through ODBC. The select distinct records option is selected, yet my report is returning duplicate records (even though I can't see them in the database, I am waiting for the DB desigenr to come in). Can I select distinct records by using the...

Hi, This is more an advice query rather than a specific. I work for a fairly IT illiterate company,(some staff are still unsure about what the mouse is!!) but we need staff to get their own information out of the databases for management meetings etc, rather that rely on one or two members of...

Hi, Using Crystal Reports 9 on SQL Database. I have been asked to show clients placing orders on a "regular" basis - weekly, fortnightly & monthly. I have grouped my clients weekly, which means that there are weeks missing if they haven't ordered anything. How do I now just return those with...

Hi, My boss wants a report that looks at the next 20 records after the Top N (20) records, without having to count them out himself. Is there a formula that I can use to exclude the first set of results in a top N sort? Cheers Alex

Hi, We are trying to move data from an Microsoft Access database, to one in Lotus Notes 6.5, using Crystal Reports 9. When we try to export a column of data via the ODBC driver we get a message "Failed to Export the Report. [Lotus][ODBC Lotus Notes]Table/View/Index/Column name exceeds maximum...

Hi, I'm using Crytal Reports 9 to query Notes 6.5 All the data I'm querying is in one table - Notes not being relational 'n all. Notes date/time stamps every edit of the form in one field & records the action & user in another. Each entry is finished with a carriage return, so it looks great...

Hi, Can someone let me know what I am doing wrong with this formula, it only returns the correct data relating to the first part of the statment. If I swap the "e" & "E" around it just works the other way. I have tried the lowercase function, but am not entirely sure where to put it - any help...

Using Crystal 9 to query Notes 6.5 Each document in our notes database has an editing history which (as far as I am aware) can grow infinitely. When I use the field "EditHistoryEventList" in Crystal it is only returning the first 254 characters. I may need to analyse data beyond the 254, is...

I have a query in Access, that is going to a report, that is then exporting to Excel. One of my fields, in the Exported File needs to return text: "Day", Night", "Sat", "Sun" etc based on character values in one field in another table. I would like to write an Iif statment that allows me to do...

I have just beeb able to connect to out Notes databases this week. I am trying to filter results with Select Expert & Record Selection formula ofr "does not start with" - if I use "and" between each expression I get no results, if I use "or" nothing is filtered. Where am I going wrong as this...