Saturday, February 25, 2012

Moving Next in your dataset from Custom Code

Can you pass a value into the custom code window, do some logic, and if the
criteria aren't met move to the next dataset record? I don't know how to do
this or aren't sure if you can.DO that with a filter...
Create a public function in the code section that returns an integer which
indicates whether the row should be included or not... Pass whatever
parameterts into the function, and the function returns the approriate
value.
In the filter section for your report add the filter condition
code.myfilterfunctionname(whatever parameters) = 0
When the funtion returns 0 for a row , it will be included otherwise
excluded from the report
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"dillig" <dillig@.discussions.microsoft.com> wrote in message
news:A96EB455-A6C8-4DD5-A984-7E9C9F353CAE@.microsoft.com...
> Can you pass a value into the custom code window, do some logic, and if
the
> criteria aren't met move to the next dataset record? I don't know how to
do
> this or aren't sure if you can.

No comments:

Post a Comment