Search results for query: *

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.

Could it be because you are linking to the budjet table twice (once on deptcode and once on categorycode)? Maybe using an alias table would be a better alternative?

I have found that with outer joins, if you have multiple tables linked together, as soon as you say left outer join between two tables then the rest of the tables in that "chain" HAVE to be left outer joins (regardless of whether that makes logical sense to do so or not). ex. TableA...

I am working on using the subreports right now. I did Gift in the main report and the Pledge in the subreport. I am relying heavily on the subFormula / mainFormula that is listed on this message board. It is a slow process but I think it might be working. Right now I am trying to determine...

Is there any way to use queries (specifically UNION queries) with ADO? I use UNION queries with our ODBC side and the problem is eliminated (though not efficient). I tried using the Query Designer but my only data source options are ODBC.]

No, you cannot link gift to pledge. The joins need to be two left outer joins one from folder to gift and one from folder to pledge. This report I am working around has been around since the beginning of time and has "All" the information our customers want...but with the change-over...