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

Thanks lbass -LLL

Thanks very much. I was using the same thing but was trying to use something for day and was getting a too many arguments error. Thanks again -LLL

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

Yes there is a file created as a data dictionary that looks something like this Heading Choices Choice_Values QRevieweeName 1|2|3|4|5 Suzie Smith|Joe Jones|John Doe| It's as if it puts a hash mark inbetween each choice and each Choice_Value. -LLL

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

Thank you. I chose a pdf printer changed the paper size. Worked like a charm. -LLL

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

lbass, thanks so much for the suggestion. I got it to work. -LLL

Perseus is a survey software. We use it to do claim file audits. The only field I can link to the sql tables is claim number. I had to write a formula to alter it because perseus has it as a numeric field and sql has it as alpha. Claim numbers are 9 digits, if it begins with zero, it...

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

Thanks dgillz, worked like a charm. -LLL

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

My apologies, it was late in the day yesterday. A new day, a new outlook: tbl_ActivePeriod_info - this is populated by a sp which gives the maximum active period. An active period is defined as a period in which the file is open and closed along with a case type. Null(close_date) is just a...

The expected output would be: Claim_no Claimant Date_Opened Case_Type 750123456 Doe, John 5/1/2006 Lost Time Here is the selection criteria as it is now: {tbl_DW_ActivePeriod_Info.Case_type_Key} in [1, 12, 2, 26, 27, 5, 8] and {LOGIN.tcm_unit} = {?TCMUnit} and...