Recent content by RenaG

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

Hi John, I had considered the temp table option but I don't know how to copy or export the table to the other server. I also don't know how to link the servers. Is that done inside the query? Can you give me some code examples for both of these options? Thanks! ~RLG

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

Hi Dell, Thank you for the helpful tips. I did try to suppress the report header and the results were still the same (sans Report Header). The cross-tab is in the Report Footer but it didn't make any difference if I told the export to base the columns on the Report Footer or took the...

Sorry - I am working in Crystal 2011. ~RLG

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 Pete, I did some playing with this. If I set the default (and it has to be one of the options in the parameter list; not 'X' or something random) and then don't do anything with that parameter then the default value is what is passed to the report (it is not blanked out). I think the key...

I got the solution. I put an IsDate test at the beginning of the formula like this: isnull({%Result}) or (IsDate ({%Result}) and DateValue ({%Result}) <= date(Year (Today), 08, 01) and {ObsDef.OBD_ID} = 24006) //Date of Influenza Injection When I ran the report for a patient that didn't have...

Hi Dell, Thank you for a quick reply. I modified my formula just as you suggested and I still get the "bad date format string" error. When I click ok, the suppress formula is displayed and the DateValue({%Result}) is highlighted. BTW - %Result is in a text/string format but it is a date...

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

Thanks, Pete. That works perfectly! Here is the code that I used: If HasValue({?MD_NP_PA}) Then {Schedule.Staff_ID} = {?MD_NP_PA} Else true So is setting a default value irrelevant? TIA! ~RLG

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

Ok, I see what happened. Nothing exported to CSV (file size is 0). I just tried it again and still nothing is there. When I selected CSV in the export from Crystal, I took all the defaults. Why wouldn't it export anything? It exports to Excel ok (except for those extra blank lines -...

That is correct. ~rlg

I am not sure this option will work for our users. However, when I tried to do it myself, I opened Excel, went to the Data tab and selected From Text. Found the csv file and imported it. Nothing happened. It never opened the file. I am using Office 2013 on Windows 7.