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!

Register Log in
  • Congratulations derfloh 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. lkh5650

    Need help with designing form

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

    how to put a sub report and report in one line?

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

    formula evaluation after printing records initially

    aw.. that sucks.. Thanks !
  4. lkh5650

    formula evaluation after printing records initially

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

    formula evaluation after printing records initially

    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"...
  6. lkh5650

    formula evaluation after printing records initially

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

    formula evaluation after printing records initially

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

    suppress using formula

    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!
  9. lkh5650

    suppress using formula

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

    suppress using formula

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

    suppress using formula

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

    suppress using formula

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

    suppress using formula

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

    suppress using formula

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

    suppress using formula

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

    suppress using formula

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

    suppress using formula

    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})...
  18. lkh5650

    suppress using formula

    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?
  19. lkh5650

    suppress using formula

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

    suppress using formula

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

Part and Inventory Search

Back
Top