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

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

ok so there is probably a really easy solution to this... i have a container report and 2 subreports. the container report is grouped on one field and one subreport is grouped on one field. when the report is run tbere are large gaps before large chunks of data that is making the report many...

I was wondering if anyone can shed some light on why a fields data may be browse-able in field explorer but when placed in the report it does not populate? Im using XI v2 if that makes any difference.

What do i use to join the 2 statments below? If i do not put anything after "null" then the field does not show up in my command. SELECT "v_basic_booking_data"."book_urn", "v_basic_booking_data"."fac_mnc", "v_basic_booking_data"."book_date", "v_basic_booking_data"."book_status"...

I am trying to add a variance column to my crosstab, I did see some other forums but it is not exactly what I am looking for. Ive also seen some suggestions for the advanced calculations option but i do not have that available and would also like to avoid a manual crosstab... I am new/self...