Search results for query: *

Thanks! - That is what I thought too -

Since I am unable to breach the highly secured Business Objects corporate site - I have decided to come back home to tek tips to post this question. Is it possible to install Business Objects 6.5 (thick client) and use Oracle Instant Client instead of the recommended 9.0.3 full client? (of...

FOR THIS SET: 00160 Executive Secretary 2 15 11 30 2 18 34 2 11 15 17 18 20 2 5 6 11 15 17 2 15 20 11 34 46 2 5 14 15 18 20 15 42 5 17 30 46 I want to see a frequency...

here is the issue - I want to see the frequesnmcyt of say the number 2 - across each of the 6 competencies - and have that count appear in the group header - the ability to be able to sort these totals in a descending order would be great - i should probably try this with SPSS.

The dataset below (believe me - there are many more) needs to be summarized with the 6 most common competencies per jobcode - I have 6 distinct fields of data - and there is a great deal of variation in how each row is sorted (not all ascending or descending). How do I pull this off? And if I...

I guess I had better fire up a general invoice - thanks!

SQL Server - CR 8.5 using OLE_DB connection. I created a parameter field promting string value for Travel ID - then placed it in the select expert after selecting {TRAVEL}TravelID. Now I get my desired result of only displaying one record per entry. However the Travel Id's look like this...

Data is stored poorly - as this is a customized bolt on piece to a crappy CRM module. TRAVEL.tbl contins Begin date and end date, travel id EXPENSELIST.tbl contains Travel ID (linked),cost type -and amount EXPENSEDETAIL.tbl contains Travel ID , Rate and Subsistence. I have had to fudge the...

I was asking a question on the one post to see if I could grab the table fields and split them - but I wasn't sure if I could do that - I really need to pass this data down after it has already been caclulated -as the number of days travel varies, as does the subsistence and lodging rate I...

CR 8.5 Saleslogix on SQL Server / OLE_DB Here is example data - http://www.tek-tips.com/viewthread.cfm?qid=928628 And expected output there - sorry all

What is the *1000

OK - got some things done - now for the data - 10/4/2004 Golf Fees 329.98 55.37 Airline 329.98 55.37 Car Rental 329.98 55.37 Rental Car Gas 329.98 55.37 Registration Fees 329.98 55.37 Parking & Tolls 329.98 55.37 Train / Subway 329.98 55.37 Membership Fees 329.98 55.37 Taxi 329.98...

thank goodness you are here for the rescue.....let me get you a datasetup - it is plenty full of issues

would this work for a number ? if I have n costs in a grouped field from a table - can I get the split to push each one out individually - and then multiply them by a datediff?

I am passing a lot of poorly formatted data - this is a bolt on travel application that I have been trying to bail out with this report. We have travel begin date and end date, and arrive date - but no "check out date" so we have used the group footer for arrays and running totals to work. I...

using this: if {@variablenextdate}>{TRAVEL.ENDDATETIME}then datediff('d', {TRAVEL.BEGINDATETIME},{TRAVEL.ENDDATETIME}) else if{@variablenextdate}=date(0,0,0)then DateDiff ('d',{EXPENSEDETAIL.ARRIVEDATETIME} ,{TRAVEL.ENDDATETIME} )else DateDiff ('d',{EXPENSEDETAIL.ARRIVEDATETIME}...

this portion worked like a charm - I am linking the subreport via TRAVEL.ID - then I have the main report with a second group of ARRIVEDATE. The subreport is grouped in a similar fashion, but how would I get each individual table.destination/table.destination to appear in group footer 1? I...

thanks - the OLE part was included to state that I only have certain area to operate in -

I am working on a devil of a report - and now I need some more help. I am looking to list individual destinations /locations on a travel form. I am hoping to do these in order - ie. 1st day's location, second day's, fifth days (accounting for multiple day stays on one location.) I am doing...

perfect - thanks a million - I have been staring at this for too long - now If I generate a number here - and multiply it by a cost amount that has been grouped - how can I get a summary of this? Should i pass it from a subreport back to the main report? (i want to multiply this by the...