Search results for query: *

Hi I am pretty new to designing form in adobe acrobat. I have adobe acrobat 9 standard with Adobe liveCycle Designer installed. There are couple of things I want to do. 1. I would like to add a box where I can change the number (default is 1), and when I increase it, (for instance to two)...

Hello I need help. I am trying to generate report and I have a sub report generated in detail so each row it would be like this.. with header name address age height weight A B [sub-report ] C D [sub-report ] E F [sub-report ] Now of cors i am not...

aw.. that sucks.. Thanks !

AE_EVENTS.BODY_SYSTEM <= event description COMPANY_DRUGS_REG.PROD_CD <= drug also three of these are used in sub reports to count similar cases by mid lvl term/pt term/sub body term AE_EVENTS.MID_LVL_TERM AE_EVENTS.PREFERRED_EVENT_TERM AE_EVENTS.SUB_BODY but its like this pt term < mid level...

Hi Here is the sql query... it is very long =========== SELECT DISTINCT "CASE_LIST_DTLS"."CASE_LIST_NAME", "CASE_LIST_DTLS"."PICKED_FLAG", "AE_CASES"."CASE_ID", "AE_REPORT_SOURCES"."RPT_SOURCE_TYPE", "AE_CASES"."EV_OCC_COUNTRY_CD", "AE_CASES"."CASE_CREATE_DT", "AE_CASES"."PATIENT_ID"...

Thank you for the reply and I tried the way you told me to do and it works perfectly However, when I try to export the data out to excel format it takes a very very long time... is there anyway I can try to shorten this time? I think the problem is, the sub reported is generated for each row of...

Hi I need some help.. :( so initially my report will be printed and it will be divided into couple of groups case ID source event seq # drug now I have to evaluate this formula similarcases after it is all printed. usually the reported is generated within the interest of time period...

Phew Thank you so much LB :) I finally got it to work! yay yayaya thanks!!!!!!! Btw i was thinking why would it be descending?? it has to be ascending (1,2,3,4.....10) and picking the top 1 should give me the data i want. thanks!

Thanks for the reply Group on the formula I showed in my last post. This will become your group number 2. => so create a formula field name lets say group_2 then paste the formula //if isnull({SOURCE_TYPE}) then 10 . . . else if {SOURCE_TYPE} = 'T' then 9// there? Place the same formula in...

Thank you for your reply LB but i am not quite understanding what I am supposed to do :( :( can you explain it to me alittle bit more in detail? Currently group1- Case id group2 -source

SO I tried save & close re-openning the crystal report file and refreshed and it now displays the records.. why does this happen?? and how do i still do this //so for instance case ID abcd has source of C/S then I would like the report to only show records of C if the case ID abcde has...

something is really weird It was acting weird so i changed the report - selection group w.e part to if sum({@a1},{AE_CASES.CASE_ID}) <> 0 then {AE_REPORT_SOURCES.RPT_SOURCE_TYPE} = "C" else if sum({@a2},{AE_CASES.CASE_ID}) <> 0 then {AE_REPORT_SOURCES.RPT_SOURCE_TYPE} = "R" else if...

so for instance case ID abcd has source of C/S then I would like the report to only show records of C if the case ID abcde has sources of S/""(NULL)/K then id like it to show only one (any one of) those 3. so record of S or "" or K which i dont care

Hello THanks for the reply but when i do that now it only shows me the cases wehre a4 <> 0, every other records where a1~a3 <> 0 is not displayed.. :(?? if sum({@a1},{AE_CASES.CASE_ID}) <> 0 then {AE_REPORT_SOURCES.RPT_SOURCE_TYPE} = "C" else if sum({@a2},{AE_CASES.CASE_ID}) <> 0 then...

Thanks it works However for last line sum({@a4},{AE_CASES.CASE_ID}) <> 0 then {AE_REPORT_SOURCES.RPT_SOURCE_TYPE} = "S" i was hoping I could display all of them not only "S" so all of them except C,R,L (so S,D,K,...., inclduing null) How would I do that?? or should I just introduce more...

hi I have it as this if sum({@a1},{AE_CASES.CASE_ID}) <> 0 then {AE_CASES.CASE_ID} = "C" else if sum({@a2},{AE_CASES.CASE_ID}) <> 0 then {AE_CASES.CASE_ID} = "R" else if sum({@a3},{AE_CASES.CASE_ID}) <> 0 then {AE_CASES.CASE_ID} = "L" else if sum({@a4},{AE_CASES.CASE_ID}) <> 0 then...

sorry actually if sum({@a},{table.goupfield#1}) <> 0 then {table.groupfield#1} = "a" else if sum({@b},{table.goupfield#1}) <> 0 then {table.groupfield#1} = "b" else if sum({@c},{table.goupfield#1}) <> 0 then {table.groupfield#1} = "c" ) in here shouldn't it be if sum({@a},{table.goupfield#1})...

OKay So i did the help on field sum i understand what your code is trying to do since my field for group field #2 can take up to 10 values should i then create conditional formula a,b,c,d,e,f,g,h,i,j.... to accommodate all?

I don't understand what your code is trying to do.. what I meant to say in my first post is I have it so that data is grouped by caseid, then it is grouped by source within the same caseid, if the source c (highest in hierarchy) is there, then none of the other source should be shown..except...

Hi Thank you for the reply. I will give an example of codes currently there is this field called {SOURCE_TYPE} it can take values like, C,D,K,L,M,O,R,S,T and null and each case can have multiple source_type I want them to have hierarchy, so i introduced a formula called sourcehierarchy if...