Recent content by Chasidy

Better late than never?? I also had this problem in v 5.0. I found I was missing a configuration setting. Go to Window | Preferences | Internet then click on "enable proxy server". Rerun your service and hopefully will work fine.

I know how I have created that error in the past. In the Table Linking, if you have a chain of tables linked together, if you use one LEFT OUTER JOIN between two tables, the remaining tables on that "chain" also have to be LEFT OUTER JOINS regardless if you think it should be or not...

I found out that the query I am attached to says the database type is OLE DB (ADO) when it should be ODBC (RDO). I deleted the existing query and created a new one, pointing to an ODBC database, and now it works fine. Not exactly sure how you can create an ADO query when your report is...

We have another program which uses the crystal runtime files and runs the crystal reports. when you log into the other program, you need to choose a database. This connection then gets passed to crystal when reports are run from this program. (I think this is what you are asking).

I have created a report in Crystal 9 Developer's Edition. The report is based of an internal ODBC (RDO) query which was initially set to use "SAMPLE" SQL Anywhere database. Everything seems fine. Tried to run the report through a different application using Crystal runtime files...

I am not guaranteed of order because if a new station is added, it will be put in alphabetical order. This also means I won't have a fixed number of input. I think doing the import to a database (or excel) is probably the best bet. I don't like to have to do it that way, but if it works...

Sorry, I should have clarified: Each record, ie (Ted, Mary, Steve) each has it's own string dependent on which stations they watch. So each record has it's own comma delimited string.

I have a string that I need to parse out, then I need to use each unique parsed piece as a group. For example: I want to track which people in my survey watch what stations. "NBC, ABC, CBS", (Ted watches all three stations) "ABC", (Mary watches ABC) "ABC...

The first thing I always check when my report comes up blank is the record selection. First I put the fields that I am using in the record selection in the details section of the report (temporarily) and then remove everything in the record selection. I run the report and make sure something...

If you say null for pledgedate, nothing shows up at all. When you say 0, then if it's "null" a 0 shows and when it's valid, the date shows. Makes no sense. That's why I wanted to cast. Thanks for your help with this issue.

Sorry about that. Here is a simplified version of the query with my problem spot which is the "Pledge" lines of the first query. SELECT Folder.FolderID, GiftTransaction.AppealCode, GiftTransaction.DateRecvd, GiftTransaction.GiftID, 0 as PledgeDate, 0 as PledgeID, 0 as TotalAmount...

The main reason I was using the union query was to remove the duplicates. We switched from DAO to ADO and all the "easy" links you could use in DAO are not supported in ADO...so the headache begins. Instead of casting, I just used a 0 as data which moderately works except for the...

Does anyone know a work around for casting in a union query in Access. I am trying to do a report using ADO and I would like to use a query. When I create my union query, I want fields seperated SELECT Name Gift Date Gift Amount Null Null From Folder, gift (blah, blah) UNION SELECT...

Ok - I'm newer at this newsgroup stuff - let me have another try. Go to format section under the formula editor for suppress. if the duplicated information is technically a "distinct" id, you can use the formula not (previousisnull({gift.giftid})) or {gift.giftID} =...

You can format the fields individually on the report but going into format and saying "Supress if duplicated". You can also do more complex formula if you use the formula button to the side of suppress.