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!

Recent content by lkh5650

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

Part and Inventory Search

Back
Top