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

    Array Display

    Okay so I need to find how many make up the array - so I have a distinct count included, but I get an error on this saying it needs to be an integer between 1 and 1000. Whileprintingrecords; global stringvar array my_array; global numbervar n := distinctcount(my_array); global numbervar...
  2. satinsilhouette

    Array Display

    Cannot replace n with a number because I don't know the number. Thanks so much! satinsilhouette
  3. satinsilhouette

    Array Display

    I haven't writtne an array display in about 5 years, but need to now. I am getting an error on the counter in the declare formula and in the populate formula for the counter_myfield: Declare formula: Whileprintingrecords; global stringvar array my_array; global numbervar counter_myfield:=0...
  4. satinsilhouette

    Rotating Period for Group

    LBass - I didn't even think about that. That is like too simple. But Thank you! Thanks so much! satinsilhouette
  5. satinsilhouette

    Rotating Period for Group

    I need to have an accounting period, which controls the grouping(s) rotate. Here is the example: Period 01 - Period 12 should be shown first in the report Period 02 - Period 01 Period 03 - Period 02 Period 04 - Period 03 Period 05 - Period 04, etc. so if the Posting date is in May, then April...
  6. satinsilhouette

    Faking page numbers

    I need to fake count pages, but only its in a group. The page footer and header are not being used because they need a cover page and then a blank last page, so I have the report making a new page before the first group and after the group of information for that same group. That works...
  7. satinsilhouette

    Array Issue

    I tried your exact array formula: whileprintingrecords; numbervar array x; datevar array y; numbervar i := i + 1; numbervar j := count({Sheet1_.Client},({Sheet1_.Client})); if i <= j then (redim preserve x[j]; redim preserve y[j];x := tonumber({Sheet1_.Account}); y := datevalue({Sheet1_.Date}))...
  8. satinsilhouette

    Array Issue

    Thank you lbass, but it comes back with 'the word else is missing', which is where I was two days ago. So I am still stuck. By the way, your help to this forum is invaluable. I don't get to deal with this stuff on a daily basis, or very often at all. It's nice to know you are still on this...
  9. satinsilhouette

    Array Issue

    I have an array set up to gather 2 sets of variables to fill and x and a y array. I don't have the detail section quite down, it is asking for a then on the if statement in XI R2. Thought you could leave it without a then piece to the statement. I am horrible at loops, how do I do this? Reset...
  10. satinsilhouette

    XIRR

    I see where you are getting that error, need to try to work around that. Yes you do need to have at least one positive and one negative number and all dates have to historically fall after the initial investment date. Thanks! Will try this, I wasn't quite there. Thanks so much! satinsilhouette
  11. satinsilhouette

    XIRR

    I need help setting up the array correctly to feed into the XIRR formula. I am not great with loops or do's and I think this is what the formula needs. Interesting problem, I haven't worked something this hard in a long long time. Thanks so much! satinsilhouette
  12. satinsilhouette

    XIRR

    Let me add to this: I have built a formula to populate an array for both a date field and a currency field. In Excel if you have 5 records from a1:b5 then XIRR looks like this: XIRR(A1:A5, B1:B5) Here is a version that works in Crystal that would require manual entry of new quarters numbers...
  13. satinsilhouette

    XIRR

    Okay so now how Lbass how did you fill the XIRR piece with the arrays? Thanks so much! satinsilhouette
  14. satinsilhouette

    XIRR

    Hmm, I can get the arrays to populate, supposedly this should work like excel. But in excel I can tell it to look at a range of values A1:A3 for example. So here is what I have so far, working off of an excel spreadsheet F1 is the customer name, F2 is the date field, F3 is the currency field...
  15. satinsilhouette

    XIRR

    I don't think you need a guess value. How did you do the array, that is what I am struggling with now. Thanks so much! satinsilhouette
  16. satinsilhouette

    XIRR

    For some reason it is not working? I guess you can manually enter the array values as in the example, but I don't think that is realistic since this is being read from a database over a period of time, many quarters, so then how does one populate the XIRR function with an array? Maybe that is...
  17. satinsilhouette

    XIRR

    Can someone explain better than the help section, how XIRR is used? If you have these figures with these dates: Group ABC: -10000 1/4/06 -10000 2/4/06 10000 1/5/05 30000 12/5/04 XIRR(values, dates) The report is grouped and the data above is an example of...
  18. satinsilhouette

    Case statement in Where clause

    Seems to work bborissov - Thanks! Thanks so much! satinsilhouette
  19. satinsilhouette

    Case statement in Where clause

    They are parameter feeds accepted by the report writing tool. Thanks so much! satinsilhouette
  20. satinsilhouette

    Case statement in Where clause

    I found something on a SQL board about using a case statement in the where clause and haven't gotten it to work yet. Need: a data field that can have one choice, a range of choices or no choices. Control group is the field and it looks like: Control Group Start ______ Control...

Part and Inventory Search

Back
Top