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: *

  • Users: jpeters01
  • Content: Threads
  • Order by date
  1. jpeters01

    Trying to display Maximum date records - Crystal XI

    I have tried suggestions from other posts like using Report Selection Formula/ Group but I couldn't get them to work. This is a report that displays a schedule build for procedures and every time the schedule is adjusted it is given a new Effective Date. I need to pull the schedule build with...
  2. jpeters01

    Need help with formula, Crystal XI

    Hi, I need to pull patients first locations when being admitted to the hospital into a report. The fields in the database are pat_loc1, pat_loc2, pat_loc3, pat_loc4, pat_loc5, etc. The values of the location fields are updated in the database so that the most current location is #1, for...
  3. jpeters01

    Need help with converting date

    I am using Crystal XI to pull data from an Oracle database. I have a SQL (that I am using for reference) where the date field {TABLE.START_DDT}, which is a number field, is converted to a date using ddt.todate{TABLE.START_DDT}. I have not been able to figure out how to do this in Crystal...
  4. jpeters01

    Question - SQL 'FROM'

    Hi, I am a Crystal report writer trying to create a Crystal report based off of a SQL that I was given. The report pulls from an oracle database. I am trying to add the tables from this FROM statement to my Crystal report. FROM O_ITEM, O_PAT, ent_config.STAFF O_STAFF-AUTHORIZE, PRIORITY...
  5. jpeters01

    Trouble with URL in Crystal Enterprise 10

    When I use this URL it just opens the Crystal Report Login screen, it does not pass the Username or password to the login screen. I have tried the Guest account with no password and a username and password and both behave the same. If I manually enter username for Guest or username and password...
  6. jpeters01

    Trouble with URL Crystal Reports 10

    When I use this URL it just opens the Crystal Report Login screen, it does not pass the Username or password to the login screen. I have tried the Guest account with no password and a username and password and both behave the same. If I manually enter username for Guest or username and...
  7. jpeters01

    Help with Case statement please

    Very much a Newb here, trying to create a case statement with multiple 'likes' and I do not know the correct syntax is or if this is even possible. This is just a sample, the actual case statement is bigger: CASE WHEN casepro.act_proname like ['%COLOS%','%COLON%'] then "COLO" WHEN...
  8. jpeters01

    Subreport Date Selection help please

    I have a Crystal V10 report that uses {appt.start_datetime} = {?StartDate} in the selection formula to pull scheduled appointments. There is a subreport that is linked to the main report by a Patient_id field and ?StartDate to ?Pm-StartDate. I need the subreport to pull all appointments...
  9. jpeters01

    Need to extract lines of text

    Hi, I have data that looks like this: Accession#: 14CP123 Reason for study: 1. Shortness of breath 2. Chest pain Summary: 1. First diagnosis 2. Second diagnosis 3. Third diagnosis The data is stored as {document_text_c.line_text} where each line of text is stored separately as...
  10. jpeters01

    Need help displaying height in feet and inches

    This is my @HtIn formula that displays height in inches: if {casevisitresultlistwt.label_seq} = 9997 then left({casevisitresultlistwt.result_value},2) else '' This formula returns values, for example, of 65, 73, 40. I need to display this as feet and inches in two separate columns. Like...
  11. jpeters01

    Need help extracting part of string Crystal XI

    I am trying to extract data from a string...my data looks like this: Strength: 4 mg Strength: 30 ml before bed Special instructions: On full stomach Special instructions: Take before breakfast Strength: 20 mg and sometimes the field is null/empty I need to pull the text from the strings...
  12. jpeters01

    Date time formula

    I have three different subreports that pull medication admin times into three columns on the main report. One column displays meds to be administered from (07,01,00) to(15,00,59). This is my formula: time({THERAPYADMINISTRATION.ADMINISTRATIONTIME}) >= time(07,01,00) and...
  13. jpeters01

    Crystal Reports XI export to Excel 2010

    I have a 200,000+ row report that I am trying to export to Excel 2010. First of all when I try to export, Excel 2010 is not an export option. I did some research and what I have read is that it is either a problem with missing dll's on my computer OR it may not be an option to export from...
  14. jpeters01

    Crystal 8.5 Report formula error

    Hi, We still have an application that uses Crystal 8.5 and I need to modify one of the "standard" reports that comes with the application. It contains this formula: "QTY:" + NumberFormat(({TABLE.QTY}*{TABLE.DISPENSESIZE}),0) but I can't get the standard report to run outside of the...
  15. jpeters01

    Need help displaying comments

    Hi, Regarding previous thread 1623741. The resolution works very well but we have recently noticed a problem when there are duplicate RX#s. For example: RX# Drug Dose Comment 123 Amoxicillin 250 Take with food 1234 Diprovan 250 x2 doses...
  16. jpeters01

    Concatenate rows of text in SSRS

    We have a text field that is stored in multiple rows like this: 1/2 tablet every 8 hours Linenumber 1 as needed for headache Linenumber 2 not to exceed 8 tabs Linenumber 3 in 24 hour period Linenumber 4 We need this to display horizontally on our report like...
  17. jpeters01

    Need help suppressing duplicates in details section

    Hi, My data looks like this in the details section of my report: Description Area NDC(string) Onhands Acetaminophen ED 123 1 Actaminophen ICU 1234 3 Acetaminophen ED 123 2 Acetaminophen 4W 12345 4 Acetaminophen TCU...
  18. jpeters01

    Need help suppressing duplicate row

    Hi, My data looks like this: Description Area NDC(string) Acetaminophen ED 123 Actaminophen ICU 1234 Acetaminophen ED 123 Acetaminophen 4W 12345 Acetaminophen TCU 222 Acetaminophen 3S 222 I need add an X in a column when the Area is ED and...
  19. jpeters01

    Need help displaying comments in details section

    Help please...I need to add comments which are stored like this: {table.textline} {table.linenumber} SLIDING SCALE HUMALOG 1 BEFORE MEALS 2 REQUIRES SIGNATURES 3 To medications in the details section of my report so that they...
  20. jpeters01

    Help with formula that displays horizontally

    We use this formula to display allergies horizontally. How can I get it to NOT display allergies that have an inactive date? For example, allergies are: Aspirin (inactive date is null) Penicillin (inactive date is null) No allergy information (Inactivate date of 10/1/10) Currently it...

Part and Inventory Search

Back
Top