Loop through the dataset

hello All,
This questione pertains to Sql server 2005 reporting services.
Is there a way to browse through each record in the dataset and also make
changes if required before it is rendered on the report?You would have to create a data processing extension which is non-trivial.
Instead, consider basing the value of the cell as an expression. You do not
have to map to a field of the dataset, you can also use expressions (and
expression can call your code too).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Abby" <Abby@.discussions.microsoft.com> wrote in message
news:FAEFF35F-E9C9-4F07-8573-A689C7A12D67@.microsoft.com...
> hello All,
> This questione pertains to Sql server 2005 reporting services.
> Is there a way to browse through each record in the dataset and also make
> changes if required before it is rendered on the report?|||Hi Bruce,
Can you elaborate on the second method u mentioned... In the sense i have
written custom codes and retrived values in the cells using expressions but
how would this work when there is multiple rows of data and i need to do a
comparison between 2 rows of data before deciding what should go in that
field.
Also wouldn't this slow down the process if each cell is calling code to
retrive the value from the db.
"Bruce L-C [MVP]" wrote:
> You would have to create a data processing extension which is non-trivial.
> Instead, consider basing the value of the cell as an expression. You do not
> have to map to a field of the dataset, you can also use expressions (and
> expression can call your code too).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Abby" <Abby@.discussions.microsoft.com> wrote in message
> news:FAEFF35F-E9C9-4F07-8573-A689C7A12D67@.microsoft.com...
> > hello All,
> > This questione pertains to Sql server 2005 reporting services.
> >
> > Is there a way to browse through each record in the dataset and also make
> > changes if required before it is rendered on the report?
>
>|||It won't work for what you want, in expressions you can only look at the
current row of data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Abby" <Abby@.discussions.microsoft.com> wrote in message
news:6FF60E74-4ADF-428A-A8AD-B07E631A3BDD@.microsoft.com...
> Hi Bruce,
> Can you elaborate on the second method u mentioned... In the sense i have
> written custom codes and retrived values in the cells using expressions
> but
> how would this work when there is multiple rows of data and i need to do a
> comparison between 2 rows of data before deciding what should go in that
> field.
> Also wouldn't this slow down the process if each cell is calling code to
> retrive the value from the db.
>
> "Bruce L-C [MVP]" wrote:
>> You would have to create a data processing extension which is
>> non-trivial.
>> Instead, consider basing the value of the cell as an expression. You do
>> not
>> have to map to a field of the dataset, you can also use expressions (and
>> expression can call your code too).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Abby" <Abby@.discussions.microsoft.com> wrote in message
>> news:FAEFF35F-E9C9-4F07-8573-A689C7A12D67@.microsoft.com...
>> > hello All,
>> > This questione pertains to Sql server 2005 reporting services.
>> >
>> > Is there a way to browse through each record in the dataset and also
>> > make
>> > changes if required before it is rendered on the report?
>>