Search results for query: *

Thank you so much. That has worked perfectly!

Sorry, one last question. I have found that there are several possibilities for the entering of company details in the form of Pty Ltd, Pty. Ltd. and P/L What is the syntax for using an IF OR statement? I think the one I figured out is an AND statement (where all three conditions must be met)...

That was perfect! Thank you.

Hello, I have followed your instructions and I am not having any success. When I use teh following formatting I am still seeing all the results, and this includes those where the offender name contains "Pty". {IF {<<Offender>>} = "*pty*" "" {Offender}} What I would like to see is that if any...

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

Thank you so much for your help. I used George's Where Text16 > '' And Text17 > '' and it worked beautifully.

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

I wasn't getting anything at all. I retested it and found that there is actually a space before WW which I couldn't see. I copied the data directly from the table and then found the space. I then amended the "WW" to be " WW" and it works fine. Thanks for your time :)

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

Thank you. I tried the SQL expression and it worked beautifully :)

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

Thanks guys. That helps heaps. I will now be able to do some research and speak with confidence.

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

Thanks so much

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

Worked perfectly. Thank you

I went another way with this which kind of sorted my problem. I grouped by job number and then used the maximum of the journal entries (based on date) to give me the most recent description. Because there are many types of journal entries, I used a formula if ({Journals.Description}) =...

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

Thanks for that :)