As long as you are set on learning VBA, my advice is to learn to make some things much more dynamic.

In just that snippet, I see you set an arbitrary...

I got my start with Excel and VBA.

At the end of the day, I see it easier to actually meet the core requirements with SSRS by pretty much just...

Capt. Sigerson (5/16/2012)

---

Lynn Pettis (5/16/2012)

---

The problem I have seen is the lack of the Business Analyst and Database Analyst/Architect working on the project in this fashion, at least on the...

L' Eomot Inversé (5/15/2012)

---

Stefan Krzywicki (5/15/2012)

---

L' Eomot Inversé (5/15/2012)

---

I guess you would find working with EU data protection law would give you fits! 😛

There is an absolute necessity to be...

Kind of off topic, but you might want to test this a bit.

We ran into memory issues using PowerPivot and a more traditional Star Schema.

It was not releasing memory as...

Being driven soley by Date usually means you don't have enough time to think about good solutions. 🙂

Short cuts and rework then can give an illusion of activity as the...

Joy Smith San (5/11/2012)

---

There are many dimensions in one of the data source.

...

Joy Smith San (5/10/2012)

---

We want data only, in CSV format. We don't want cube.

We hide...

Lynn Pettis (5/12/2012)

---

polkadot (5/12/2012)

---

So, it's SSRS + weekend (and believe me it's a really uncharacteristically beautifully sunny one).

Still the key question is....can parameters be passed to SSRS (from...

Lynn Pettis (5/10/2012)

---

polkadot (5/10/2012)

---

I have edited the attachment and reuploaded.

Thank you for helping me through this. I was never clear on the free text area, tho in...

polkadot (5/10/2012)

---

If you insist on not using something like this, I would eliminate Word and just use Excel.

But then what triggers it to run? Maybe a form on Auto_Open to...

Lynn Pettis (5/10/2012)

---

Anyone with good to excellent knowledge of Reporting Services, your input here would be much appreciated. I think it would be a better choice than what the...

I tend to agree with Lynn.

It sounds like you would want 2 drop downs in a report from which they can choose values.

And on selcting the first on, the second...

Brandie Tarvin (5/10/2012)

---

Apparently, I just made one of the help desk guys very happy. He passed on a user problem with an Access db that has become unwieldy asking for...

+1

Hopefully very good.