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: RenaG
  • Content: Threads
  • Order by date
  1. RenaG

    Max number of tables in the datasource for Crystal Reports

    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...
  2. RenaG

    Output from one server as input to another

    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...
  3. RenaG

    Cross-tab exporting to Excel

    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...
  4. RenaG

    Conditional Suppress when no record exists

    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)...
  5. RenaG

    Parameter has no value msg

    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...
  6. RenaG

    Extra blank line at page break when exported to Excel

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

    DateAdd not working

    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...
  8. RenaG

    Any conflicts with having both CR2008 and CR2011

    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
  9. RenaG

    Changing a report in Central Management Console

    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...
  10. RenaG

    Set default value parameters in CR2011

    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...
  11. RenaG

    Summing a distinct count

    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...
  12. RenaG

    Multiple versions on same computer

    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...
  13. RenaG

    Inconsistent value in SQL Expression

    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...
  14. RenaG

    Max date with other criteria

    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...
  15. RenaG

    Parentheses missing in SQL statement

    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...
  16. RenaG

    Crystal Reports &quot;Not supported&quot; message

    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...
  17. RenaG

    Using Parameter year in DateTime formula

    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...
  18. RenaG

    Display last record in group except when null

    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...
  19. RenaG

    Calculate dob for age range

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

    Salary range for Crystal Reports Writer

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

Part and Inventory Search

Back
Top