Ahh, that makes sense..when you first entered the SQL...SSRS was trying to be "smart" and automatically created the parameters for you.

Good deal!

hmm, i think there is a netweaver ds for SSRS, not sure about business one...i know nothing about SAP.

you could try an expression, though offhand I'm not sure that will...

@ is reserved in ssrs as well as SQL server. What's the datasource?

can you alias the table in your select/view/whatever?

Like "select cola from @table table1"?

Or are you trying to access...

Use an expression like ="My cool report " & now().tostring

you can also use a dataset value

You need to determine where the bottlenecks are before you can optimize. Data retrival, rendering? Do you need r/t access or can you cache/snapshot? What type of hardware, scale-out methodology?

Your...

SSIS is the way to go. If you need more functionality like sftp, look into CozyRoc.

For others with the same questions, here are some points of note:

> only 1 dataset is returned to ssrs

> cannot really set the order of operations unless there is...

Paul White NZ (4/2/2010)

---

David-Leibowitz (4/2/2010)

---

Optimal is relative to what you're trying to accomplish. And there are always 20 ways to skin a cat.

I find it's always a balance between user...

Optimal is relative to what you're trying to accomplish. And there are always 20 ways to skin a cat.

I find it's always a balance between user needs and dev support...

1. Remove the 'all' part from your stored proc. Ssrs does not pass a value of ALL on a multiselect. It will send a single dimension array of ALl possible...

Easiest way? There are several and these work in 2000, 2005, 2008. This has not been tested in 2008 r2.

Method 1:

Involves taking hammer to harddrive

Method 2:

harddrive + lighter fluid +...

Have you looked at SQLScrubs for SSRS 2008? It provides the ETL, DW and reports to do a lot of this. And it's free on codeplex.

Gets around the 60 day...

Several points to note:

1. 2005 is different than 2008 in schema and the type of metrics available. 2008 has more information.

2. If your solution does not use a datawarehouse and...

SQLScrubs Community Edition is a free resource for management, audit and optimization of SSRS 2008. It includes a datawarehouse, SSIS log scrubbers, and a basic kit of report to get...

This post seemed topical:

http://blogs.msdn.com/psssql/archive/2009/12/03/report-builder-and-firewalls.aspx