Search results for query: *

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

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

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

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

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

I have a formula : if {@variablenextdate}>{TRAVEL.ENDDATETIME}then datediff('d', {TRAVEL.BEGINDATETIME},{TRAVEL.ENDDATETIME}) else if{@variablenextdate}< {TRAVEL.ENDDATETIME}then DateDiff ('d',{EXPENSEDETAIL.ARRIVEDATETIME} ,{TRAVEL.ENDDATETIME} )else DateDiff...

OK this report is KILLING me - I am creating travel expense forms that match our agency's form - that is designed for hand entry - to a electronic version that spits out data in this format:(pull into notebook and eliminate word wrap) EXPENSEDETAILID TRAVELID ARRIVEDATETIME ESTABLISHMENT...

OK here we go - Extracting data to build an expense report: I have a date/time field for Begin date and one for end date. Need to be able to caclulate per diem for full 24 hour days AND be able to calculate per diem for each hour beyond a full day (X the breakdown hourly rate for per diem)...

I have a number of reports utilizing the following formula to populate "Next Review Date" from a system that sets "review Date" as one year from hire date - this stinks so I had to create this: datevar review:={HR_NEW_DIVISION.REVIEW_DT} ; datevar revadj; datevar cdadj; datevar out...

IO have dept_entry_dt, job_entry_dt and position_entry_dt. I want to create a formula that will show the greatest value of the three dates only. The business case for this follows this logic -I could have entered a department 12-02-2001, then entered a new position 10-23-01 and finally was...

I have a report that is looking at the number of job reclassifications by division (made up of specified groups of Dept ID's). In the query I am pushing into Crystal, I include a field that shows the total number of allocated positions for each department so I can run the count of emplid's that...

I want to run a report that gathers all new hires by months: month({Hire_Date}). I only want to display the last 6 months from currentdate, grouped by month, the year end wraparound is confusing me. In other words I only want to see people hired in the last six months...I should know this...

I have a end of year leave reconciliation report that is causing me some issues. I have a field from one data source that I have exported to an access table...Pay End Date, I calculated Pay end-13 to get Pay begin date.I only want to see the effective dates (from another data source, and...

I have a query utilizing a union with another set of tables. In it, I am getting the name of the previous incumbent for a vacant positoon. Not all of the positions have a previous incumbent, so because of the limitations of our query tool, we place the jobcode(M2001, 00123), not the jobcode...

I have a really messy data set I am trying to clean up in Crystal before moving it into Peoplesoft My data in the field in question contains the manager name, some employees typed this directly in Manager John Doe Jane Doe While others selected a lotus Notes address book value that came...

Hi all, I am working on a report to calculate employee benefit payments that were not forwarded on to our third party administrator. We need to generate payment for employer shares of benefits while employees were on leave without pay. The data I have thus far looks like this: 120449...

I have created images of all the new hire documents (10) we need (I-9, w4 etc...) and have left them in the details section of records groued by applicant ID. I have selected only those applicants wha are in &quot;hire&quot; status. I am pulling in a lot of info, including prior work...

I have data for a job requisition that will constantly be open. I need to group this by week so managers can be updated weekly on who applied. If I group by week, I get Sunday's date...which is fine, but I would like to create a formula to read the date from the Monday-Friday period (when...

Our HelpDesk installed one PC with a version of CR 9.0 by accident ( CrystalDecisions we did not do this to shirk licensing, call off your lawyers). Every other workstation is using 8.5. the 9.0 user saved a few reports and now we cannot open them. I tried to export and did not see an 8.5...

I have the following formula to calculate age and years of service (yrs service is shown) WhileReadingRecords; DateVar Birth:= {HR_RETIREMENT_ELIGIBLE.HIRE_DT}; DateVar Ann := Date (2004,06 ,30 ); if...