Looping dataset in Dynamic Text

Hello

Is it possible to loop Dataset's columns in Dynamic Text?

Something simple like for (i=0; i < dataset_rows_count; i++) { if column1 = value then print column2 }

I am able to bind the dataset to the Dynamic Text but I only get the last value.

Find more posts tagged with

Comments

mwilliams

Binding a dataSet to a text box or a grid will only get you access to the last value. This is useful when you only want to display a SUM aggregation you did in a computed column or something, but not useful for stepping through a dataSet. Why not use a list or table and add a filter based on your criteria?

If using a list or table doesn't work, you could use the onFetch method to store your dataSet column values into arrays to use in a dynamic textbox like you're talking about.

Hope this helps.

K_L

I was able to make what I was doing with computed column. Well basically I first did a column that does all the math to all the rows. Then had a column which has the conditional resultin 1 or 0. Then used SUM to calc all rows that had 1. Looked like real mess but works.

mwilliams

You might be able to do the same with a COUNT aggregation computed column and then use the filter that filters those rows that don't qualify your calculation.

K_L

Have to check that out if I need to add more data sets. Annying is that I could have done all this with the SQL query but was unable to get datediff work. Then againt thats completely another

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="78118" data-time="1307466091" data-date="07 June 2011 - 10:01 AM">
You might be able to do the same with a COUNT aggregation computed column and then use the filter that filters those rows that don't qualify your calculation. </blockquote>