Search results for query: *

Hi, I am hoping someone can help point me in the right direction. I have a table of streets (central_site) Against this I need to run a report to show ( for a single street ) whether that street has had any jobs, enquiries or defects in a set time period. the associated tables for this...

Hi, before I go completely out of my mind I am hoping someone has come across this before and hopefully has a solution. Although just knowing I am not alone and not seeing things would be a biog help! I am using crystal XI reporting on a SQl 2005 database. The report is relatively...

Hi, I have been asked to fix someone elses spreadsheet which is giving unexpected results but I have fallen at the first hurdle as the formula ( a nested if statement) makes use the edit! command, but I have no idea what is is actually doing. Can anyone advise, as searching for edit brings...

Hi, Can anyone help with this: I have a report looking at hours worked to calcuate pay (so quite important to get right). Rates are paid at one level for the first 37 hours, and a different rate thereafter. I have a report which calculates per person these figures. However I then need to sum...

Hi, I hope someone can help, I know a number of people have reported similar issues but I have not found a solution. I am using Crystal reports 10 and enterprise v10 over XP. I have a report which is linked to 2 databases - a SQL database with logon information which I have saved in...

Hi, I am trying to print a document from adobe reader 8 but I am losing the bottom few lines of the documnet. In the print dialog box I have noticed this error only occurs where the document size is larger than the paper size (as displayed under the preview image). Does anyone know if this is...

Hi, I have ad a good look around and as I can't find anything about this I assume it can't be done - but I live in hope. I currently have the following statment: {If{Mergefield "PE"}="M11" "monday" {If Mergefield "PE"}="M12" "tuesday" If{Mergefield "PE"}="M13 "wednesday" {If{Mergefield...

Hi, I have a form used to generate query output. The user selects criteria in a simple combobox on the form. It all works apart form the "other" selection. I have a list of types of work - and one needs to be other - when selected I want the query to show everything "leftover". To make this...

Hi, I apologise in advance for this, but I am trying to learn VBA - rather than cutting and pasting as I have done for so long. I am trying to understand why i need to declare a reference to a form. For example I have some code which looks at information entered on a form, and runs two...

Hi, I am dealing with schedules which vary based on a four week rolling programme. I neeed to display which week we are currently on from current date - and calulate what week exisitng data was collected based on a date. I have used DATEPART to show the week number from the first full week in...

I am reporting on data in an external database I have no control over, using crystal 10. I have a table with one to many relationship. Main table has job details and linked table has job type and payment type: e.g. job no 1 ----- type = a ----- disc = y job no 2 ----- type = a...

This maybe be really simple, but I cannot seem to work it out. I have a database which holds lists of recycling sites, and the days they are collected. I want to help the users entering collection info for each day, by allowing them to select a day, and then the form will only display those...

I am using CR 10 linked to MS Access via ODBC I have been looking at this for so long I no longer have any idea what I am doing. I have three tables in a database - The first is a list of visited properties. The other two are linked and contain lists of streets (date visited/street name/area)...

Help! Cr 10, MS Access: I have a fairly simple report relating to visits to addresses - where the visit has deemed to have failed a flag is checked. My crystal report filters only those failed. I simply need a list where this has happened more than once in a specified date range. I have data...

I have had a similar problem to many in opening reports linked to Access in enterprise. Having read a number of entries I am trying to follow the advice to change the logon on for page server/job server/web component server to something other than local host. Unfortunaltely every time I change...

Hi, maybe someone can help. We are using IPAQ's to collect survey data from customers in pocket excel but it is rather unwieldyas the survey is complex and needs to be more interactive(jumping between questions etc). But the functionality in pocket office is so cut down as to be useless. The...

I think I have been thinking about this for too long and can't see the answer so any help is gratefully received. Background: We have a corporate SQL database recording all incoming complaints. I have been asked to write a basic access database to store information about audit work carried...

I am using crystal 8.5 linked to sql server 2000. I have two offices using the same set of reports stored on a server. In one office everything looks and prints fine. In the other office - offsite, many of the fields do not display when opening the same report, but when the report is printed...

Ok, this is driving me nuts. I'm in Access 97, I have tried using the unmatched query wizard and writing this from scratch and I get the same result: I have two tables Table 1 = list of all open business Table 2 = all business which are being inspected Each business has a unique identifier...

Hi, I hope someone else has come across this as I haven't found anything here that matches my problem. I am using Crystal reports 8.5 and enterprise 8 over netscape enterprise server 3.62. I have a report which views and prints fine within crystal reports which has the following basic...