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

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.

Thank you, Skip, for your "not so humble opinion". When I said it was a formatted report, what I meant is that I have all the fields snug up against each other and the lines "fit to section" so that I don't have extra spaces showing up in the exported Excel file. It is not a "pretty" Crystal...

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

Never mind - I figured it out. The problem was with my join - I was using an inner join instead of a left outer join. [blush] How'd that get in there??? ~rlg

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 Ken, Thanks for explaining that to me. I passed your words of wisdom on to my IT dept and they can decide how they want to handle this. Have a great day! ~rlg