Search results for query: *

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

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

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

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

Hi I am using crystal xi and am struggling to calculate a rolling 12 month average - I have searched the site but have not found anything that quite answers my question. I am trying to chart the average number of bids submitted in a 12 month period compared to previous periods. For example...

Hi, I am using Crystal Reports Xi and infoview. I have a number of reports set up to email automatically in infoview (enterprise). Recently the database changed and the reports started coming out blank. I changed the reports in infoview and although they are now fine when run manually, the...

Hi i am using CRXi. Does anyone know if there is a function in crystal to trace where a field has been used in a report. I have a field with a tick on it so know it is in use but cannot find it anywhere and was wondering if there is a simple way of showing what other formulae, groups, select...

Hi all, I am using CRXI on sql database I have a report with 52 columns (weeks) each with numbers 0-5. I need to format them conditionally i.e. 1 = yellow, 2 = blue etc. I can do this with the highlight expert to one column but cannot apply the formatting to all 52 and would therefore have...

Hi all, I am v new to SAP and require some help on a specific report. The report is S_ALR_87012993 - Orders: Actual / Plan / Variance. I understand that you can drill down to the actual invoices once you have shown individuial line items, but I have no idea how to do this and would appreciate...

Hi I am using CRxi and SQL Server. I would like to use a simple formula to evaluate if two seperate dates fall between a date range. Rather than evaluating each date seperately I wanted to use a simple array, but am unsure what I should enter. My first attempt is: if...

Hi I am using Crystal Xi. I have a chart that displays the number of sales won in each month. The sales are grouped by month on the X axis and the count is shown on the Y axis. The trouble I have is where there are no sales, the month is not shown. I would like the grouping still to be...

Hi, I am using Crystal Xi. Does anyone know if it is possible to supress a 0 in a bar chart. I have a stacked bar chart and the zero's cause no end of trouble as you cannot read the values that do have values. I have searched this site and been unable to find an answer. any help would be...

Hi All, I am using Crystal Reports Xi and am interested in developing a report that shows a map of the UK. The map would ideally show values of work with local authoties in the UK. Does anyone know if it is possible to map by local authority? Currently I cannot even map by county or city as...

Hi , I am using Crystal Reports Xi with Crystal Reports Server (Infoview) I have a report that displays a number of charts and tables. when I refresh it in Crystal it seems to work fine, but when I refresh using infoview, the report cuts off part of the chart and table. This happens...

Hi there, I am using Crystal Reports XI with Crystal Reports SErver in Infoview. It seems that when I schedule a report to run and email I have a problem when I try and add a file as an attachment. In order to attach a file, you click the attach file check box and then schedule. However the...