Search results for query: *

Hello I am trying to enter a counter expression as a lookup in GoldMine V 6.7. I have an invoice number field in GoldMine and I would like this field to be auto-populated when the entry in the lookup is clicked on. I would like to start on number 00001, then 00002, then...

Hi, I am running a Crystal report through GoldMine version 6.7, when running the report previously in this way the parameter prompts would appear however for some odd reason the prompts no longer appear, instead when clicking teh refresh icon a message stating 'sub report data will also be...

Hi, I am using Crystal version 8.5. In the database we are using a character field to hold date information. In SQL the data appears as DD/MM/YY e.g. ‘28/12/07’ this is how the data appears in SQL. As this field is a character field does anybody know how to false Crystal to make it think it is...

Hi, I am currently using Crystal v 8.5 to run a report (which somebody else wrote) which consists of various sub reports, One of the sub reports uses the formula: NumberVar StartMonth := if Month(CurrentDate) + 2 = 13 then 1 else Month(CurrentDate) + 2; "Forecasts For Month " +...

Hello, I am using Crystal reports version 8.5. I am using the current formula to convert a string field into a date field: Datevalue(tonumber(mid({table.field},1,4)),tonumber(mid({table.field},5,2)),tonumber(mid({table.field},7,2))) I would also like the formula to display a default date...

Hi I'm currently using a networked version of GoldMine 6.7 and have installed Gismo in Outlook so that emails from Outlook can be linked to records in GoldMine. Whenever I open Outlook a GoldMine SQL Login screen appears asking for the SQL database credentials to be entered. I type in the...

Hi Using Crystal 8.5, I'm trying to create a formula that brings back everything to the left of a string field and excludes the deatils to the right e.g: Joe Bloggs (Ireland) I only want to get back Joe Bloggs, Ireland should be excluded The table and field used are Sales.Salesman Any help...

Hi, I am using Crystal v 8.5 and I am writing a report based on the Sales table. The problem is I am using a date/time field in the report {Sales.Date} which displays the data as 10/07/2006 00:00:00 I am only interested in viewing the date so I used the formula: date {Sales.Date} which worked...

Hi I am using Crystal 8.5, I have a field {Sales.Type}, the Type field within the Sales table has various lookup options e.g. Coke, Fanta, Lemonade, Oranges, Mangos, Hovis, Kings Mill etc. I need to add a parameter to the report, I would like the parameter prompt to display the following...

Hi, I’m using Crystal 8.5, I have four parameters on a report where users select their options via the parameter prompt screen. I would like users to have flexibility when responding to the parameter prompts e.g. entering data in the {?Team} and {?Completed Sale} prompts only, while ignoring...

Hi, I'm using Crystal 8.5. I am having a problem when trying to supress a field using a formula. The table name is Sales and the field is ref {Sales.Ref) when I right click on the field and go to format field, the format editor screen opens, I go into the supress formula icon and enter the...

Hi I’m using Crystal 8.5 and I have created a parameter called '{?!Sales}=' so that users can have a prompt to either select sales which are over £2000 or sales which are under £2000. The table name is SALES the column name is INCOME. I would also like the users to be able to select sales...

Hi, I am using Crystal 8.5 and I need help with a formula. I have a report which uses only one table the table is called 'Results'. I have put some parameters on the report so the users will be prompted to enter criteria based on e.g Lunch Meeting, Proposal Date. Excluding these two options...

Hi, I am using Crystal 8.5 and I am trying to convert the field cont.hist (which is a date/time string) into only a date string. The formula I have used is: IF DTSToDateTime ({CONTHIST.CREATEON}) then DTSToDate ({CONTHIST.CREATEON})Else 0 I keep on getting an error saying that a string...

Hi, I am using Crystal version 8.5, within the report is a date field called Createon. Createon is the only date field within the database table. I would like users to be able to select different dates from the parameter e.g createon is between 10/03/06 and 30/03/06. The problem I am having is...

Hi, I'm using Crystal 8.5, I have put a parameter on the report where user names can be selected. The drop down list shows the individual user names, however I also want to have an option where all users can be selected without having to click on the individual names. In the Parameter I entered...

Hi, Any ideas on how to supress a blank sub-report so that a blank space does not appear in the main report. I'm using Crystal 8.5 and cannot see this option anywhere. Thanks

Hi, I am using Crystal version 8.5. I have a main report which is filtered based on the user name. I have a sub report attached to the main report which is filtered on rectype. The reports are linked by accountno. The problem is the subreport keeps on repeating itself. I have clicked on format...

Hi, I'm sure this is an easy one, I am using Crystal 8.5, I have a main report which has some sub reports attached to it. I want to change the names of the sub reports to make them more meaningful, however I cannot see where this is done. In Crystal 10, this can easily be done via the sub...

Hi, I am using Crystal version 8.5 to draw data from GoldMine 6.7. I have a main report which has four unlinked sub reports attached to it. The problem that I am having is that if I put selection criteria on the main report e.g only bring back records over 50K, because the subreports are...