Showing posts with label detail. Show all posts
Showing posts with label detail. Show all posts

Friday, March 9, 2012

Need more info on integrated reporting controls

I am looking for more detail on these "integrated reporting controls" mentioned below (from http://www.microsoft.com/sql/2005/productinfo/top30features.asp#B):

"With SQL Server 2005, Reporting Services will provide report controls that will be shipped with Visual Studio 2005. Integrated reporting controls will provide improved reporting capabilities for enterprise applications".

Specifically, I am looking for more detail on these new ASP.NET 2005 controls that make dynamic server side reports generation via the Reporting Services Web Service easier.

Thanks.The Report Controls are described at http://whidbey.msdn.microsoft.com/library/?url=/library/en-us/rs_vsrpts/html/0334cfba-2cb7-4d8b-8927-e08b888450cd.asp?frame=true. They are not focused on report generation (this is via RDL and the XML library), rather report execution.

Need more info on

I am looking for more detail on these "integrated reporting controls" mentioned below (from http://www.microsoft.com/sql/2005/productinfo/top30features.asp#B):

"With SQL Server 2005, Reporting Services will provide report controls that will be shipped with Visual Studio 2005. Integrated reporting controls will provide improved reporting capabilities for enterprise applications".

Specifically, I am looking for more detail on these new ASP.NET 2005 controls that make dynamic server side reports generation via the Reporting Services Web Service easier.

Thanks.The Report Controls are described at http://whidbey.msdn.microsoft.com/library/?url=/library/en-us/rs_vsrpts/html/0334cfba-2cb7-4d8b-8927-e08b888450cd.asp?frame=true. They are not focused on report generation (this is via RDL and the XML library), rather report execution.

Saturday, February 25, 2012

Need Help! New to reporting services

I need to populate a detail cell in a table report with 0 if the value of a
group cell in the report is > 500000. I've created on iif statement and it
works great when pulling data into the cell from the query. However, I need
to know how to call the value of a specific table cell into the iif statement.
=iif(Value of group cell in table report > 500000, 0,
iif(Fields!AssetCost.Value < 5000, "0",
iif(Fields!AssetCost.value <= 100000, fields!AssetCost.Value*.01, "0")))
SamyraIIf(ReportItems!YourItem.Value>500000,0,False)
Michael
"Samyra" wrote:
> I need to populate a detail cell in a table report with 0 if the value of a
> group cell in the report is > 500000. I've created on iif statement and it
> works great when pulling data into the cell from the query. However, I need
> to know how to call the value of a specific table cell into the iif statement.
> =iif(Value of group cell in table report > 500000, 0,
> iif(Fields!AssetCost.Value < 5000, "0",
> iif(Fields!AssetCost.value <= 100000, fields!AssetCost.Value*.01, "0")))
> Samyra