Search results for query: *

Hello, The {All_Bids_for_Export.QuarterDate} holds Q1, Q2, Q3 etc.. The date field we could key on is {All_Bids_for_Export.StartDate} This is the date the document was entered. Will this work? It's not the last date in the quarter. I do not hold this information automatically. Thanks for...

Hi, On the Select Expert I have 2005, 2006 and 2007 selected. I also have if status is not one of Cancelled/Postponed. On the Chart I have Data - Advanced. On Change of, @YrQuarterConv - which is this formula: Year ({All_Bids_for_Export.StartDate}) & "-" & Month...

Hello, Many thanks for your response. If I create a record selection formula, this will be for all records? Will it not? I don't want that to happen. The bar within the chart needs to show all months, but the area withing the chart only needs to show the quartley average if the month is...

Hello Everyone, Here is my other post regarding another chart I'm having problems with. This chart is to display a bar, area and trend line. The bar chart shows Monthly Bid Values for a year - Jan05, Feb05, March05, Jan06, Feb06 etc... The Area chart shows the Quarterly average, and the trend...

Hello Everyone, I have a chart which displays a bar and Area. The Area chart is behind the bar chart. The bar chart shows Monthly Bid Values for a year - Jan05, Feb05, March05, Jan06, Feb06 etc... The Area chart shows the Quarterly average. I have managed to create this, and all is OK, but...

Hello, I was wondering if there was a desktop application, which would launch reports from Crystal which you've created? Our users do not want to log into the InfoView application. They would also like a link in the application (database - which is Lotus Notes) so when they click on it, a list...

Hello Ibass, The Numbers (21, 20, 8) are Total Values of 3 bids, which are the Top3. The (49) number is the grand total of the top 3 outstanding bids (21, 20 and 8)this is not calculated at the moment as I'm having problems getting the Top3 bids to display. This is where I need the help. I...

Thanks for your response, I will test this, but I do need to display the Top 3 Outstanding bids by Bid value, which is BidTotNum. so.... Bid 1 Outstanding 21.00 Bid 2 Outstanding 20.40 Bid 3 Outstanding 8.00 Grand Total = 49.40 The grand total is what I am after. Thank you. Hayley.

Hello, I have a few subreports, but one in particular needs to be set-up so I only show the Top 3 bids which have a status set to Outstanding. I have grouped this subreport by Status, and am only showing Outstanding. I have a BidTotNum field which is a number field which does a sum. I then...

Hello Everyone, I need some assistance with regards to creating a summary table via formula. This report needs to be grouped by centre, our centres are USA, UK, APAC. I've managed to do this in a group header, however the data which needs to be retrieved is...

Thank you LB. I appreciate everyone's feedback.

Hello, I have only just joined this website today and am new to Crystal Reports. I need help with creating a report, I need Current week values and Previous week values. I'm stuck.... Can anyone help or point me in the right direction? Sample formulas would really help me... I'm having...