Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Chasidy

    Publishing web services problem

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

    Unable to open rowset : Unknown error

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

    unable to establish a database connection

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

    unable to establish a database connection

    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).
  5. Chasidy

    unable to establish a database connection

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

    Parse a string

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

    Parse a string

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

    Parse a 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...
  9. Chasidy

    Incorrect data being reported

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

    Casting with Access (Jet)

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

    Casting with Access (Jet)

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

    Casting with Access (Jet)

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

    Casting with Access (Jet)

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

    Suppressing duplicate detail lines

    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} =...
  15. Chasidy

    Suppressing duplicate detail lines

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

    one to many linking

    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?
  17. Chasidy

    Left Outer Joins vs SubReports vs Views

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

    Duplicate records with left outer join

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

    Duplicate records with left outer join

    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.]
  20. Chasidy

    Duplicate records with left outer join

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

Part and Inventory Search

Back
Top