Wow!!!

I am very impressed and very thankful for your help!!

Thanks.

I had to spend some time working through your example:

1) I had to create the tally table.

2) I don't...

Ok, I figured out the textbox expression:

=str(CountDistinct(Fields!Emp_Name.Value,"table1_facility_name"))+ " employees in this facility."

OK...now I wish I could do the drilldown from scratch. For now, I will just use the wizard.

Thanks.

Tony

This is taking way longer than if I had used Crystal Reports.

I cheated and used the wizard.

Now I have two collapseable groups.

+Facility_name

+SupervisorA

+SupervisorB

Now I want...

Thanks everyone.

So I know that I have to create a project and start working on scripts.

I thought there were custom reports that that you can install and show database growth....

Jeff / Gail,

Thanks for the lesson. I wanted to get your impression of what I could do better. I will look into the bulk logged recovery. To...

Jeffrey Williams-493691 (5/6/2011)

---

WebTechie38 (5/6/2011)

---

Sorry about that...I left out a step.

1) Does a differential backup

2) Sets the recovery model to simple

3) Checks integrity

4) Reindexes

5) Checks integrity again

6) Sets the recovery model...

Sorry about that...I left out a step.

1) Does a differential backup

2) Sets the recovery model to simple

3) Checks integrity

4) Reindexes

5) Checks integrity again

6) Sets the recovery model to full

7) Does...

Hey man,

Thanks for responding.

What link?

I guess I am not understanding that part. I've created the parameter m90. Now what link are you referring to?

Do I need to put...

I never knew about an interactive page width until the client started complaining about seeing one page count in the tool bar and another when they printed out the pages.

To...

Hello,

Yes, I went back and forth to make sure the columns were more narrow. I saw blank pages and took care of that.

But even after all that the display...

I see from searching the internet that I am not the only one to notice this particular behaviour of SSRS.

Though I am getting more and more proficient at creating reports...

Actually, if I just print preview, the total pages says 63.

When viewing the report in Report Manager, the tool bar says 41.

If I print to pdf or just print preview,...

Graham,

No, I was processing the files one at a time. I'm not sure who to check the queue.

Yes, antivirus scanning is running on the server.

Tony

Ok, I just wanted to wrap up this post.

So I went around and around trying to move files with the FileSystem task or the Script Task. It worked fine...

Graham,

I am using a sequence container, with precedents.

I do a foreach loop and then the filesystem task. So I believe this is the only operation going on...