Search results for query: *

CR 8.5 SQL Database I'm not sure I've titled this question correctly so forgive me. I have a issue with trying to suppress a group based on their contribution to the group. I have claims that are worked by employees that run timers for each task they perform. Their timers are totalled and...

CR 8.5 (Can use CR 9 if needed) SQL Database I've read other strings regarding this and just cannot get this to work. So I'm starting a new string that perhaps will shed some light on what I'm doing wrong. I have a main report that is retrieving timers an employee has run per file. A file...

CR 8.5 SQL database I have a SUBREPORT that is gathering productivity detail grouped by Claim# and employee. There is a sum of dollar amount billed on the employee grouping. I need the name of the employee to display but sort DESC on the Sum of dollar amount. Is there a way to override the...

Crystal 8.5 SQL Server I'm trying to write record selection criteria where I need to always find the first day of the month of currentdate 3 years ago as well as the first day of the month of the currentdate. Examples: Currentdate=1/21/2010 {db.date} in 1/1/2007 to 1/1/2010...

Has anyone ever done crystal reporting off of a Perseus database? Perseus is a survey software that we are using to do file audits dumping the data into a SQL database. The problem is I can't get the choices the auditor selects to show the labels rather than the code. When a survey is built it...

CR 8.5 I'm developing a report which will only be used to export to excel. How can you set the right side of the report to be wider than any standard sheet of paper? The widest I can get is Landscape Legal and I need to go to approx 24". I've seen it before but never known how to do it. I've...

I'm new to InfoPath 2003, I built a form which is a survey and now realize I need to store the data in a database. Can an access database be built from the form? I can see where a form can be built from an exisiting database but I need to do the reverse. Can this be done? If I have to build...

CR: 8.5 ODBC: SQL Server Is there a way to take a list of numbers (9 digit claim numbers) in an excel spreadsheet, copy and paste them into the selection criteria in CR? There are about a thousand records and I'm trying to avoid creating a table and joining it to my crystal report. I can...

I'm using CR 8.5 reporting from two different databases. A software called Perseus (a nightmare), joining to a sql server table. The parent report is from Perseus where I have created a formula called Location. @Location: if tbl.location =1 then "Phoenix" else if tbl.location =2 then "Dallas"...

CR: 8.5 SQL Database I'm trying to find the difference between two dates which are not of the same record. I have an authorization table that for each record has a referral date and an authorization date. I'm trying to get the diff between the referral date of a record and the authorization...

I think I've read every thread regarding Shared Variables and can't find the answer to what I'm sure isn't a unique situation. I'm using CR 8.5 ODBC to SQL database. (someone please tell my company to upgrade to XI!!) I have a main report that has claim data. Each claim can have multiple...

DB: SQL CR: 8.5 I have a report that is trying to find open files which do not have a current diary date. I work in the insurance biz and case managers have files that are open. All open files should have a diary entry established to keep the case managers on track and that a file doesn't get...

Hi All: I've just installed Crystal Passage in order to schedule some redudant reports for our 6 offices. However, each time I try to schedule a report it shuts down. I doesn't give a reason. I've checked everything from the ODBC connection to the location of the reports. I'm at a loss...

I have a user with a 6408D+ who sporadically has dialing issues. She has 3 call appearances. Upon attempting to dial out she will begin to dial externally and she will either get a fast busy or the call is dropped and it acts as tho she just picked up the receiver giving her a dial tone again...

CR 8.5 SQL Database Pardon the title, I'm sure sure what to call this question. I have a history table that tracks when a claimant visits the doctor. So there can be mulitple records per claimant. The visits can be in the past or in the future. It looks something like this: Visit_key...

I have a couple of questions. I'm using CR 8.5. I have a main report which is prompting the user for several pieces of information. 1. Business Unit - there are 7 choices (6 offices, 1 All) This is the selection criteria formula I have: ({?BusinessUnit}="All"or...

I'm somewhat of an amateur writing reports in Access, so forgive me. I have written a report from a query where the report groups by company name. In the Group footer I'm counting the number of records. When I run the report I want to limit what is returned based the count in the group...

I'm using CR V8.5 accessing SQL databases through ODBC. I have CR set to convert Date-Time fields to Date in the Options section. However, it appears when users are prompted for a date range to run these reports I've created, some data is missing due to the time element. I thought setting my...

Crystal 8.5, SQL Database I've been asked to produce a report which will display records where a summary field called SUM(Lost_Time_Days) are + or - 10% of a number called MID_LOD. MID_LOD is also a formula I created because that number is not captured. We do capture HIGH_LOD and LOW_LOD...

Let me first apologize for what is probably a very easy solution, but I'm new to SQL and our IT dept is swamped, therefore I left to try to do this on my own. Here goes: I'm trying to create a view that I can then use to build a Crystal Report. I have a dept of nurses that approve medical...