Search results for query: *

I would like to include the Year Number in the title of a chart - something like "Count of Planned Works by Type for 2004". I know I could enter it as text, but then I would have to modify the report for next year - would be Ok if there was only 1 or 2, but I have quite a number of...

Hi, Using BO5.1.7 on an Oracle 8.1.7 database. I have a problem where I need to count the number of jobs worked on per month. There are fields "Actual Start Date" and "Actual Completion Date". Finding the month of the Start Date and Completion Date is straightforward, but the difficulty...

Hi, Using CR 8.5 connected to an Oracle database. I have a request to develop a report giving various information on orders received in my company. We need the orders selected by - Service (each order is for 1 service only) - Week Number - Type (either New, Change, Cease) Report Layout to be...

Hi, I have a simple problem which I cannot understand. Using CR 8.5, I simply want to number the groups in a report - so required output is 1 First Group Name detail lines 2 Second Group Name detail lines 3 Third Group Name detail lines etc. In RH I have a formula init_line_nr...

[COLOR=red]A Warning![/color red] If you check the "Repeat Group Header On Each Page" box in the "Change Group" section, it also repeats any variable initialisation formulas you may have in the group header (even if they are in a separate section from the header text). I discovered this today...

Hi, Using CR 8.5. I have a stacked bar chart, showing fault categories per week. Data in chart is Oh change of Week Number ; Category Show Values: Count of faults. Category is set to TopN, where N=5 (include others), so for any given week only the top 5 categories are displayed. Everything...

Hi Everyone, Another question about subreport parameters - using CR 8.5 with a direct connection to an Oracle database. I have a Parameter {?Time Period} to select the time period required - there are 3 available selections "Last Week" "Last Month" "Year to Date" I have 2 formulas to...

Dear All, Using CR 8.5 with a direct connection to an Oracle database. I have a parameter field {?Section}, with default values imported from a text file which was created from an SQL Select statement on the Ref_Section table in the database: select section_id, section_desc from ref_section...

I have checked this, it goes from Sunday to Saturday. Our business rules define a week as being from Monday to Sunday, so my question is - is it possible either to modify LastFullWeek to go from Monday to Sunday, or to define an equivalent selection criterion? Many thanks in anticipation :-) John

Hi, Using CR 8.5 with a direct connection to an Oracle database. I have a run-time paramater {?TEAM} and would like to be able to have a report on with 2 groups: 1. DEPARTMENT_NAME = {?TEAM} 2. Others I have tried using a formula as group name, but the parameter field is not available. Is it...

Hi, I have what should be an easy question, but is proving difficult. All I want is the sum of the minutes from this formula (@act_time): whileprintingrecords ; if PreviousIsNull ({HPD_ACTIONS.CASE_ID}) then 0 else ( if {HPD_ACTIONS.CASE_ID} = previous({HPD_ACTIONS.CASE_ID}) and (previous...

Hi, I hope someone can help me with this. I have a situation where various departments are allocated Work Orders. I group by Department, and count the Orders by department. I also have a formula that determines if the order is closed before Due Date: if close_date <= due_date then 1 else 0 I...

Hi, Using CR8.5 I have a problem with subreports. I created a report "Summary_A" and inserted it as a subreport in my main report. That worked fine. I then edited report "Summary_A" and saved it as report "Summary_B". Inserting "Summary_B" as a subreport in the same main report, it shows in...

To clarify: I have a database of Fault Cases, each case has a Solution Time (in hours) and I want a graph showing the percentage of cases outstanding, by hour. X-axis is number of hours, Y-axis is % remaining unsolved Example at 0 hours, 100% are still open. 38% are solved with 1 hour, so 62%...

Hi, I hope someone can help with this. I need to link 2 tables from 2 separate Oracle databases held on Unix servers, which have the common field &quot;Case ID&quot;. In one database the field is a VARCHAR2(255) and in the other it is VARCHAR2(15) - please DON'T ask me why, I don't know:-) but...

Hi, I hope someone can help. I have a number of reports scheduled to run on a daily or weekly basis, and need to make some minor changes to them. Is it possible to make changes to the report directly on the Solaris server, or do I have to make the changes on my Win2K PC then create a new...