I have studied the example on Microsoft's BOL. http://msdn.microsoft.com/en-us/library/hh243933.aspx titled Creating PivotTable Reports and Charts with VBA in Excel 2010

I am using Excel 2010

---here's updated ddl, basically just added column...

Hope the fish are biting! Thanks Greg.

in case anyone can give me more input here I'm posting DDL. I can't upload macro enabled excel as it is restricted so I will show only screenshot.

DDL for the...

Greg Edwards-268690 (5/17/2012)

---

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...

Sober Counsel,

Yes, this forum is EX-CEL-LENT (par excellence) for all things SQL and I bow low for all the help that I get here. From the Lynns and dwains...

Wow Wow Wow. Standby.

:kiss::kiss::kiss::kiss::kiss::kiss::kiss::kiss::kiss::kiss:

I presented status update to manager.

Since currently reporting is via PowerPivot on Sharepoint it is just as easy to supply link to that as to SSRS. Filter boxes permit...

you are correct. Thanks Jeff. It's still totally relevant (ie. not just an exercise). :kiss:

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 Word or Excel)...

Here the summary of my own research on this topic so far:

For EXCEL MACRO BASED SOLUTION I need

(1)Capability of VBA to connect to SQL Server (script)

(2)VBA script to pass parameters...

Time is the issue. I am on this forum to ask someone who is experienced with SSRS if they know the answer. I am not asking for them...

OK, thank you Koen.

Lynn, Koen reiterated exactly what I need. I like the use of the word form. I didn't use it but it is really...

Yes, Koen:smooooth:

Users will open a Word template which will allow for free text summary of project status. It should also contain two fields each of which accepts a parameter which...

Koen Verbeeck (5/10/2012)

---

You can create a report in Reporting Services and let it render the report in Excel or in Word.

For users, they would just click on the link and...

Lynn can you please explain the direction that you are going with this? What are you laying down that I should be picking up? How does that help?...