Search results for query: *

Hello, I am hoping someone can help with the correct syntex for how to do the following. I have a template with merge fields and I would like to create a new merge field using the IF option. IF the {offender} is a company (so has PTY LTD or P/L at the end of their name), then this field...

Hi, I am trying to create a select query which will show me only the records which have a value in 2 fields. I have tried the below and it seems to work okay except that i am still getting some records which have an 'empty' Text17. In the example below I do not expect to see the 2nd and 3rd...

Hello, I am hoping someone can help with a code or similar to import csv files into Visio 2003/2007 (we have both). We have a document management system (DMS) which has a workflow engine. Long story short we need to get these workflows out of the ECM and process mapped in preparation for a new...

Hello, I am trying to create an if and then formula, but am not having any luck. I am hoping someone can help with the syntax (or formula). I have sales data which I want to identify which ones contain 2 specific values. my formula is as follows: if {Jobs.Site} = "WW" and {Jobs.CustomerName}...

Hi, Is there any way to create a field etc to allow the name of the user who printed the document to show? For instance Report Printed by: {@username} We create the reports through CR 2008 and they are run by end users on terminals (they log into the terminals using AD) through an MIS. We...

Hello, We are currently using CR Server 2008 to schedule reports that are created in CR 2008. All working fine from that perspective. One of the finance guys has asked about the repository and saving data in there which can be used with various reports (from what I can tell, he believes that...

Hello, We are currently using CR 2008 as well as Crystal Server 2008. One thing we have found is that CS is fiddly when it comes to updating existing reports. The process we are currently following is as follows: 1. Develop report in CR 2008 on separate server. 2. Log into Crystal Server and...

Hi, I need to show any jobs which are on hold but I want them removed when their status changes to in progress, so am guessing it would be a if-and-statement? I have journal entries which show job number, date and time of the journal entries and a series of descriptions. The descriptions I am...

Hey all, I am trying to find a smart way to verify whether the person who created the online order is a staff member or a customer (customers have access to online ordering system). Obviously I can create a formula which would list staff members and compare to the creator; if...

Hello, I cannot print A3 CR document from MIS. We use CR 2008 to create reports/documents which are then run from our MIS. We have a report which is created as an A3 document, and will print this way directly out of CR, however will only come out as A4 page which shows only part of the actual...

Hi, I have a sales report, and need to show only the name of the account manager and their total sales, for the account manager with the highest total. (Using CR2008) details section has the following; {CreateDate} {Job No.} {Price} {AccountManager} {State} I have account managers in two...

Hi, Can anyone assist with a formula which will give me dates based on what week number it is? (CR 2008) I am able to get the week number using DatePart ("ww", currentdate) What I need is to have the date range from the Monday to the Saturday for the previous week. So if last week is week...

Hi, I have created a report which contains duplicated data as a result of multiple enties in a journal table. These are created when the user updates the status of a job. In order to give me totals by group and exclude the duplicate values, I needed to create formulas. @TotalSheets Sum...

Hi, I am trying to produce box labels which have a string that needs to end in numbers like 001, 002, 003 etc to a maximum which is equal to the total number of boxes. I tried using record number however this displays as 1, 2, 3, 4 etc. How can I get the record number to format the way I need...

Hello, We have a document which is located on a network server and is accessible to several users in a department. All users are working from PCs with local printers attached. This despatch label will only print for one of the users and comes out as intended. When the other users try and print...

Hi, I have been working as a Business Systems Administrator for the past 3 and a half years or so, in Melbourne, Australia, and was hoping to move into Business Intelligence/Data Analysis. I have applied for about 25 roles in the past 3 months or so, however have been unsuccessful in even...

Hi, I am trying to share a variable from a subreport to the main report, but when I add the shared variable to the main report, the last entry from the subreport keeps repeating in every line. Subreport shared variable @SharVar whileprintingrecords; shared numbervar x := (DistinctCount...

Hello, I have a string which can vary in length and I need to split it so that it only shows particular data based on certain words. Below is an example of the string. Description G100K5 4/0 660x920 100gsm Laserbond . 4 colour process both sides. 900 X 640. MATCHED TO PROOF: this is a test of...

Hi, Am trying to figure out a formula/s to show me the date of the previous year, based on day of the week and week number. Say yesterday is Wednesday 1st June. I want to find out the DATE for Wednesday LAST YEAR. I know that this date is 2/6/2010 by checking a calendar. So what I want is for an...

Hello, Am trying to create a report which compares currentdatetime data with data from the previous day. I had success using the below formula, until today (1/6/2011) (date(year(currentdatetime),month(currentdatetime),day(currentdatetime)-1)) Now I get an error which says "A day number must be...