Friday, November 16, 2007

Excel to Word mailmerge problem

Today there was this small thing that took my time. A date field in excel was formatted correctly but when the field was used in the mailmerge with Word. The format in the excel was not being reflected in word.

So I used the following steps to correct this in Word.

Step 1. Right click on the field name
Step 2. Click on the ‘Toggle Field Codes’ option For eg., { MERGEFIELD “AFinish” }
Step 3. Edit the field to include \@ “dd-MM-yyyy” e.g. { MERGEFIELD “AFinish” \@ “dd-MM-yyyy” }
Step 4. Right click and click update field.

You can see the date format as 17-08-2008

Thursday, November 01, 2007

Viewing DTS scheduled jobs

I wanted to view the scheduled DTS jobs. So obvious way I thought was to do view it where I created. But for some reason, the schedule has been reset. So there is no way we can view the scheduled jobs of DTS here.

If you want to view these jobs, you have to access the SQL SERver Agent as these jobs are run by SQL SERVER Agent. So follow these steps to ciew your scheduled jobs on SQL server.

Go to SQL SERVER Enterprise Manager -- Management folder
Then click on SQL SERVER AGENT -- Jobs

Here you can see the job name status etc.

Rerunning a SSRS subscription report

Yesterday I had a situation where  a couple of SSRS reports failed due to a network upgrade. The SSRS report was not able to access the SQ...