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

Thanks for the suggestions, but I had changed the data type and it does come over with double quotes but it was still removing the leading zeros. What I ended up doing was pading it with zeros so that it would display the leading zeros or if there was no phone number listed it would display all...

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

Thank you for all your help. I finally got it to work. After search the web I saw a post about an oracle data access download, once I installed that and moved the tnsnames file in that location it work. Thanks again.

thanks for the help. I did check my environment path and oracle 10 is listed first. I have renamed the old tnsnames file so that there is only one, but I continue to received the same errors. Any more suggestions? I have searched this error and have about given up. Time to start from scratch?

Yes, I just looked at those files and they were not in the new oracle client installation, so I added them there. Now I am wondering if I have too many tnsnames files. I still have an oracle\ora81\network\Admin directory with the tnsnames file in it and a new...

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

Thank you so much. I knew this was easy. I will look into joins in more detail. Thanks again.

...able to do this if the row has a comment. Anything else I try will list the rows with status ='A' once for every comment in Table B. Any suggestions on how to do this. Basically I want something like: SELECT * from A,B where A.status = 'A' or A.id = B.id but when I try this I get 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 played with this and if I use DATEDIFF, I can get it to return the data I need, WHERE DATEDIFF(m, wf_approve2_datetime, GETDATE()) = 1 but if I add in the AND action = 'A' , I get no data.

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

The group header has the following: if {#rec-count}=0 then true and each of the 5 detail sections has something like the following: {DETAIL.UNIT}<>"P" OR ( {DETAIL.DC}=Previous ({DETAIL.DC}) AND {DETAIL.TYPE}=Previous ({DETAIL.TYPE}) AND {DETAIL.ID}=Previous ({DETAIL.ID}) AND...

Yes, the Group Header and Detail Sections all have suppression in them. I tried adding the formula/background colors in anyway and nothing changed

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

OK, I removed the group header info that was still in the report and it worked correctly, but is there a way to have the first column print again when the information changes in the 2nd or 3rd column? Instead of A B C D E F G D E F G B C D E F G...