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...
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
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.