Search results for query: *

We were using project 2003 and I was upgraded to 2010. When I open a a schedule that used to have data that was summed in a number column, the data is no longer there. If I try to enter in data to see if it would still sum I get the following message: There is no code mask defined for Number8...

I have a crystal report that has an email address column which is set to can grow. Sometimes only one letter will go over to the next page. Is there any formula I can use to have it break at the preceding punctuation. For instance firstname.lastname@company.com - If it breaks on the last m...

We have replication setup on SQL Server 2000 on a Windows 2003 machine. I need to set something up so that if there is an error, someone gets notified (preferably two people). I go into SQL Server everyday and check the replication monitor, but of course my day off was when we had errors. I...

I have a DTS package that has integer values which I want to convert to chars because they are dropping the leading zeros in the export. I have search for information on this and I tried adding a convert or cast into the select statement but no matter what I do the leading zeros are still gone...

I have a DTS package that has 3 fields for the phone number. In SQL they are smallints and when they come over in the .csv file the leading zeros are dropped. I have tried to change them to chars when I do the DTS export, but the zeros are still missing. Is there any way to keep the zeros in...

I am using CR XI with an oracle 10g database. After our helpdesk did some work on my system, I was getting errors with Crystal Reports. When we looked at the Database Expert, we noticed that Oracle Server was not there, so I download oracle client. Once I did that, I could see the Oracle...

I am using Crystal Report XI with a Oracle database. I have a report that currently has a startdate, enddate and a type parameter. The Type can be an addition, deletion or modification. Currently when the report is run, it shows modifications that have a future startdate. I need to add a...

I need some help with a select statement. Have been playing with this all afternoon and cannot get it to work. It seems like it should be relatively straightforward, but I usually only do basic SQL statement stuff, so not sure best way to approach this. I have two tables, Table A has all the...

Ok, I am not much of a programmer, but have a vbscript page which I believe is also using html. I need the first line in one particular area to be bold. I have searched and tried various tags, but nothing seems to work. Below is the excerpts from the code. The 1st two lines are at the top of...

I have the following SELECT statement that I am using in SQL Server 2000 that selects additions during a certain timeframe SELECT * FROM Facilities WHERE (approve_datetime BETWEEN '2009-08-01' AND '2009-08-07') AND (action = 'A') I would like to create a stored procedure on the...

I have a report that prints out a Group Header and then any of the following detail sections a, b, c, d and e. Sometimes all the detail sections print out and other time just one or a few of them. I would like to shade the Group Header and any of the detail sections that follow it and then...

I have simple CR XI report that has 7 columns. If the first 3 columns have the same data, I would like to suppress the data on the subsequent rows and only show the last 4 columns. Originally we had the data in the group headers, which worked fine in the report; however, if we export the...

I have header text that varies in size (1 to 4 lines) and right now the text box is sized according to the number of text lines in it and then the bottoms are aligned. However, when I try to export the text to excel, the headers do not match up with the text. The header that is 4 lines long is...

We have quite a few reports that we already adding some sorting to; however, the users are asking for additional sorting, but since I am not sure what they would want I was wondering if it would be possible to add a parameter from which they could add multiple options. For instance, one user...

We occasionally have to install SQL Scripts to alter tables, etc. and when we do, the scripts will not run because we have some of the tables replicated. Is there an easy way to pause replication so that we can run the scripts and then just restart it without having to redo the replication.

I am using CR11 and my dates are coming out wrong. 1987 displays as 2087. After some research, I tried to use the TO_DATE(DATE, 'DD-MON-RR') format, but I then get the error: 'ORA-01861: literal does not match format string' In the Oracle database the dates are shown as DD-MON-YY (Ex...

I have a field that is 5 characters. Most of the data is either 3 or 4 characters. How can I select all the fields that are of 5 character length. I have tried using LIKE with 5 _ ('_____'), but that brings back everything. Not sure how to return just fields with 5 characters. Thanks

I am using Crystal Reports 11 and when no recrods are returned, the report footer prints out that there are no errors. However, I have a group header that have two fields that are separated by a text object (dash). This dash is still printing on the report. The suppress blank section is...

I have a CR11 report that is using an oracle stored procedure. In the where clause it has the following: (L.STATUS = pSTATUS OR pSTATUS IN ('L','M','R') OR pSTATUS IS NULL) When I run the report from crystal, if I put in a parameter value for STATUS with one of the 3 values, the report still...

I am using CR11 and have an oracle stored procedure. One of the parameters in the report is for a field that can be one of 3 values 'Y' 'N' or 'M'. Currently the line in the procedure allows me to select only one value or no value: (L.STATUS = pSTATUS OR pSTATUS IS NULL) I need to be able to...