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...
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...
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...
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"...
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...
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...
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...
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...
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...
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).
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...
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.