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!

Register Log in
  • Congratulations derfloh 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: *

  1. Commandolomo

    Infoview Experience

    I apologise! I work for a management information team for a Public Sector department, and we are soon to roll out Inforview across our dept. I have been asked at the 11th hour to come onto the project, formerly taking on my role next week - I wanted to get some background info from current...
  2. Commandolomo

    Infoview Experience

    Hi everyone My company is soon to implement the use of Infoview for colleagues’ across the corporation, and I was wondering whether anybody has had any experience of using Infoview, and if so has it been a positive / negative experience? Any potential pitfalls? Regards
  3. Commandolomo

    Finding Reoccuring Values

    Bingo!!! This works a treat, thank you so much for your time and effort PHV Regards PJL
  4. Commandolomo

    Finding Reoccuring Values

    I think I may have clouded what I want to achieve - I apologise. I want to run an SQL script to return just those records from the dataset where the Client_ID appears more than once. In the example below.......... Client_id Reference Number Name Order_ID 1 79741...
  5. Commandolomo

    Finding Reoccuring Values

    I have ran the above query, and it has returned no rows/records. I have manually doubled checked, and there are definitly separate records that have the same client_id - thus dupes. This continues to confound me! Many thanks for your continued time and assistance PHV
  6. Commandolomo

    Finding Reoccuring Values

    The dataset is about 4k records, but those instances where there are more than 1 instance of the client_id per record should only be about 1 or 2 - that should only be around 2instances of a duplicated client_id. Thanks for your time PJL
  7. Commandolomo

    Finding Reoccuring Values

    PHV Many thanks for your reply, yet I am not getting the results I expect! The query is returning no records, yet I have previously exported the data into excel, and via some manual calculations, I know there should be about 20 records where the same mo.Client_ID appears more than once. As...
  8. Commandolomo

    Finding Reoccuring Values

    Hello All Is it possible within an SQL statement to only bring back those records which have multiple instances of a value? For example, the code below returns all orders as per the conditions :- select (vc.Title + ' ' + vc.Fname + ' ' + vc.Sname) as clientname, (vl.house + ' ' + vl.street +...
  9. Commandolomo

    Differences between BO v.5 & v.6

    Cheers guys, many thanks for the info. Take it easy
  10. Commandolomo

    Differences between BO v.5 & v.6

    Does anyone know of the main differences between v.5 & v.6 of BO? Apart from the graphical display, is there any increased functionality at the report level? Cheers in advance for any info
  11. Commandolomo

    Working Days Function

    Hey y'all Many thanks for the advice - I tried to variables ideas as per the suggested thread and it worked a treat - nice one! Cheers
  12. Commandolomo

    Working Days Function

    Many thanks for your help
  13. Commandolomo

    Working Days Function

    Many thanks for your time and help.
  14. Commandolomo

    Working Days Function

    Does anyone know if there is a formula or function within Business Objects 6.1 that when you run a report that returns sets of two different dates, it returns the number of working days between them, and not the number Calandar days? A bit like the NETWORKDAYS function in MS Excel - but I do not...
  15. Commandolomo

    Working Days Function

    Does anyone know if there is a formula or function within Business Objects 6.1 that when you run a report that returns sets of two different dates, it returns the number of working days between them, and not the number Calandar days? A bit like the NETWORKDAYS function in MS Excel - and I do not...

Part and Inventory Search

Back
Top