Search results for query: *

Is it possible to update the database in Crystal Reports 8.5? If so, how do we disable this so users don't accidentally do this? Thanks.

We have reports that have been running fine for months, and suddenly we are getting this Client Access Error Msg: SQL0204 - CHART in CRYSTAL type *FILE not FOUND Chart = our file We have the latest drivers, and the file is there. In the SQL query, the lib has never been defined, but has...

We have remote users who acccess our system via Citrix (and newlook). However, they need to be able to access their printouts at their location. I think I have to setup a shared printer session on the Citrix server, but was wondering if anyone could give me any tips on doing this. Thanks.

I need to sort invoices by zip code, but I cannot do that because of a group I already have defined in my invoice run. I am grouping by member ID, and that is the way it is being sorted. I've grouped by zip and tried using that, but it isn't working. Any ideas would be helpful. Thank you, Leslie

Hi, On a report, I need to display a member name and their business designation. We have two different designations, A and B. It is currently displaying the member name twice, with designation A and designation B next to each name: John Doe "A" John Doe "B" I just want...

I need a formula, that I think should be simple, but can't figure out how to say it. I need the formula to display a dollar amount if a member currently does not belong to a particular section, thereby giving them an option to join that section. If they are a member of it, then I don't want...

I have a large invoice run to print. Is there a way to print two copies of each invoice in the run of 5,000+ invoices, so that two copies go out to the individual, one to send back and one to keep? Thank you.

I have a simple formula: if {FILE.SECTNAME} = "SECT" then {FILE.SECTAMT} SECT = a section that our members pay to join. SECTAMT = the amount a member must pay. I need to display that amount on my report. When I browse the field data, the amount is displayed, but so is a 0.00...

This may be confusing... I am creating a dues invoice and have the member ID field at the top right of the page, in the Page Header section. I can't put this field in the details section, because of the way they want the form designed. Problem is, the report is duplicating members when they...

Hi, I have a report that lists out members with their designations, ID # and company. There can be several different designations, in which the name is then being printed twice, or up to 4 times on the report, depending on how many professional designations the member holds. How do I get the...

I'm trying to sort some badges and for some reason, what was working before isn't anymore with the formula I'm using. I need to sort by last name. Examples of last names John Doe John A. Doe John Allen Doe Another example, I have one name, LYLE VAN BUER, who is being dropped in the...

I'm trying to create an comma-delimted ASCII file of mailing info (name, address, city, state, etc). I've entered the "" and the commas in the text box around the fields and have tried to export the file as text. However, the fields can be quite long, and they wrap. When I import...

Wonder if anyone can help with this: ODBC ERROR: IBM CLIENT ACCESS ODBC DRIVER (32-BIT) DB2/400 SQL: SQL0901 SQL SYSTEM ERROR ERROR DETECTED BY DATABASE DLL Any ideas are much appreciated, thanks.

I have formatted badges in Crystal, and need help sorting. The name field is one field, which contains first, middle, last. Not everyone has a middle initial. How do I sort by last name only? I'm using the StringAfterChar formula, but still not producing the results I need. Ex. of badge...

First report I'm doing in Crystal reports - I've had minimal training... Field name is CAACT1, which holds the account number. I need all acct numbers that begin with 1000, while another field is = 00 How do I write this formula field? Please help! thank you :)