I checked the box for traverse sub folders. When debugging, it told me it didn't find any files. That means it didn't traverse the subfolders, because I know...

Thanks Wayne,

I followed your suggestion and was able to clean the table up.

I've heard that CTEs are things to avoid. However, in this instance it worked fine.

All cleaned up...

Jeremy,

Thank you. That worked. At first, I was still getting an error message. Then I remembered since it was a new server, the firewall may have been...

Thank you.

I was able to use SSIS to bring the catalog table from both servers together, create a left outer join and see the difference.

Thanks again!

Tony

Old Hand,

Hello. I just wanted to round out this thread.

I've created a couple of reports now. It appears that deleting the left most column takes away the cross...

Thanks, that worked.

The field was wrapped into three rows depending on how long the name of the facility was. I merged the cell next to it and now it...

Thanks for trying to help.

No. I get the same thing.

One big row on the left for the facility and then the employees on the right.

-----------------------------

-facility___-employee ...

This is what I'm getting:

North Facility Employeea

____________Employeeb

____________Employeec

...

Excellent!!!!

I had the same issue and just found this thread. I changed the name in the trigger to reference the new server and I am back in business.

Thanks Mark,

I don't understand the CTE's that you guys are using. I assume you are using Common table expressions. I just looked up something on Microsoft's forum.

Tony

Whoa!

I am so blown away. Thank you.

It is going to take me a bit to go through this. I would say pretty advanced coding here.

Some of the code...

Thanks.

I didn't think to give sample data. But I appreciate any help at all.

I can do this in VBA by start from the top and going row by row....

Of course, as most of my challenges, it is the discretion of the boss.

I plan to present him a listbox showing all employees. Then let him select the employees...

Oh Okay,

The website that I using as a guide said to delete all of them. I have deleted one.

Tony

Gail,

Thanks for showing me that. That was a big help!

Tony