Search results for query: *

Hi I have a report with a group on 'Customer_ID', each customer can have any number of accounts that sit under their customer_id and will be displayed in the details section. What I would like to do is create a string that shows the balaance of each account and display this in the group...

Good morning, I am trying to establish the dates (dd/mm/yyyy) of the first and last workings days of each month and would like to return the results in two separate formulas; - (@First working date in currentmonth) - (@Last working date in currentmonth) I define a working day as day in [1-5]...

Hi My main report shows stock levels by 'client'; I have a group based upon 'client' and have inserted a summary in the group footer to show stock levels. My subreport shows sales volumes by client and is inserted into the main report group footer and linked on 'client' The values from the...

Good morning Within a cross-tab report I have a formula as the column heading which returns a numeric value; this value is the datediff between two dates. I will be using the data returned by this report to populate a rigid template that has column headings from 1 - 60 inclusive. The...

I have a string field that consists of a customers full name, for example "Mr Stephen Harrisson" I need to display the above example in three seperate fields ie: "Mr" "Stephen" "Harrisson" Can anyone tell me how to separate the above?

I'm trying to write a batch file command to run an Access macro. The Access database itself is not password protected so the command opens it. However the macro involves linked tables from a database which is password protected so I need to include log-on details for it. Can anyone tell me how...

I'm trying to write a batch file command to run an Access macro. The Access database itself is not password protected so the command opens it. However the macro involves linked tables from a database which is password protected so I need to include log-on details for it. Can anyone tell me how...

I have set up an Access database which includes linked tables for a separate non-access database. I've created a macro which calls two make table queries on these linked tables which I want to schedule in Windows scheduler. So far the only way I have found which even begins to work is to create...

Hi all, does anyone know how to export the results of a search in Windows XP explorer? Preferably in comma delimited/excel format but any usable format would be good. Cheers

Hi there, I wish to write a query which will retrieve a number of fields plus one calculated field. The field data.narrative may contain an account_id as its first 7 digits, I want to retrieve these digits and use it to link elsewhere in my database but the account_id must be a number to be...

I need a query to select records using a DateTime field based on today's date without worrying about the current time. I currently have WHERE "Activity_Log"."Log_Date" BETWEEN DATEADD(DAY,-7,GETDATE()) AND DATEADD(DAY,-1,GETDATE()) My problem is that I want to select full days, so if I run...

First off, if I've picked the wrong forum please advise - I wasn't sure which SQL forum would be best as I have no idea which SQL Crystal uses. Now, I have a date field in my database (ODBC) stored as text "YYYYMMDD". I want to create a command in Crystal select records in SQL where the string...

I have an Access table I wish to link to an ODBC database in Crystal 11. For the project I'm working on I need to be able to use a full outer join but this option is not available. Is it in any way possible to alter my tables or report to allow the full outer join?

I am using Crystal Reports XI. I have a parameter in the select expert as follows: "@Tel Status" = (?Parameter. The value of which are either 1 or 0 depending on whether an account has a telephone number or not. This gives users the ability to select only those accounts with telephone...

Working with CR v9...I have a very simple report with five groups in : GH1 Client GH2 Contract GH3 Load Period GH4 Status GH5 Agent Each of these groups has "Hide(drill down o.k)" checked. When you drill down within the report and reach the details section I want to show field names...

Can I upload a report with this thread, or would anyone be interested in viewing a copy of the report I am having trouble with?

I have a report which is to run every Weekday (monday through to Friday). The report will run in the evening and pick up all transactions for the currentdate; my select expert therefore reads (Transaction.date = Currentdate) The problem I have is that on a monday I need the report to pick up...

When I open excel (2000) I want it to show me a blank worksheet (book1).........however, by default it is just opening the application and I then have to go to File/new to get a blamk worksheet Where can these settings be changed ?

I have a crosstab report which shows "cash collected" as a summarised field. If the value of this field is zero then i want to suppress it. Any Solution ?

I have a formula which commences with the statement (WhilePrintingRecords). I need to insert a group on the result of this formula. I understand that selection for the grouping occurs before the formula is evaluated, thus making it impossibe for crystal to perform what i'm asking. Are there...