Search results for query: *

I have searched the threads for an answer because I know this question has been asked before. I was not able to find what I needed. I'm performing some datediff math in a group header and this works perfectly: ELAPSED DAYS: if isnull({Sheet1_.Next Assessment Date}) then 30 else (DateDiff...

I'm using product version 11.5 I've read thread after thread about how CR will not calculate a summary of a summary. But I'm still hopeful there is a solution to my problem be it a table, running total, sub report, or something else. This is how the data appears on my report: PR1949 IN19717...

For whatever reason, sometimes HTML is contained in a text field and displayed in my report. I can use the "replace" command when there are only a few characters. But sometimes, there are way too many characters. Here is a sample: <a>good text here and here</span><font-family>more good...

I'm using CR 11.5 I'd like to provide a few summary stats in the report header and I'm having trouble counting records. I have three groups (group1, group2 and group3) and the data. I'm counting the number of records via "insert summary" at the group1 level. That works fine. I'm then...

Using CR version 11.5 I'm not sure how to proceed but I think I may need to evaluate records using array logic.. and I do not have any experience with arrays yet. Each of my parent records also has one or more child records associated to them.. and children have Tiers (1-8) assigned like this...

I think I'm making something harder than it should be... but here goes. I have the following five fields: @White @Red @Yellow @Green @Blue Each field has a formula and the resulting numeric values will be: @White 1 if true 0 if false @Red 2 if true 0 if false @Yellow 3 if true 0 if...

I'm trying to exclude weekends and holidays in a date calculation. I'm using formula langage posted in tek-tips but don't think I'm using it correctly. In the header, I have the field @Holidays //Holiday Listing formula to go into the report header of the report. BeforeReadingRecords; DateVar...

I'm using CR 2008 and I have a (probably rookie) question. Here's my set-up… Table3 < Table2 < Table1 All links are Left Outer Join. Table1 contains incident records. Each incident record contains generic information about each incident such as Start Date, End Date and Severity. Table2...

I've never run across a field data type = Picture. Apparently the field is a BLOB field and supposedly contains data that I need for my report. Is it possible to change the data type from picture to string? Any advice is appreciated. Thank you.

I'm sure this has been asked a million times but I can't seem to find the asnwer. Here's goes one million and one... I'm calculating the number of days it takes to deliver a document based on a requested date and delivery date: DateDiff ("d",{Date_Requested},{Date_Delivered}) Is there a way...

I have no experience creating an array. I'd love to see some simple examples of array formulas. I think I may have a situation were creating an array would be useful (please tell me if I'm wrong). I have a field in a record (Application Name) that has a corresponding field (Entry Complete)...

I may be trying something that can't be done : ) Using: CR2008, Oracle. I have a main table called Master. From there, I have a Customer table, a Platform Table and Application table. The Master has an ID. Customer, Platform and Application records spawned from Master share a common ID (key)...

I'm adding a new table (oracle) to an existing report (CR2008) and I get the following error Failed to Retrieve Data... [ok] Database Connection Error: If tables are already linked then the join type cannot change. I'm simplay adding a new table to a report that has worked very well for years...

I recently changed from CR XI to CR 2008. In 2008, reports created in XI force the following sequence of events in order to save: (at this point the report has been refreshed) 1. Save 2. message: additional parameter values are needed before this report can be saved or viewed with data. click...

I'm trying to reach DB2 (9.5) using Crystal Reports VI. I set up my ODBC driver and it connects to the database fine. When I attempt to establish a connection to the database via Crystal, I get the following: Logon Failed. Details: IM003: Specified driver could not be loaded due to system error...

Hello. I have a report that's using excel as its data source. Unfortuantely, it ocasionally has a field (a cell) that contains mult problem ticket numbers (instead of one prob ticket number in a cell, per record). In the cases where there are mult numbers, it looks like this: 12345, 42554...

When printing PDF's from verion XI, the PDF's file name was prefilled with "Crystal Reports - " + the report name. Now that I'm running version 2008, the Crystal Report's report name is no longer a part of the PDF's prefilled file name. Is this controlled by a setting somewhere? Thank you.

I'd like to use two date ranges in a record selection statement. In the end, I'd like to bring in records with a date range of 1/1/07 - 7/31/07 and 1/1/08 - 7/31/08. It would be nice if it were as simple as this: {INCIDENT.START_TIME} = ({?2007 Date Range}and{?2008 Date Range}) Is it possible...

Hello. I'm using CRXI and would like those without CR to be able to access my reports. Does the CR viewer allow the user to change report parameter values? Thanks.

I believe Running Total Fields may solve my issue but I've never used them and don't fully understand what they can do for me. My report looks like this: GH1 ABC Bank Year Minutes GH2 2007 220 GH2 2008 240 GH2 Main National Bank GH2 2007 275 GH2 2008 300 Minutes are an averge (detail...