Showing posts with label collection. Show all posts
Showing posts with label collection. Show all posts

Friday, March 9, 2012

ReportItems!

Is there any documentation on the reportitems! collection?
Something with some examples?
I am trying to total group totals in a table/group footer and it is
saying it needs to be in the right datasource.
Thanks, Leohttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
<cte25117@.centurytel.net> schrieb im Newsbeitrag
news:uPGdnfM9NOkyt_DfRVn-rQ@.centurytel.net...
> Is there any documentation on the reportitems! collection?
> Something with some examples?
> I am trying to total group totals in a table/group footer and it is saying
> it needs to be in the right datasource.
> Thanks, Leo|||Jens Süßmeyer wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> <cte25117@.centurytel.net> schrieb im Newsbeitrag
> news:uPGdnfM9NOkyt_DfRVn-rQ@.centurytel.net...
>>Is there any documentation on the reportitems! collection?
>>Jens,
Thank you for your response. I have read this but this documentation is
not very good. I need some examples.
I am trying to total values that are totaled in a group header.
This is what I use in the header to get the total:
=Sum(CDEC(IIF( IIF( Fields!QuotedPrice.Value > 0.00,
Fields!QuotedPrice.Value, Fields!DesignPrice.Value) > 0.00,IIF(
Fields!QuotedPrice.Value > 0.00, Fields!QuotedPrice.Value,
Fields!DesignPrice.Value)
,0.00)))
But If I use the in the table footer I get double or even triple values.
I need to sum the values in the text box.
Thanks, Leo
>>Something with some examples?
>>I am trying to total group totals in a table/group footer and it is saying
>>it needs to be in the right datasource.
>>Thanks, Leo
>
>|||Jens Süßmeyer wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> <cte25117@.centurytel.net> schrieb im Newsbeitrag
> news:uPGdnfM9NOkyt_DfRVn-rQ@.centurytel.net...
>>Is there any documentation on the reportitems! collection?
>>Jens,
Thank you for your response. I have read this but this documentation is
not very good. I need some examples.
I am trying to total values that are totaled in a group header.
This is what I use in the header to get the total:
=Sum(CDEC(IIF( IIF( Fields!QuotedPrice.Value > 0.00,
Fields!QuotedPrice.Value, Fields!DesignPrice.Value) > 0.00,IIF(
Fields!QuotedPrice.Value > 0.00, Fields!QuotedPrice.Value,
Fields!DesignPrice.Value)
,0.00)))
But If I use the in the table footer I get double or even triple values.
I need to sum the values in the text box.
Thanks, Leo
>>Something with some examples?
>>I am trying to total group totals in a table/group footer and it is saying
>>it needs to be in the right datasource.
>>Thanks, Leo
>
>|||Jens Süßmeyer wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> <cte25117@.centurytel.net> schrieb im Newsbeitrag
> news:uPGdnfM9NOkyt_DfRVn-rQ@.centurytel.net...
>>Is there any documentation on the reportitems! collection?
>>Jens,
Thank you for your response. I have read this but this documentation is
not very good. I need some examples.
I am trying to total values that are totaled in a group header.
This is what I use in the header to get the total:
=Sum(CDEC(IIF( IIF( Fields!QuotedPrice.Value > 0.00,
Fields!QuotedPrice.Value, Fields!DesignPrice.Value) > 0.00,IIF(
Fields!QuotedPrice.Value > 0.00, Fields!QuotedPrice.Value,
Fields!DesignPrice.Value)
,0.00)))
But If I use the in the table footer I get double or even triple values.
I need to sum the values in the text box.
Thanks, Leo
>>Something with some examples?
>>I am trying to total group totals in a table/group footer and it is saying
>>it needs to be in the right datasource.
>>Thanks, Leo
>
>|||Jens Süßmeyer wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> <cte25117@.centurytel.net> schrieb im Newsbeitrag
> news:uPGdnfM9NOkyt_DfRVn-rQ@.centurytel.net...
>>Is there any documentation on the reportitems! collection?
>>Jens,
Thank you for your response. I have read this but this documentation is
not very good. I need some examples.
I am trying to total values that are totaled in a group header.
This is what I use in the header to get the total:
=Sum(CDEC(IIF( IIF( Fields!QuotedPrice.Value > 0.00,
Fields!QuotedPrice.Value, Fields!DesignPrice.Value) > 0.00,IIF(
Fields!QuotedPrice.Value > 0.00, Fields!QuotedPrice.Value,
Fields!DesignPrice.Value)
,0.00)))
But If I use the in the table footer I get double or even triple values.
I need to sum the values in the text box.
Thanks, Leo
>>Something with some examples?
>>I am trying to total group totals in a table/group footer and it is saying
>>it needs to be in the right datasource.
>>Thanks, Leo
>
>

reportitems collection in a custom function

Helo, I tried to use de global coleciton reportitems in a custom function, but it raise the following error: 'reportitems' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IReportObjectModelProxyForCustomCode'

I can use the parameters collection without any problem in the same function. I saw in documentation that parameters, fields and reportitems can't be used in inatialization (onInit()), but I think that this is not the same situation since parameters works fine.

Any idea ?

Tanks

J.Aldrin

ReportItems are not accessible in Custom Code.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

That's right, by default, custom code directly sees only a subset of collections available in report expressions.

If you call a function Foo defined in custom code from a report expression (like textbox value), you can pass ReportItems collection as an argument:

Function Foo(reportItems as ReportItems)
Return reportItems!textbox1.Value
End Function

<Textbox Name="textbox2">
...
<Value>=Code.Foo(ReportItems)</Value>
...
</Textbox>

|||But, just for information, ReportITems are ReadOnly.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

reportitems collection in a custom function

Helo, I tried to use de global coleciton reportitems in a custom function, but it raise the following error: 'reportitems' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IReportObjectModelProxyForCustomCode'

I can use the parameters collection without any problem in the same function. I saw in documentation that parameters, fields and reportitems can't be used in inatialization (onInit()), but I think that this is not the same situation since parameters works fine.

Any idea ?

Tanks

J.Aldrin

ReportItems are not accessible in Custom Code.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

That's right, by default, custom code directly sees only a subset of collections available in report expressions.

If you call a function Foo defined in custom code from a report expression (like textbox value), you can pass ReportItems collection as an argument:

Function Foo(reportItems as ReportItems)
Return reportItems!textbox1.Value
End Function

<Textbox Name="textbox2">
...
<Value>=Code.Foo(ReportItems)</Value>
...
</Textbox>

|||But, just for information, ReportITems are ReadOnly.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

ReportItems collection

I can add two reportitem controls, ie reportitems!begbal.value + reportitems!deposits.value, without a problem. However, when I add the 3rd reportitem control to the expression, ie + reportitems!withdrawals.value, some really funky arithmetic occurs. All of these controls I am referring to are in the same group footer.

Any help out there would be greatly appreciated.

Are all three the same datatype? What do you mean funky arithmetic?