Search results for query: *

Thank you for the expression it worked, also thanks for the link to the gmblog, very useful. Jones

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...

Not to worry I have figured it out now. Cheers!

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 Ibass, Thanks for this, however after writing the formula I keep getting the following error: A month must be between 1 and 12. Any ideas?

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...

Also, it would probably be useful to know that the report has been grouped by {Sales.status}. The desired out come would be something like: 'Status' field: Totals: Client 3 Potential clients 5 Cold Clients 7 In the above example the Clients which are being...

Hi Ibass, I've tried what you have suggested but it has not made any difference the field is still being supressed. Yes you are correct the string does say 'Client' there are not any blanks as the entry for 'Client'is automatically generated by the system itself. Also the check mark in the...

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...

synapsevampire, I get the following message when creating the formula in the sub reports. whileprintingrecords ; shared numbervar Totsum; Totsum:=Totsum + Sum({CONTSUPP.ZIP}) The message basically says that a number field or currency amount is required and the cursor flashes just after the...

Sorry I made a mistake, I'm trying to convert the date/time value so that the Conthist.Createon field is only a date type.