Search results for query: *

I recently upgraded to Crystal 2016. In the past we have modified the Regedit NTablesMax parameter to increase the number of tables you can see in the Datasource. For some reason, the edits aren't 'sticking'. I make the changes but when I go back to look at them they are back to the default...

I need to write a query against one server and use the results as input to a query written against another server. This is a one-time request so it isn't something I need to set up to run automatically or anything. I could even export the results to an Excel spreadsheet and use that as input...

I have a cross tab that works perfectly and looks correct in Crystal. The format looks like this: | Column #1 Name Total Total Count of @Order_Type Count of @order_type Row #1 Name Count of @Order_Type Count of @order_type Row #2 Name Count of...

Hi, I am working in Crystal 2011. I have a report that displays a patients immunization records. These records include flu (influenza), pneumococcal and TDAP. I don't want to see all past flu shots so I am suppressing based on date. Like this: DateValue ({%Result}) <= date(Year (Today)...

I am working in Crystal 2011 (aka 14). I have an input parameter that is Type: number and set up as Optional Prompt: True and Default Value:0 I have this in my Record Selection: If IsNull({?MD_NP_PA}) or {?MD_NP_PA} = 0 Then true Else {Schedule.Staff_ID} = {?MD_NP_PA} When I run the...

Hi, I am working in Crystal 2010. I have a main report whose only purpose is to get the date parameters. Then in the Report Footer, I have a subreport that uses a Command to report off of. I have the report tightly formatted so that when I export to Excel it looks perfect (no extra columns...

Hi, I have this in my WHERE: SCH1.App_DtTm between dateadd(week, -7, '2013-02-01') and '2013-02-01' I am looking for patients with a certain kind of record that is within the last 7 weeks. I can see patients in the DB with a record dated 12/18/2012 or another one dated 1/2/2013 and these...

Hi all, I currently have CR2011 and CR 10 installed on my computer. Now, because of applications I work in, I need to also have CR2008. Does anybody know if there are any conflicts with having both CR2008 and CR2011 installed? Thanks! ~rlg

Hi, I have put a report out on CMC but now I need to change it. I am working in Crystal 2011. I am also new to this environment. I don't see any options in CMC to allow me to do this. When I go through Crystal and try to access the Enterprise folder, I enter the correct system, user name...

We are converting from CR10 to CR2011. I have noticed that the input date parameter windows don't default to today's date. I tried to set the "Default Value" in the Edit Parameter window to CurrentDate or Today() but that didn't work. How do I indicate that I want it to default to today's...

I'm using Crystal 10. I need to generate a report that gives the average number of patients seen per day per clinic. I have a {distinctcount of (patID)} calculated for each apptDT (if a patient has multiple appointments on the same day he is counted once whereas, if he comes in on different...

I have seen previous posts that it is ok to install earlier versions (like 8.5) of Crystal with later versions (like 10). I was wondering if that is true for running Crystal 10 and Crystal 2011 on the same machine. Has anybody had any problems with running these two versions on the same...

I am using Crystal 10. I am working on a report that uses a view. The view lists all the custom reports in our system showing the date/time it was run, who ran it, the job status, what server it was run on, the report path, etc. I am trying to create a report that is grouped by the report...

Using Crystal 10. I need to select patients whose last appointment date > 4/30/2011 and the appointment is not a NOTE and the appointment wasn't canceled. In looking in the forum I found a SQL statement that addresses the last appointment date part. I tried adding code for the rest of the...

I am using Crystal 10. I have the following select statement (written in the Record Selection Formula Editor). The part I want to focus on is in red: {Cpt.Template} = 0 and ((isnull({Schedule.location}) or {Schedule.location} = 0 ) or not ({Schedule.location} in [1975,8224])) and...

I am working in Crystal Reports 10. Recently I have been getting a Crystal Reports window with the "Not supported" message. This report runs fine but if it sits idle for a while, this message pops up. When I click ok, the report is blanked out. I can go to Database | Verify Database and the...

I am using Crystal 10. I have a parameter field that is a string and gets a beginning year and ending year from the user. I want to use this string in a subreport in the record selection. Something like this: {Schedule.App_DtTm} in DateTime (2010, 01, 01, 0, 0, 0) to DateTime (2011, 12, 31...

Am working in Crystal Reports 10 I am trying to display on my report the last medicine record. I got a formula that goes in the Report Select|Group for doing that off this forum but the problem is that some of the records have a blank or I assume Null date. Using this formula works except...

I am using Crystal 10. How would you calculate a date range if given the request: TIA, ~RLG

I hope I am not stepping outside some boundaries with this question. My employer is reevaluating my position and salary. I have done a search on the internet trying to find salary ranges for a Crystal Reports Writer but have come up empty. Would anybody mind sharing the salary range for this...