Friday, March 9, 2012
ReportItems!
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>
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>
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?