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

that worked, thank you!!

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

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

that worked! Thank you!

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

It works!! totext(sum({@Serious Event Count}),0,"") +" / "+ totext(sum({@near miss count}),0,"") totext(sum({@Serious Event Count}),0,"") +" / "+ totext(sum({@precursor count}),0,"") THANK YOU!!!

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

@ IanWaterman When I try your formula, I get an error: {near Miss count}: if {IRSCODE.CODE}in ["NME1", "NME2", "NME3"] then 1 else 0 {precursor count}: if {IRSCODE.CODE}in ["PSE1", "PSE2", "PSE3", "PSE4"] then 1 else 0 {{precursor count}:}: if {IRSCODE.CODE}in ["SSE1", "SSE2", "SSE3", "SSE4"...

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

let me clarify what I am trying to so. I would like to get two different ratios. the first being Serious event/ near miss, and the second one being Serious event/ Precursor. and as you can see from above the field that I am pulling from is a coded field. Thanks for all your help!

totext({firstNumber},0,"")+"/"+totext({secondNumber},0,"") the field (first and second number) is a coded field. So I was wondering if I could write a formula such as the following: {near miss} if {IRSCODE.CODE}in ["NME1", "NME2", "NME3"] then "Near Miss" else if {IRSCODE.CODE}in ["PSE1"...

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