Search results for query: *

Hi All, I'm on CR2008/ Oracle 11. My user has requested the following report, which I'm fairly certain I've done in the past but unfortunately have no record of how I may have achieved it. I need to calculate the total hours booked (to a project) on an accounting monthly schedule basis (not...

Hi I'm on CR2008/ BO Universe 12.03/ Ora 11. I have a cross tab in RF which is based on the following: Rows - Project Reference & @Res_Task_Concat ({dhResourceHoursUni_query.Prname} +" - "+ "("+{dhResourceHoursUni_query.Full Name}+")") Column - @PrStart_Conv (totext({@PRstartdate},"MM/yyyy"))...

Hi, I'm using ORA 10 as base to develop Business Objects/ CR2008 reports, developed by a friend but the subquery is driving me.. I can see the theory of what I would like to see that 'Project_BU' should show the full name and not its id (as this means putting in place Case statements - which are...

Hi, This, I'm sure is going to be a dumb issue - but has got me stumped. I'm on CR2008 v 12.3.0.601/ with Oracle, within the BO platform environment. I'm testing out developing Dynamic cascading prompts which in this case has (and should be based on the following) three levels: GH1 - Business...

I'm using CR2008/ Oracle 10 My report shows a number of parent projects (programmes) with each of the cild projects associated and I need a cross tab that will show all resource costs on a month by month basis in current financial year, at the child level (GH5). This works v well when cross...

Hi CR2008/ BO XI I'm looking at creating a dual headed summarised 'x-tab' on a month by month basis, as below, calculating costs against projects. The confusion is what is the best/ more sensible approach to deliver something that has this structure manual cross tab or non-manual cross-tab. I...

Hi, I'm using CR2008/ BO Universe XI The situation is I need to calculate hour rates (defined) against individual resource grades, which are different whether India/ Rest of World on time spent on working on projects (actuals). I have something like this: select if {@Country Convert} <>...

Hi, I'm trying to get this to work (as a bulk update). I'm using Ora 10 via SQL Developer UPDATE mun474t.odf_ca_project SET dh_product_2 = 'Adhoc insights' WHERE EXISTS (dh_product_2 = 'CI - Brand Loyalty Activator');, 'CI - Brand Loyalty Analysis/Migration', 'CI - Brand Loyalty Lab', 'CI...

Hi, Been a while since I posted/viewed anything about CR (2.5 yrs ago since I last used it), so this question I have may be down to rustiness. I'm using CR2008/ Oracle 10g via a Business Objects (derived table 'universe'). My select statement is fairly basic, ten attributes only, it has no where...