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!

  • Congratulations gkittelson 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. DonSaluga

    Parameter -Default table value for a parameter

    Thanks for your help. I didn't see any way around it. Did they correct this in version 9? Don
  2. DonSaluga

    Transactional Replication with Transaction Log Backups, any conflict?

    Hi, I have similar setup -- transactional push replication with transaction log/full backups and have been using it for 4 months without a major problem. From my understanding, the designated transactions in the publisher db are marked for replication and will not be removed from the log until...
  3. DonSaluga

    Parameter -Default table value for a parameter

    Hi, I'm using Crystal 8.5/SQL 2000 and have a report that uses a parameter called system type. I want the user to be able to dynamically see all values in the system_type table and be able to select any one, but it seems like Crystal will only let me "Load" default values in the Set...
  4. DonSaluga

    Problem with Crystal 9

    Hi, I installed Crystal 9.0 Professionl on a user's pc. She used to have Crystal 8.5 Developer edition and had no problems developing reports. The user went to the report expert in 9.0 to design a new report and selected 3 tables. When she clicked next, she received a fatal error message, and...
  5. DonSaluga

    Finding the most current date among many

    Thanks Naith. Your solution worked! Don
  6. DonSaluga

    Finding the most current date among many

    I have two tables, job and job_history_status that I can join on job_no in a one to many relationship. The job_history_status table may contain several rows of job status change dates for one job, but I only need to retrieve the most current job status change date. I've tried numerous ways to...
  7. DonSaluga

    Error connecting to database

    Hi, Thanks for your info. Yes, I checked the Data Explorer to make sure that tables etc. were checked. I even created a new OLEDB data source. It allowed me to create it and it tested successfully. However, when I go to open it, I still keep getting the message "No Items found&quot...
  8. DonSaluga

    Error connecting to database

    Hi, I installed Crystal Report 8.5 for a user on a Window's 95 machine (long story). The user was able to access the SQL 2000 database and create reports without a problem for about a week. Then yesterday, when she went to the database linking expert to add a table to an existing report, she...
  9. DonSaluga

    Error Concatenating fields

    Hi, I'm trying to concatenate 4 database fields (Data1 Data2...) into one formula field for a report. Each field is varchar 255. Data1 cannot be null, but the others can. I wrote this formula and it works until it hits a large record and I get the following error: A string can be at most 254...

Part and Inventory Search

Back
Top