Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jschill2628

    multiple formulas

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

    cross tab for a certain period of time.

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

    exclude a location from a certain point in time

    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} >...
  4. jschill2628

    Is there a way to put percentages into a cross tab?

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

    lock cells, but unlock graphs + excel 2007

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

    dividing by zero

    that worked, thank you!!
  7. jschill2628

    dividing by zero

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

    dividing by zero

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

    division by zero

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

    division by zero

    that worked! Thank you!
  11. jschill2628

    division by zero

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

    Is there a way to show a ratio in Crystal reports?

    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!!!
  13. jschill2628

    Is there a way to create a link to a crystal report in Business Objects.

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

    Is there a way to show a ratio in Crystal reports?

    @ 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"...
  15. jschill2628

    Is there a way to show a ratio in Crystal reports?

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

    Is there a way to show a ratio in Crystal reports?

    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!
  17. jschill2628

    Is there a way to show a ratio in Crystal reports?

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

    Is there a way to show a ratio in Crystal reports?

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

    dependent Drop down lists

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

    Could not find parent folder

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

Part and Inventory Search

Back
Top