Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: n2nuk
  • Content: Threads
  • Order by date
  1. n2nuk

    using a work laptop to connect to corporate network

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

    formatting a date within a concatenated field

    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)&...
  3. n2nuk

    Removing duplicate rows from report

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

    Return value from table based on max date

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

    Comparing scores and summarising into a table.

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

    returning the latest (max) value into a crosstab

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

    Ability to use a formula on a specified column on a crosstab

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

    Page footer printing on every page instead of last page

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

    SQL Expression date conversion error

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

    Count number of entries from a multi value field

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

    Migrating reports from CR server 2013 to CR Server 2016

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

    Reporting on missing fields

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

    Filtering results based on a running total

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

    Grouping and Sorting: Custom display order

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

    Return only the first work week

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

    Combine values from rows into group

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

    combining data from multiple tables into a single field

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

    Return previous activity

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

    compare multiple dates

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

    shared variable from subreport

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

Part and Inventory Search

Back
Top