Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sfabry

    RESETTING SHARED VARIABLE

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

    record selection based on year in crosstab

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

    incorrect crosstab column and grand totals crystal 11

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

    incorrect crosstab column and grand totals crystal 11

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

    record selection based on year in crosstab

    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"?
  6. sfabry

    using same table in container and subreport

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

    using same table in container and subreport

    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?
  8. sfabry

    KEEPING NULL VALUES IN CROSSTAB

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

    passing value from subreport for record selection

    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'...
  10. sfabry

    record selection based on year in crosstab

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

    incorrect crosstab column and grand totals crystal 11

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

    passing value from subreport for record selection

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

    incorrect crosstab column and grand totals crystal 11

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

    record selection based on year in crosstab

    do you mean turn each statement into a formula?
  15. sfabry

    passing value from subreport for record selection

    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?
  16. sfabry

    incorrect crosstab column and grand totals crystal 11

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

    record selection based on year in crosstab

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

    formatting to rid report of gaps

    ahh missed that, that worked. thank you
  19. sfabry

    formatting to rid report of gaps

    Ido - is that somewhere different that the section expert?
  20. sfabry

    variance column in crosstab

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

Part and Inventory Search

Back
Top