Recent content by n2nuk

I have a user who is having difficulty accessing the corporate network using a works laptop. a hardware vpn device is used to gain access. the user can log in OK but is not able to access network resources and the time is set to date and time in October 2019. I suspect the issue is dues to the...

That's worked a treat, apologies with the confusion with the tonumber syntax. Many thanks Lbass and for persevering with me!

Hi Lbass, Many thanks once again. the formula is (tonumber(totext({client.dob},'yyyyMMdd' ))0,""))) the dob field is a date datatype The full formula with the other fields concatenated to it will look like left({client.forename},1)&...

Still no joy!! I have copied it exactly as described. I have taken out the other fields to exclude any other factors that may be causing this. (tonumber(totext({client.DOB},'yyyyMMdd')0,"")) still receiving the same error

Hi Lbass, I am getting an error "The ) bracket is missing" when I validate. I have entered the text as per your post left({client.forename},1)& left({client.surname},1)&(tonumber(totext({client.DOB},'yyyyMMdd'))0,"")&{client.gender} I have even attempted to move the text in between the first...

Hi there, I am trying to generate a key based on the clients initials, gender and date of birth. I have produced a key by using the formula below, however the date is presented with commas, is there a way I can remove these? left({client.forename},1)&...

This is a bit of a longshot as my query relates to using Web intelligence report writer built into Business Objects. I have recently started with a new employer who use SAP Business Objects, I am having to familiarise myself with the web intelligence tool to produce reports and have an issue...

Hi bob and lbass Thanks for input, this returns the data, however is it possible to return the H&S status from the SQL expression? that way i can exclude the H&S visit table from my report. I think this is reason the table owner has to be prefixed on the tables that are not included in the...

Hi there, I have a table of health and safety inspections by organisation. most organisations will have had more than one H&S inspection. I would like to return the latest H&S result for each organisation. I understand that grouping and sorting the columns by date will get work as well, but i'd...

Hi there, I was hoping to re-use a solution provided by Lbass on thread thread767-1794186 This report is to assess the outcome of assessments undertaken with clients. When we start work with a client a start assessment is completed that generates a score. during our work with the client...

lbass solution did the trick, many thanks

Thanks for replying, not sure how i would get that to work?!

Many thanks Lbass, worked just i wanted it to. Thanks again

Hi there, I have a table that records a clients support level, this can change during the course of their treatment between medium low or High attached is a sample of data client_id_______priority_level_________priority_startdate________priorty_enddate...

Hi there, I am attempting to report on outcomes from a client interview, the front-end allows workers to select multiple values using a check box. the values are stored in the database as a text field concatenated by a $, for example Advice given$Escalate to Intensive Service Signposted$Advice...