Search results for query: *

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

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

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.

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

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.

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

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.

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

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

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

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.

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.

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