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...
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...
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...
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...
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"...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.