Veena,

Your observation about SSRS performance degradation in SharePoint Integrated Mode is not uncommon unfortunately. The specific solutions will depend on the versions of SSRS and SharePoint that you are...

This doesn't help you now, but for those that find this post in the future....

MS is FINALLY bringing out 64-bit Excel drivers in Office 2010, which can be used in...

Still no direct support in SSRS for CSS. Because of that, a number of workarounds have been developed to accomplish something similar. The ones I'm familiar with require...

DFolz,

Excellent use! I've done something similar, filtering by database or user or SPID. You can also use this to insert the results of SP_WHO2 into a table (have...

David,

My understanding is that OPENQUERY must return a result set, which is why it can be used wherever a able expression is appropriate, such as a FROM clause. ...

I've not had any problems installing multiple instances of SSRS on the same physical box. As you said, you need separate database names and separate names for the Report...

Marty,

Yes, we have reports such as you're describing. Typically, these are a single table using a single dataset, and at run time, the user selects which fields from the...

In the filter tab under Expression, when you select the same Field item on multiple rows, the "OR" should automatically populate. Otherwise, "AND" automatically populates the and/or column.

A...

Support of cascading style sheets would be a very useful capability in SSRS. The 2005 version does not support CSS and unfortunately, it appears that neither will SSRS 2008....

Assuming the link is in a textbox, set the "Jump to URL" in the Navigation properties tab to something like:

java-script:void(window.open( 'your URL here', '_blank'))

The URL should contain any parameter...

Thanks for the explanation. I think this will work for you:

1) In BIDS, add the RDL for your production report into a new or existing Report Project.

2) ...

In BIDS, you can set the Datasource path for deployment on the project property pages: Right-click on Project Name --> Properties. The TargetDataSource folder specifies the Full Qualified...

I must admit, I'm not sure what this query is doing. Why does it attempt to convert a string to a uniqueidentifier? And the dynamic SQL (EXEC) is...

Can you post the expression that you're using for the group "table_Call".

Ronald,

See if this will work -- try an explicit conversion of the second value to Decimal, something like:

=sum(iif(fields!InSpec.Value ="No",Fields!BBLs.Value,CDec(0)))

Scott