Search results for query: *

I am trying to reset a variable that is passing from my subreport to my main report. I have tried placing the reset formula in the header and footer of the main report and it is not working - the value from the previous shared variable carries over until there is a new value. Here are my...

ill continue to work on un-muddling it then. thank you for your help.

no, i am just using another program to check certain aspects of the data - i am not looking to compare between different sources. my point was that is throwing me off in how i am reading the data in the crosstab.

Oh, OK. I had not thought of it like that at all. How do you have a different summary in the total field so that it sums what ever summary is in the row/column? The other thing that is throwing me off is that the numbers I am checking against are not a distinct count but those totals are more...

i did also set up the formulas but i am not sure what you mean? since i changed from currentdate to the date param i should change it back to "- 1"?

interesting...can you see this being any different with views/virtual tables?

I have been told, in a vague sense, that you should not use the same table in mutliple places because it causes glitches. Can anyone explain or debunk this? If true, is there a way around it?

thread767-1677687 I am trying to do the same as the above thread but was wondering if there is a way to do this with a formula in the crosstab or field. Thanks in advance.

I am not sure if this will accomplish what I am trying to but am curious. My only choices under "subreport parameter to use" are blank, "Parameter Fields," and "?Pm.." So I am not sure what you are referring to? I am trying to say, in the main report record selection, "if 'subreport field'...

I actually think I got this to work by fixing the date - @YEAR year({v_Surg_Proc_CR.cr_prdate}) this is also the field that date range parameter is set on RECORD SELECTION if ({@year} = (2011)) then {@2011} else if ({@year} = 2012) then {@2012} Do you know of a way to make this compare this...

I am not sure I follow...shouldn't the "total row" just be the sum of the column?

the first instance i am familiar with but can you explain how you would link parameters to use in selection formulas?

INPATIENT OUTPATIENT Total INPATIENT OUTPATIEN Total Total 164 275 439 162 262 424 ANESTHESIA 0 24 24 0 37 37 BARIATRIC 0 0 0 1 0 1 CARDTHOR 7 7 14 8 5 13 COLORECTAL 2 2 4 0 1 1 DIAGNOSTIC 0 0 0 11 15 26 ENT 6 57 63 4 65 69 GASTRO...

do you mean turn each statement into a formula?

I have not found a specific answer to this question: can you pass a value from a subreport to main report and use the passed value in group or record selection? is this what is meant by 'parameter' or is it strictly "?parameters" they cannont be used in?

thread149-431823 I am having the same problem as the above poster - but the thread was never resolved. My counts are too low and when exported to excel and summed they are correct. I am not grouped or sorted on anything and some of the other columns DO add up correctly. I am also fairly...

I have a cross tab that is sorted on YEAR > MONTH > PT TYPE so that JAN 11 and JAN 12 are together to be compared etc. Last we changed midyear the way we recorded a certain set of data thus I have to use different criteria to correctly select data. Below are the formulas I am using. I am...

ahh missed that, that worked. thank you

Ido - is that somewhere different that the section expert?

i think i have actually gotten this to work! i did adjust your YEAR formula becuase it was reversing THIS and LAST year: if year({v_Surg_Proc_CR.cr_prdate})=2012 then year (currentdate)-1 else year(currentdate) i changed to: if year({v_Surg_Proc_CR.cr_prdate})=2012 then year (currentdate)...