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!

  • Congratulations strongm 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. GCCkjn

    transferring Crystal reports to another user - Crystal version 11

    We did set the Database location. We aren't using a shared drive - I am retiring and trying to set up my reports for the person taking my place. Here are the steps we did: On the Database expert, the two excel files listed were from my files - we added new connections to the excel files in her...
  2. GCCkjn

    transferring Crystal reports to another user - Crystal version 11

    I would like to know if there is an easy easy way to transfer Crystal reports to another user without having to re-create the report. We cannot connect directly to our database with crystal so we run reports from the database to excel and then use Crystal to pull the info we want from the excel...
  3. GCCkjn

    SLOW processing report

    You’re probably right about the ‘not’ and ‘or’ statements causing the report to run slowly but I don’t know of any other way to get the info I need. And I’ve just found out I now have to add another ‘not’ statement to the report. As well, the subreport is in the detail section of the report...
  4. GCCkjn

    SLOW processing report

    Hi turkbear - We are using WinCIS, a database developed by Momentum Healthware (developed for health care providers). The SQL statement follows: SELECT "Pat"."CPINo", "Activity"."ActivityDateTime", "ServCat"."AccountNo", "ActivityType"."ActivityTypeDesc", "Pat"."FirstName", "Pat"."LastName"...
  5. GCCkjn

    SLOW processing report

    Hi I'm using Crystal version 11. I have a rather complicated report (for me at least) which is providing the results I wanted but the running time is EXTREMELY slow and while it is running is also slows down our database system for all other users. Would it be possible for someone to look at...
  6. GCCkjn

    Standard Toolbar has Disappeared

    I am using Crystal version 9.2.2. This is probably a simple fix but I can't seem to find it. The standard toolbar has disappeared from the screen. On the View Toolbars, all toolbars are selected. I've deselected them and then re-selected them. I've moved the toolbars around. I've closed...
  7. GCCkjn

    Sharing Reports with Crystal Ease

    I am using Crystal Reports 9.2. We have an intranet using SharePoint for clinical staff where we share information and reports. I can create a report in Crystal (Crystal Reports is only on my computer) and post it on SharePoint for users who are then able to run the report using Crystal Ease...
  8. GCCkjn

    Identifying who is running/printing a report

    Ainkca, thank you for the info. It HAS been a while and I had given up on it. Your suggestion works - thanks again :)
  9. GCCkjn

    Identifying who is running/printing a report

    Sorry, you guys have lost me. I was not very clear in my answer to mrjbim. I have Crystal loaded on my computer but others run the reports I create using Crystalease on our intranet. They have to log into Crystalease to access the reports. It's this login that I'd like to display in the...
  10. GCCkjn

    Identifying who is running/printing a report

    It's Crystal Reports loaded on my computer not through a browser.
  11. GCCkjn

    Identifying who is running/printing a report

    Hi there I'm using Crystal 9. Is there a way to identify in a report the person who is logged into Crystal and printing the report?
  12. GCCkjn

    formula for a field which may be null

    To add to the confusion, the lookup table is also used in the main report but for something different. However, I have also made the join to the lookup table in the main report a left outer join. I guess I can't put a subreport within a subreport? When I run the subreport on it's own with the...
  13. GCCkjn

    formula for a field which may be null

    Within the subreport, I do have a left outer join from the activity table to the lookup table. The subreport is linked to the main report by chart number (cpino).
  14. GCCkjn

    formula for a field which may be null

    I have a fairly complex (for me) report pulling info from various tables in our database. Then for each of these records (or clients), I have inserted a subreport identifying the initial assessment info and the first intervention info. Everything is working so far. Except now, I want to...
  15. GCCkjn

    calculating using a formula field

    Thanks lbass. Sorry I didn't identify the average initially. I naively thought the averaging would be a simple thing to do once I had the wait time.
  16. GCCkjn

    calculating using a formula field

    lbass, you are the best!! That works thanks. I love it when a report does what I want :) Now, how can I average that wait time for all clients?
  17. GCCkjn

    calculating using a formula field

    I suppose there could be a null value although none are showing up that way in the report. Would it be able to return "n/a" in that case? or just left blank?
  18. GCCkjn

    calculating using a formula field

    Here is the formula for the most recent assessment Maximum ({vw_init_assessment_date.ActivityDateTime},{Pat.CPINo} ) I was trying to calculate the time from that date to today. These are the formula's I've tried: 1. currentdate - {@most recent initial ax} 2. DateDiff ("d", {@most recent...
  19. GCCkjn

    calculating using a formula field

    I have Crystal version 9. I've created a report to calculate the waiting time for a client since the initial assessment. Since there is sometimes more than 1 initial assessment for a client, I created a formula to capture the most recent i.e. maximum (initial assessment date). So now I want...

Part and Inventory Search

Back
Top