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

    arrays in formulas in groups

    hey jim, just wanted to let you know that everything is working fine now :) you were right. i just chucked all the formulas into the details section and i added a "whileprintingrecords" to every single formula and it just solved all my problems like the wave of a wand! Thanks. also, i...
  2. addy80

    is the order formulas are placed on report IMP??

    Hi everyone i wanted to know if the order of placing the formulas on a report affects the output.
  3. addy80

    arrays in formulas in groups

    ok, here goes then. Exception table: ------------------------------------------------------------ exc value1 value2 value3 value4 value5 value6 desc Type 1 <NULL <NULL> <NULL> <NULL> <NULL> <NULL> TI 2 3/13/02 5/13/02 <NULL> <NULL> <NULL> <NULL> LBV 3 2/1/01...
  4. addy80

    arrays in formulas in groups

    thanks for the enlightenment jim. you reminded me of one thing that i tested once. i tried accessing all the exception table records in the group and only the first record was seen in the group header. so, i guess u were right. when i tried to access the records in the details section however...
  5. addy80

    arrays in formulas in groups

    now that you know how things are working in the report and have a clearer idea of what is happening , it'll be easier to refer to stuff. thanks for your time once again(is this freelance or do they pay u? heheh) ok jim, let's get 2 things clear. 1. i am certain that i can process all the...
  6. addy80

    arrays in formulas in groups

    yes you are correct for the group1. but, group2 is grouped by {serial.number}. {serial.number} is inserted by me into a serial table. I used VB to insert it in in my vb code. like this: ------------------------------------------------------------ For i = 1 To 24 row =...
  7. addy80

    arrays in formulas in groups

    thanks once again for helping jim i did what u said. i added the 'whileprintingrecords' to every formula and it didn't work either. in fact, when i tried to display the @RDarray, nothing came out. so i guess it's not 'whileprintingrecords'. i split up group1 into 2 sections too and took out the...
  8. addy80

    arrays in formulas in groups

    hey jim, wondering if they actually pay you during these five minute &quot;breaks&quot;... Well, back to what you do best... [medal] I think i agree with you on the fact that the formula can only access one record at a time. So, i guess my formula only does access one record. But that still...
  9. addy80

    arrays in formulas in groups

    hope i am not interrupting your interlude with nicole, jim. at least tom is outta the way :) but thanks for the advice. i tried correcting the appropriate sections of code but the zeros still maintained. i don't quite agree with the part about how u can only access one record in the formula. i...
  10. addy80

    arrays in formulas in groups

    thanks for replying jim. congrats on your best supporting actor oscar. now back to the problem :) if there are any CR experts out there, pls help me! i have a few tables in a dataset that i report from. namely, rebates, exception and serial. the report is divided into groups based on rebate.id...
  11. addy80

    arrays in formulas in groups

    I am having this problem with CR. Could you kindly take a sec to help me? I have a report which is subdivided into groups. each grp is then divided into a dynamic number of groups. let's call the grp higher in hierarchy gp1. i have a formula which populates an array in the gp1 header. So, each...
  12. addy80

    arrays in formulas in groups

    I am having this problem with CR. Could you kindly take a sec to help me? I have a report which is subdivided into groups. each grp is then divided into a dynamic number of groups. let's call the grp higher in hierarchy gp1. i have a formula which populates an array in the gp1 header. So, each...

Part and Inventory Search

Back
Top