Search results for query: *

Using Crystal Reports XI Hi, i've got a date field in my report which is data inputted manually by the user, however sometimes they get the year wrong, so i've changed my report to allow for current risks only, so my parameter i would like to be able to pick only the day and month and ignore...

Crystal 10 Hi, i've got a subreport in the details and i would like to supress the group header above it if no data is in the subreport. Any ideas? Would it need to be some sort of shared variable upon which to supress the group header?

Excel 2003 Probably a stupid question but my brain has melted with all the help desk calls i have taken today. I;ve got a spreadsheet with two columns in. One for status and one for Premium like below Status Premium Secured £10000 Declined £35000 Scured £5000 I...

Cheers mate, found the Ken Hamady site, that guy is a legend!!

Using Crystal 10, I have a date field, and in my report i need to add a formula that will add 5 business days to this date if it is retail or 30 business days to it if it is commercial. However as it is business days, i need to exclude sat and sun. Any ideas? Cheers

Good idea, cheers for that mate

Using crystal 10, i am trying to create a formula that will give me the final day of the month, 3 months back from the currentdate month. So far i have this : if Month (CurrentDate) = 1 then date ((Year (CurrentDate)-1), 09, 30) else if Month (CurrentDate) = 2 then date ((Year...

Crystal 10 I have a report which needs to be scheduled to run on a server every quarter, so i need to get rid of all the parameter fields so that it can run. One of the parameters is a notified date field. Now this should be the period of the quarter, i.e. 1st quarter 1 Jan 07 to 1 April 07...

Quality mate, cheers

Crystal 10 I have a field in a table called analysisperiod, which shows the month and year of each transaction as a number in this format, 200703 for March 2007. I need to create a formula which uses the current date to create this number. I have extracted the month and year from current date...

Hi, i have a formula below: totext(dateadd("d",6,{table.date}-dayofweek({table.date})+1),"dd/MM/yyyy") However i would like the date to formatted into say "02 January 2007" rather than "02/01/2007" which is what i've got. How can i change the formula above to show the date in the formatting i...

Sorry plus i have the rest formula on the in the same group and the formula is as follows: whileprintingrecords; shared stringvar PTYPE := "";

Ok i'm using crystal 10, i have a report and a sub report and i would like a field from the sub report being placed into my main report. So i'm using shared variables. In the sub report my formula is: whileprintingrecords; shared stringvar PTYPE := ({QUOTECLIENT.FSAClientType}) and in my...

cr 10

Is there any way around grouping a fomula which has a sum in it? It has never worked for me and its annoying cause i've got got a report at the moment which needs grouping by this formula. Basically i've created a formula for Net Commission and then summed it in a group. Then i've created a...

I have a speadsheet with two columns in, and I would like to do a stats worksheet. Example of the two columns are as follows: Operator Status Donald Duck Quote Donald Duck Bound Mickey Mouse Quote Donald Duck Quote In the stats page I would like to show the number of Quotes...

There are 17000 records, wouldnt this take a long time?

I have a list of telephone numbers imported from a database. However the field in the database it has come from was a text box so there is text in some of the numbers i.e 01234-523532 or (01234) 254525. How can I in Excel convert these to numbers only i.e. with the examples above convert them...

I'm creating a report in Crystal and I would like to change the telephone number so that the 0 at the front of the number is removed, plus any non number characters are removed, i.e (, *, etc. The format i've got at the moment is random: 01234 358824 0171-254-2545 I would like it so that the...

I tried this and it seemed to work: if isnumeric (right((split({CLIENT.PostCode}," ")[1]), 1)) and isnumeric (right((split({CLIENT.PostCode}," ")[1]), 2)) then right((split({CLIENT.PostCode}," ")[1]), 2) else if isnumeric (right((split({CLIENT.PostCode}," ")[1]), 1)) and not (isnumeric...