Search results for query: *

MDE runs fine in Access. It is a secured MDE...I entered in the username/pw info in Crystal and pointed it to the security file....I still get an error though and Crystal shuts down. If I leave the username and p/w blank in Crystal, I can connect to the MDE (it shows the list of tables...

Hello, Does anyone know if Crystal Reports 11 can connect to an MDE datasource? When I try to connect to the MDE, Crystal gives me an error and shuts down. This is my first time connecting to an MDE. I am not sure if I get an error because of a bug in Crystal Reports or if you just can't connect...

I just tried connecting via ODBC...Crystal lets me connect OK..., but when I go to select a view or a table, it says I don't have permission to. I entered in the database password in the OBDC connection. I'm pretty new with ODBC...any ideas what I could be doing wrong.

Hi Ido! It's an error I get from Crystal designer. All I am doing is using the report wizard to create a new report. When I link to the secured MDE database, Crystal gives me the error and shuts down. P.S. I'm a big fan of Visual Cut! Great program

I just tried a differnt MDE file and it linked up with Crystal OK. It's strange...the MDE file I want to link up with is a secured database. If I don't enter in the username/password when linking Crystal up to it, I can view all the table names. When I go back and do enter in the username and...

I am trying connecting via Access/Excel (DAO). The error that comes up is'CRW32.exe encountered a problem and needs to close". I just don't know if closing because of a problem with MDE file or if because there is a bug in Crystal 11. Any ideas?

Hello, I am using Crystal XI and trying to link to an Access MDE database. I get a fatal error and Crystal shuts down when I try to establish a connection. I've used CRystal in the past to link to MBD and SQL databases....never and MDE though. Can I even link up to this type of database? Thanks

Hi, I have a crosstab report (CR 9.0) that shows me the number of times an exmployee logged into their computer each day. What I would like is for the crosstab to only show those employees that did not log onto their computer. Any ideas?

kskid, This works perfectly..Thanks! You post was very easy to follow and understand.

Hello, I am using CR 9.0. I have a main report that contains 2 subreport. Subreport1 shows me the total number of applications a client has given to us in the past 30 days. Subreport2 shows the total number of applications a client has given us in the past 60 days. In a nutshell, what I need to...

I'm a little new to Access and need a little help. I have created a crosstab query that looks like this Jan 2005 Feb 2005 Account #1 $10,000 $15,000 It basically shows an account balance for the past 2 months. What I would like is a formula that calculated the...

Hello, I am trying to create an interactive form. In one portion of it, it asks for the companies physical address and then the companies billing address. What I would like is for the user to be able to click a check box so that if the physical address is the same as the billing address, it...

Gerry, Wow, thanks for all the great info. I'll give it a try.

Hello, I am new to the world of User Forms. Here's what I want to do: 1)A user enters in a clients name/address in a text box 2) Then from a drop down list, they choose if the client's business is a Corporation, LLC, or Partnership 3) They then click a button that says "Generate Letter" There...

Cool...works perfectly. Thanks!

Hello, I need help with a Crystal Report date/time formula. All my records I have are in Eastern date/time format and I need to convert them to Pacific Date/time. Note: A formula that goes sometime like "hours - 3" will not work. Example: Eastern time is : 1/20/04 2:00AM should be converted to a...

OK...I've dug a little deeper. It seems that when Crystal imports the field lenght, it is a max of 19 character. In the SQL database, it must be longer than this. What can I do to tell Crystal that the # of max characters needs to be like 21 or so? Thanks

Here's the problem: Ex: Time Received = 12/22/2004 10:12:30 Time Completed: 12/22/2004 2:12:30 I have a formula the calculates the difference between the fields. In this case it assume that both fields are in AM format (since they are not 24 hour, nor do they have the AM/PM in them) In...

Hello, I am using CR10 linking up to a SQL database. When I import 2 fields (time received, time completed), they import as strings. In the SQL database, they are stored as date/time fields. How come they are not being impored as date/time fields in Crystal? P.S. Yes, I know that I can use the...

I have a report that shows Customer Complaints. The main report shows the date the complaint was submited and the status of the complaint(In Process, Complete, etc...) The subreport shows all the actions that were taken regarding the complaint, along with the date of the action. I would like to...