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

    Trying to display Maximum date records - Crystal XI

    I am a bit lost...I think because I need to link to so many tables to get from the Procedure name (proname.name) to the Effective date (Effdate.eff_datetime). This is the SQL from the Crystal report I have been working on... SELECT "proname"."name", "proname"."abbr"...
  2. jpeters01

    Trying to display Maximum date records - Crystal XI

    I had read earlier that this was a possible solution. I have not worked with commands much and had tried to do this earlier, but will try again using your example. Thank you, Jan
  3. jpeters01

    Trying to display Maximum date records - Crystal XI

    Thanks for the reply...sorry it is not clear. The date you see on the rows is the effective date. If there is more than one effective date I need to pull only the rows with the most recent effective date. The Stress Test shows two effective dates, 7/11/11 and 7/14/11, I only want the rows...
  4. 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...
  5. jpeters01

    Need help with formula, Crystal XI

    I am finally able to work on this again and both KENHAMADY and CHARLIY's suggestions work...Oh Happy Day, thank you so much! Jan
  6. 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...
  7. jpeters01

    Need help with converting date

    AndyMC - this worked perfectly...thank you so much!!!
  8. jpeters01

    Need help with converting date

    Yes, this is the only date field that is available. I found out that the first 5 numbers are the number of days since 01/01/1800, and the last 5 numbers are the seconds since midnight today (midnight is always nnnnn00000).
  9. jpeters01

    Need help with converting date

    Yeah, I do not know how to do this either. I have not been able to find an answer anywhere...thanks though!
  10. jpeters01

    Need help with converting date

    ...and to clarify, I need both the Start date and start time to display as 7/13/15 09:00 on my report. Thanks so much for your help! Jan
  11. jpeters01

    Need help with converting date

    SkipVought, It is not a time stamp, it is a start date/time for an order placed in an application. For example, when a physician orders a medication and they do not want it to be administered until tomorrow, they enter a start date/time of 7/23/15 at 0900. I ran my Crystal report for another...
  12. 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...
  13. jpeters01

    Question - SQL 'FROM'

    I appreciate both of your replies. Tamar, I found out that you are correct...Thank you!!
  14. 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...
  15. 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...
  16. jpeters01

    Trouble with URL Crystal Reports 10

    Thanks for the reply....it seems from other posts that it should be possible. I have Crystal XI service pack 2 or Crystal 10 available to use. Anyone else have any information? Jan
  17. 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...
  18. jpeters01

    Help with Case statement please

    I was thinking that might be the 'case' :) Thanks for the extra tip!
  19. 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...
  20. 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...

Part and Inventory Search

Back
Top