Search results for query: *

Ok I have a sql database with an opportunity table with details such as: ID Name Submission Date 24 Oxford 24/10/08 25 Cambridge 30/10/08 I then have a completeley seperate list of approval dates which is stored in an excel spreadsheet e.g. 20/10/08 25/10/08 01/11/08 I would...

Thanks all for your help with this. However I dont think I was clear enough with this one. Basically the approval date is held in a seperate unrelated table or I could hold them in an array. However how do I get the submission date to reference the most recent date? Thanks simon

Thanks for this, The Submission date is one of the fields in a table. However the list of approval dates simply sits outside of the database as a list of dates. I was thinking I would have to add these in as an excel or access file but there is nothing to link to in the main database. Cheers...

Hi I have a list of approval meeting dates like the below 01/10/2008 08/10/2008 15/10/2008 22/10/2008 29/10/2008 05/11/2008 12/11/2008 19/11/2008 26/11/2008 03/12/2008 10/12/2008 17/12/2008 24/12/2008 31/12/2008 I then want to select the Approval date based on the submission date. The report...

Thanks However im not sure how this would pick up the relevant date from a list for each submission date on the report. Cheers Simon

Trouble is I am working from views and therefore cant ammend the SQL.

I want to display both dates but only display the appropriate approval date. The list will contain dates for the next 2 years and therefore I need to pull out just the date closest to the submission date. Cheers Simon

Hi I am using Crystal Xi. I am putting together a report based on submission dates for bids. Each bid requires an approval priot to its submission and there is a 2 weekly approval meeting. I therefore have a list of approval dates, e.g. 1/10/08 15/10/08 29/10/08 etc. etc. As well as a...

Hi We are currently implementing Project Systems in version R3. We have gone live but are really struggling with one key part. We have a series of activities which have a duration, activity type and % set which then calculates the amount of work and cost. The activities sit under WBS...

Hi I am using CR XI. I am trying showing a trend line graph for the last 12 months. Each month plotted shows a total of the previous 12 months (e.g. June 2008 shows a total of July 07 - June 08). The problem I have is that if a months data is missing, the figure is not shown. E.g. in...

Thanks Unfortunately there will be a maximum of 4 detail sections, but could be anything from 1-4 displaying which makes it difficult as the text box idea wont work.

Thanks for the response However I tried this and the number is just repeated in the details section. I placed @reset in group header 1 and then @eval in GH2 and Details a,b,c, and d. Any ideas?

Hi I am using CR XI. I have a report that I need to include a sort order for i.e. a columns which starts from 1 upto maximum number. I was trying to use the recordnumber function but it does not give the desirede result. The problem I have is that the report is grouped and then the details...

Hi I am importing a series of tasks from excel and when I import I use an ID in the Text1 field so that I can merge future data when I update. The problem is that when I remerge the data, there are often some additional tasks imported. Project therefore adds these to the bottom of the list...

Apologies I tried to simply my post by saying I was using excel. I actually export from a sql server into excel as this is the only way of getting the dates out of our sales database. Problem I have is that the sales database will not plan resources and I do not want to update 2 systems, so...

Hi I am trying to link data froma excelinto Microsoft Project. I have a number of start and end dates which I am trying to import to project as tasks. The idea is that I can assign resources between the start and end dates in project and then if the dates change in excel I can update project...

Hi I am using CRxi. I have a stacked bar chart that looks a bit daft at the moment because data labels are printing on top of each other - Most being 0 value. However I cant get rid of the 0. Does anyone know how to supress the 0 - I have searched and cant find an answer on the site...

Thanks for your help. I have used similar formulas to the above to count the number of bids submitted. However, I need to display the data as a line graph over month headings if possible e.g. Jan07 Feb 07 Mar 07 Apr 07 40 45 42 40 Do you know if this is possible?

Hi I have a problem with a bar chart in Crystal Xi I have a report that displays the last 12 months sales by month in a chart. The chart also displays a rolling 12 month average of sales. I have set the sales formula to just sum the sales if they are in the last 12 months and therefore any...

Hi all Does anybody know if there is an equivalent to countif / sumif in crystal xi? Thanks Simon