Recent content by Brenj68

Please ignore last comment, user error on my behalf I had missed the "'" on each of the accounting date periods, for the subsequent months. All looking good, Thanks for your input. B

Hi, This is the approach I've taken but it is throwing up some unusual results: Just for reference the cmd.Hours_Date is a date/time if totext({Command.HOURS_DATE}, "dd/mm/yyyy") in ('01/03/2012') to ('23/03/2012') then '2012/03' else if totext({Command.HOURS_DATE}, "dd/mm/yyyy") in...

Hi Ian, I was soooo hoping that I wouldn't have to do this approach :-0 but at least there are only 12 months to set up. Cheers Brendan

Hi Thanks for the response, unfortunately I do not thnk your suggestion will work for me as my system is SaaS and I have only read rights to the db, this also excludes everything and anything else that may have been an option. So my only route is using Crystal. Thanks for the feedback B

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

Thanks anyway, I'll just continue to do my research/ analysis and post whatever was the root cause.

Hi Kray4660, I'm also the one who designed the universe. I've followed the manual and created the LOV/ Generated, etc. Set up the individual objects and have the Business Unit / Business Sector and Department all defined in the relevant query panel/ conditions. But when I go back into each...

Hi lbass, Short answer is yes when you look at Format Editor/ Sample it shows that each field is set to eg £50,000. That is the oddest thing. I've checked and re-checked all options on this RF C-Tab section expert and there is nothing being altered???

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

No, my environment uses a derived table (BO Universe) behaves like a standard select statement. I can not create SP's on my database as it is a SaaS (hosted) system and I do not have full admin rights. B

Hi LB, that's correct there are no attributes shown under the New data source/ value drop down

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

Thanks guys for the input. Changed script to: select if {@Country Convert} <> "India" case "Grade 1" : 31.73 case "Grade 2" : 42.75 case "Grade 3" : 55.95 case "Grade 4" : 78.99 case "Grade 5" : 110.28 case "Grade 6" : 140.51 else if {@Country Convert} = India case "Grade 1" : 25.76 case...