Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

Many thanks for your help

Many thanks for your time and help.

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

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