Recent content by strtech

You should be able to right click the label, select "format axis label" and change the font style and size there.

I obtained the certification last year. However, I took the upgrade exam because I was already certified in version XI. The test was tough and you really need to study all of the objectives on the preparation list because it is very thorough.

You are going to need to modify that through Crystal Reports.

If you don't have an invoice that refers to the Prepayment and credit memo, you are going to have to create a debit memo and then apply the credit memo and prepayment to the debit memo to zero them out.

I have a SSIS package that is importing thousands of records into a Microsoft Access database. I would like to include backing up the database or at least getting a copy of the affected tables before the import tasks execute. Is there a way to accomplish this since the Backup Database Task...

Try something like this: SUBSTRING( (DT_WSTR,30) GETDATE() , 9, 2) + MONTH(BirthDate) == 1 ? "January" : Month(BirthDate) == 2 ? "February" : "Unknown" + SUBSTRING( (DT_WSTR,30)GETDATE() , 1, 4 ) Just continue the list for March, April, etc.

I don't work with FTP tasks a lot but have you tried changing the "Stop on Failure" option in the FTP Task Editor to "False". I have another package running where I used a Script Task first to check to see if the file existed in the directory and from there I designed what tasks would execute...

I have created a package that imports an Excel spreadsheet into a SQL table but it has to perform a fuzzy lookup first before importing. That works fine. The problem is, I have approximately 2000 spreadsheets to import. They are all in the same directory. What I would like to do is to have...

Hi, Just in case you didn't find the answer, you can use the Month() function in a formula that will convert "Jan" to "01". Then use that formula in the chart.

smibarb, I think your problem is in the WHERE clause, which is in your Select Expert in Crystal Reports. You have the right LEFT OUTER JOIN if you are trying to get all of the instruments from the bu_t table. However, you then start to limit the records by stating the records have to have a...

I am trying to subtract two date fields that I thought would be very easy. I'm creating a form in Adobe Acrobat. However, I am either coming up with a blank field or the "NaN" message and I don't know why. Both of my fields are formatted as a date field. My calculation field is formatted as a...

I want to make sure we are on the same page. You are inserting a text field from the Controls group on the Developer tab, correct? If you are, then you can double click on the field that you added or right click and choose properties. It will open up the Field Options dialog box. From that...

Sorry, I forgot to add this statement Change your field type to "Calculation" and enter the formula that I mentioned above in the "Expression" field.

This formula works: = (Bookmark1 + Bookmark2 + Bookmark3 + Bookmark4 + Bookmark5 + Bookmark6 + Bookmark7)/7

The only way to close them out without purging obsolete purchase orders is: You have to go into each purchase order and get rid of any backorders. For example, qty ordered is 100 but you received 75. You will need to change your qty ordered to 75 and make sure your backordered number is 0...