Search results for query: *

I am working in Crystal reports 2008 version 12. I am trying to extract data for a data conversion. Currently I have the following formula: if (isnull({IRSCLAIM.MISCA_DESC}) or ({IRSCLAIM.MISCA_DESC}) ='') then "*" else {IRSCLAIM.MISCA_DESC} however with this formula it does not take care of...

I have a cross tab without a time range, by severity, entity and by claim count. What I want to do is only show those Claims that fit the following criteria: ({CHICLAIM.REPORT_DT} in DateTime (2013, 07, 01, 00, 00, 00) to {@Run Date}) @RunDate= previous month If ({CHICLAIM.SPECIAL9}) = "04"...

I am trying to exclude a location from the criteria is the loss date is greater then a certain date, but there is something wrong with my formula. else if {?MBO Inclusion Options} = "2" then not ({CHILOC_MBO.LOCATION} in ["NJDN", "MDTO"]) and if {CHILOC.LOCC} = "4623B" and {CHICLAIM.LOSS_DT} >...

Is there a way to put percentages into a cross tab? I have a cross tab that currently has the following fields and formulas in it. Rows: I have the MBO name and the facility name undearneath In my summarized fields I have the following: Count of IRIS.Claim Sum of @ Closed Ind Avg of @DM...

Is there a way in Excel 2007 to lock cells, but allow users to copy and paste graphs. What I mean is I have national data, for a time frame,and I want to lock these cells, so my hospitals cannot change it. I have another line where they are able to enter in their own data. So my question...

Hello, I am having a little trouble. I have sums in my report footers. {#Precursor} and {#Serious}. I also have a formula in my report footer: {#Precursor}/{#Serious}. the problem comes when my user chooses a time frame where there may be a zero count for the {#Serious), thus you are...

I have a formula: if isnull ({@Serious Event Count}) or ({@Serious Event Count}) = 0 then "0" else totext(sum({@near miss count})/sum({@Serious Event Count}),0,"") and when I run the report, it seems to be pulling only zero. For example if I have 9 serious safety events, and 27 near miss...

Hello, I have a crystal report that runs based on time frame and state. The problem come from a formula I have within the report: totext(sum({@precursor count})/sum({@Serious Event Count}),0,"") this is a great formula, but when I run it for a particular time frame it gives me the following...

Is there a way to create a link to a crystal report in Business Objects. What I want to do is combine two reports I have, so essentially I would leave one report name listed and then link it to the other report. So I guess I need to know how to list the name of the report, and then I need to...

Is there a way to show a ratio in Crystal reports? I don’t want a percentage I want the actual numbers i.e. 1/100 not 0.01 or 1%. I assume there is a formula, but I can’t think how that would go. For example I have: a formula such as the following: {near miss} if {IRSCODE.CODE}in ["NME1"...

Is there a way to show a ratio in Crystal reports? I don’t want a percentage I want the actual numbers i.e. 1/100 not 0.01 or 1%. I assume there is a formula, but I can’t think how that would go. For example I have: 309 serious events, 20,923 Precursor Events, And 5,916 Near Miss Events I...

I have a drop down list that I have created (MBO). I have another drop down list that goes off of the first drop down list (MBO). But I cannot get the second drop down list to work….. What I want my users to do is select an MBO from the list…………. St. Vincent Infirmary Medical Center, AR Mercy...

I am hoping someone has seen this, or can help with this issue; we are attempting to change all of our Crystal reports from one database to another (point the reports and prompts to the new database) Business Objects XI3.1 service pack 2. Application on a Windows 2003 Server R2. Tomcat 5.5 and...

Hi I have a Severity Prompt {?Severity}. In the prompt I simple list out the values (Fall- None, Fall- Minor, etc.) My problem is all of a sudden when I try to select one severity such as "Fall- None" from the prompt I get zero results, but when I select all the severities I get numbers. So...

Is there a way to suppress some of the outcomes in a filed and not others? I have several cross tabs and currently the information is displayed in the following fashion: Carrington Health Center - Carrington, ND Carrington Health Center - Carrington, ND Central Kansas Med Cntr-Great Bend...

Is there a way to have a cross tab, and have all the values from a field. What I mean by this is when I create a cross tab, to show me count of Incidents, it only shows me those codes that are being used, I wasn’t to create a quality report for all codes, even those codes that are not being...

I have a 2 page report that gets burst out to 40 different recipients. On the first page of the report I had to put a formula in the page header. The problem comes from the second page when that same, but no longer significant to the second page formulas shows up on the second page (page...

Is there a way to put labels into the cross tab. My current set up for my cross tab is: Rows: IRSCLAIM.SPECIAL23 IRSCLAIM.SPECIAL21 IRSCLAIM.SPECIAL18 IRSCLAIM.SPECIAL11 IRSCLAIM.SPECIAL12 (with all the row totals collapsed) Columns: MBO.LOCNAME Facility.LOCNAME Summarized Fields: Count of...

Is there a way to reschedule a report without downloading the crystal report, and reloading it? I have a report that goes out on a monthly basis to 40 different people. Those 40 different people see a certain set of data. (ex. Person 1 sees data set A Person 2 sees data set B Person 3 sees...

Is there a way to create a cross tab with five fields, and make sure that the cross tab is not capturing the null values? For example right now, I have identified the null values as “not yet Classified” from the below formula. if isnull ({IRSCLAIM.SPECIAL23}) then "Not yet Classified" else...