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 aap96126

  1. aap96126

    Charting an Array

    Thanks guys for your help and advice. I'll take a look and see what I can come up with. Cheers J.
  2. aap96126

    Charting an Array

    Hi, I need to calculate a rolling 12 figure for each month of my report - i.e. the sum of the previous 12 monthly figures. (Each of these monthly figures is itself a summarised field). With these rolling 12 numbers (which I have calculated using an array) I need to calculate a trend...
  3. aap96126

    Drawing Graphs In Crystal

    Hi Rosemary It's the end of the day here and I'm about to head home. I'll try to apply your method first thing tomorrow when I come in. Many thanks for your time and help. Cheers! John.
  4. aap96126

    Drawing Graphs In Crystal

    Hi Thanks Rosemary. I am running Crystal V9. I need to calculate a 12 month rolling figure (i.e. the sum of the previous 12 months' numbers). I have done this using an array. I now need to graph these 12 month rolling figures to examine the trend for each month. But the formula I have used to...
  5. aap96126

    Drawing Graphs In Crystal

    Hi I have created a set of arrays in my Crystal report. I now need to draw a graph of these array values in Crystal, but I can't seem to do this when I try to construct a chart. Does anyone have any ideas how I can do this? Many thanks.
  6. aap96126

    Use of Arrays and Calculating Summations

    Hi I am a relative novice in CR so should be grateful for any help. I have three fields from my database: the month, fees for each month and number of members for each month. I want to try to index the month via some integer i, say, so that Jan 2000 = 1, Feb 2000 = 2, etc. My fees for each...
  7. aap96126

    Group Number Command

    Can someone please provide me with an explanation of the groupnumber command as I don't think the help function explains it too well? Many thanks.
  8. aap96126

    Dates in a Cross Tab

    Ok thanks - I'll try this this morning. I think all I basically need is some kind of calendar field, but my database doesn't seem to have this. Cheers
  9. aap96126

    Dates in a Cross Tab

    Yes there are several datefields in my database. But they are for claims received or claims entered etc. But I need to use these fields in my calculation. For example, for each monthly date that I noted in my first post I need to find those records such that: claim received date field <=...
  10. aap96126

    Dates in a Cross Tab

    I'm no expert on databases sorry - I think it's an ODBC. Does this help?
  11. aap96126

    Dates in a Cross Tab

    Yes it does have date fields, but I need to calculate a sum and if I use any of the date fields that already exists in the database it invalidates my calculation. I am not sure how to go about creating a table with dates as you suggest. I'd be very grateful for more info. Cheers.
  12. aap96126

    Dates in a Cross Tab

    Hello All I need to do is create a cross-tab which has the dates Nov 2003, Dec 2003, Jan 2004, ......, March 2005 as the rows in the cross-tab. My database has no such fields. Does anyone know of a formula/method which will do this for me? Many thanks.
  13. aap96126

    Using Dates/Arrays in Formulae

    Hi I need to perform an operation for each month end date: find the total amount for records which satisfy certain criteria for each month, and stick these values in a table with the rows corresponding to each month end date. For example, sum all values such that field1 <= monthenddate(x) and...
See more

Part and Inventory Search

Back
Top