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...
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 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 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...
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)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.