Search results for query: *

Hello, I need help creating a formula that will subtract two dates based on a status. However the dates resides in one database column. For example, when a status goes from "escalation level 1" to "escalation level 2" I need to subtract the time when the statuses change. I keep getting...

Hello all, I need help with a suppression formula that will count the number of groups in a report. I want to suppress the group section if the group total count is less than two as I will have the same information in the summary or report header level and the group section which is redundant...

Hello All, I am using CR10 against an Oracle 9i database. I'm pulling from one table with a where clause that needs to be slightly different to bring back three result sets that I will called -- closed, response and resolution records. I need to chart these records grouped by month. This...

I am using CR version 10 with Oracle on the backend. I am attempting to create a crosstab in the report footer area to show totals and percentages by month from formulas created: Total_incidents (count of all incidents); Response_Incidents (count of incidents meeting response SLA) and...

I have a report that was built using the following record selection on a parameter field: (if {?Service Recipient Group} = "ALL" then true else {PROBSUMMARYM1.RECIPIENT_GROUP} = {?Service Recipient Group} or {PROBSUMMARYM1.RECIPIENT_GROUP} like {?Service Recipient Group} ) While "ALL"...

Hello, I need to design a report to capture, count and group by month the following: backlog = incidents opened prior to the target month and still open. new incidents = incidents opened during the target month. closed incidents = incidents open before or during the target month and closed...

Hello, I have created a report that has several columns and two groups: 1)Assignment Group and 2)Open Time of incidents by Month/Year. For ex. Total Total Within SLO Percent Met SLO assignment 06/07 138 114 82.61% 07/07 08/07 Group...

Hello everyone, I have developed some reports (CR10) and published to CE 10. I allowed the reports to keep its initial parameter values. However when a user enters new parameter values and run the report(using CE user launchpad), the report reverts back to the initial values that were...

Hello All, I’m trying to do something similar to thread 767-1342545 where I am also counting certain records twice. I found this thread very useful in constructing the formulas. My formulas read as follows: @New if {TABLE.OPEN_TIME} in Minimum({?Date}) to Maximum({?Date}) then 1 @Closed if...

I have been tasked with developing a report that should show the maximum and average number of users for each hour of the day for each day of the week dating back to the beginning of the year. The enduser will enter a Monday's day which drives the weekly list for the report. For example the...

Error: Failed to open the connection. Report.rpt The environment is CRXI R2 using the Microsoft SQL Server 2005. I can run the report locally using the crystal IDE without any problems. However, when I try to run it via the Crystal Reports Server, I get the "Failed to open the connection...

Help! I am designing a report using Crystal XI with an SQL Server 2000 datamart on the backend. My task is to produce a report that captures data for a given month and the requirements are to display a separate chart for each week of data. The layout is two charts side-by-side per section. Is...

Can someone please instruct me on building a formula or converting a database datetime field where it will read the days of the week starting with "Monday" and repeat for each week in a month. Unfortunately I can get the chart to show only 7 days (as a result of a formula using the Weekdayname...

Hello, I am new to the world of Oracle Reports and am reaching out to a more experienced developer. I have been working on a report that needs to be re-arranged there are several parent objects with various child objects enclosed. I have approx. 4 parent objects arranged a certain way. I need...

Help, I have a report developed in Crystal that runs for multiple customers, therefore requires a parameter that prompts for the customer name. The report is then converted to pdf format and placed on the customer's portal. My question is... in order to schedule the report via Crystal...

First, let me say that I've found this forum to be a great resource in developing reports! I have not found any of the threads that mimic the problem I have currently having, so I am addressing the forum. I am using Crystal v10 with an ODBC connection to Oracle 9i. I have a main report with...