Search results for query: *

Thanks Mocgp but I need to do a manual crosstab and once I get this right for 2007 then the next column is 2008..I would do a crosstab through the wizard but this crosstab is more complex the next colume is the number of diagnostic tests, then the next column needs to be a calculation of the...

Sorry my question is, for some reason the count adds "1" to the count every time am I missing something in my code??

I am using Crystal reports XI hitting a SQL database with one table I am creating a manual cross table flat file source need to do a simple count and distinct count by year formula is If {SPSS_TEMP.DischYear} = "0708" then ({SPSS_TEMP.Encounter#}) then I do a summary to get the count and...

Help, can Crystal XI link to SPSS Version 18 file, need to hit it to do reporting....please help ....VP needs data

Need help, trying to suppress subreport if fields are empty. Can't figure our programming.

Hi hejamana You are abosolutely correct, if I had my whay I would snap someone up and keep them forever, unfortunately Canadian health care system doesn't always see the value in a Quality Manager having such a resource but at least it would be a step in the door into a large teaching hospital...

Okay, I think I got it to work kinda through the suggestion given by Bob, so now the function works and I created a formuala based on the function but here is the killer, there must be something now different between the orgininal access function and the new crystal basic function because the...

Done, with the same error, still highlights the word "Function" and still states a statement is needed here...I wish I knew how to attach a screen shot to this page... I created a new formula Called it CBUMO2 changed to Basic deleted the "formula =" pasted the code hit save got the same...

Hi Mo, Exactly the same thing is happening, I don't get past the first word "Function" and it say a statement is needed here. I created a new formula Called it CBUMO changed it to basic syntax the words "formula = " again displayed in the formula window I put the words formula = "CBU" then...

Hi Mo I think I am doing what you suggest, I opened crystal, created a new formula, called it CBU Changed the syntax to Basic When I do that the word "formula=" appears in the formula window so I am assuming that I type in "CBU" then I pasted the above,cleaned up code, thank you so much, but...

Hi All, It seems like I always come with the big ones, I have been working on this for what seems to be forever. I am working in Crystal 9 attaching to ODBC. The Code below is a code that is actually a module in an access database application that "buckets" patients into "6" buckets or...

Thanks, that sounds great, but do I need to have anything around understanding ODBC, knowing how to do formulas,any SQL programming, there is so much I don't know that I want to make sure someone else does know....am I needing an I.T type person...that is an experienced programmer or is just...

I was hoping someone could help me. I have been functioning as a struggling Crystal 9 report developer due to the lack of expertise within the organization. Really, I am the Quality & Performance Manager of a large teaching hospital, I have an opportunity to look at finding someone for a...

I was hoping someone could help me. I have been functioning as a struggling Crystal 9 report developer due to the lack of expertise within the organization. Really, I am the Quality & Performance Manager of a large teaching hospital, I have an opportunity to look at finding someone for a...

Absolutely Perfect...now I just have to spend some time really looking at what you did so I can repeat it for other reports... Thanks LB

Wow, I will give it a try..and let you know...learning curve is sure getting steep...

LB should I add somewhere in the month cal formula that either I do a datediff datediff(("s"),{@ICU admit date time},datetime({?fiscalyear},5,1,23,59,59)-1)+1 or somehow tell it if not discharge date do a date diff to current date???

LB, I have changed the formulas but my record selection formula is still {@ICU dis date time} >= dateserial({?fiscalyear},4,1) and {@ICU admit date time} < dateserial({?fiscalyear}+1,4,1) I have tried to modify myself but I must be doing something wrong because I get data in Mar 06 which...

Thanks LB, I will give it a try, The report is amazing by the way, I did all the running totals as you described and it is providing the unit with the correct information for the first time in 2 years...

I was hoping that I could get a little additional help. The support and solution I have received in this thread has worked perfectly, however, I have realized I have missed a select group of ICU patients These are patients that have been admitted to the ICU/CCU unit and have been there a...