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...
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 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...
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...
Hi all,
I have a inserted a text box on the page header. I want this to appear on the last page, but it prints on every page, any way to stop it from doing that?
Many thanks
Naz
hi there,
I need to produce an sql expression that will give me the number of contacts between two dates. the back-end db is SQL server, but the SQL expression fails with an error that reads
'conversion failed when converting date and or tie from character string'
the sql syntax i am using is...
Hi there,
Is it possible to count the number of entries i have in a multi value field, each value is separating by a colon (,) and in some instance can contain upto and above a 1000 entries. the field looks like 4532232,5565443,3434343,5656556,23234344,..
Thanks in advance
We have recently had a new installation of CR 2016 on a new server. We already have an existing CR2013 server that contains around 500 reports. I want to move the reports across to the new platform but am not having any luck in find a utility that does this.
The only option i can see at the...
Hi there,
Hope someone can help with this query, I am working on a patient care system that contains assessments which are recorded every 6 weeks.
Each assessment contains 12 questions that are scored 0 to 5. 0 being used to record a question that is not applicable or a non issue. This means...
Hi there,
I am reporting on a database that returns the membership cards that have given to users, where its possible that some users have had more than one membership card if they have lost the one they have been allocated. its also possible for users to have multiple cards of different types...
I need to produce a report that i can use to count the number of instances or episodes of contacts that occurred within 72 hours of the initial contact being recorded.
I have currently grouped my report on the individual record and then by date and time. The 'section will be printed' drop allows...
I am working on a HR report where i need to return a work pattern for each employee. A work pattern is the number of hours worked for each employee. As we have part time workers it is possible for an employee to work monday, tuesday and thursday.
When a new employee starts they are a allocated...
Hi there,
I have a dataset containing the following data
group - client 11111 - Fred Bloggs
Status_start_date status_end_date Status_code
26/01/2016 CAL
07/04/2015 19/09/2015 CAL
24/09/2014 13/01/2015 LSA
01/03/2014...
Hi there,
I am after some guidance and assistance on how best to do this, i'll do my best to describe how data has been recorded.
We have a client management system that we use to track family records. each family is made up of the parent record, the siblings and any other relations.
there...
I have a report of clients that were engaged in a particular activity during Oct to Dec 2014.
What i would like to do is to return the activity they were engaged in prior to the activity that i am reporting on
Any ideas how i can do this?
The data i am returning comprises of the following...
I could really help with some advice on guidance on how I go about this
I have a set of assessment records that each have a date stamp.
what I need to find out is the number of days since the latest assessment and the number of days between previous assessments
for example
assessment...
I have created a shared variable that is returning a date from a subreport to my main report. I have placed the sharedvar field in group b. My subreport is in group a. This is working fine.
The reason for returning the date from the subreport is so I can use it calculate the number of days...
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.