Search results

Hi Groundrush, Moving databases to sql server can actually be more straightforward than you would think. I can be as simple as importing your database tables into a sql database and linking to the tables via odbc. I've done a similar project by using an upsizing wizard but that was going the...

Hello, The isnull thing should work if you follow this syntax: if isnull({blah}) then 0 If you want to have another condition as well the isnull i'd enclose them both in brackets like: if (isnull({blah}) AND {blahblah}>1) then ... Man, that is one complicated formula. I've only been looking...

I didn't but I think I see where you're going. If I sort decending and put the table field in the group footer it will display the last record? I'll give it a go.

Crystal Reports has been doing my head in today. It always seems to be things that on the face of it should be easy to do that I struggle with. If anyone can help me with this it would be much appreciated: All I want to do is display the first occurence of a field from the detail level in the...

A couple of suggestions to try: 1. Put your control {YourField} inside a text object box. 2. Put a blank text box to the right of the one you want to stop bleeding off the edge.

Hi Joe, I'm trying to do something similar and I spotted your post. If you want to 'hide' every subsequent detail line after the 1st you do it in section expert. Click on the supress tick box and then on the formula (x-2) button and enter in: recordnumber > 1. This will suppress all the records...

Steve, I've sent you a pm with my email address if you want to send me the rep.

I think the problem with this is that I'm trying to use a group level formula in the selection criteria. I don't think you can do this in crystal but if anyone know's different I'd like to hear about it. Thanks, Peter

The evaluate section that I was on about is in the 'Edit Running Total Field' dialogue box where you have the options: Evaluate: *for each record *on change of field *on change of group - Or - *Use a formula What version of crystal are you using?

Hi all, I’m struggling with an aspect of crystal reports and was wondering if anyone can help? I have a report which assesses jobs completed on the same day that they were started. It does this with a formula at detail level. The formula is ‘SameDayComp’: Local DateVar array start :=...

Is {1Sum of ARInvoiceDetails.GrossAmount} a Running Total? If not, replace it with a Running Total which will sum up the same field, but in the Evaluate section select 'Use Formula' and use the same criteria in the formula as you're using to suppress whatever records you're suppressing. HTH, Peter

You could put the 'Record Selection Formula' from the Special fields section into the header. But this will show all of the selection criteria that your report is based on. HTH.

Why not have 2 queries? One for the sum as above and one for the average with the clause 'Where [<85k] <> 0'.

One thing I'm struggling with is that for every Project there are 5 possible roles but in some projects 1 person can be responsible for 2 of these roles. What I have at the moment is: tblProjects: -pkProjID -ProjectName -blnLive boolean - whether the project is live or not tblProjectSurvey...

Thanks very much for the replies. I did think that as the 13 questions were different that meant that there wasn't repetition and the table was normalised... but yes, I can see the error of my ways and I wont do it again. I will give you're suggested table design a go jz. The responses are...

Hi I'd like some advice on the design of a database. I've got a survey that goes out to 4 people. Each survey is asking the people to rate aspects of the other 3. For instance an architect might be scoring a contractor in terms of health and safety. There are 13 possible questions but not...

Hi, I've got a database table containing JobNumber - JobRaisedDate - JobCompleted Date What I'd like to do is have a graph showing: * Total Jobs Raised * Total Jobs Completed ...for every week. Sounds easy but here's the thing: when I group on raised date I get all the jobs that were...

I figured it out. I didn't realise crystal was case sensitive. My record read "TRAVEL" and I was looking for "*Trav*" Solution was to change the formula to: {JobNumber} = "14248359" and uppercase({Description}) like "*TRAV*"

Does it indicate where the number / currency is expected? One thing that looks a bit strange is that there's no number at the end of line 2. Peter

Hi, Can anyone help with this: I need to search for all records that have a {description} field that contains the word "Travel". Sounds easy? I thought so. I've reduced the search down to 1 record which I know contains "Travel" and the formula is: {JobNumber} = "14248359" and...