Dynamic DDLB in a footer

[mealbert]

I want to create a dynamic DDLB displaying information from a series of columns (about 4). Is there anyway to do this. I have tried playing around with "create column(band="" name="" ddlb.Case=""...etc.)" but it keeps giving me syntax errors when it runs. Is there something I am missing in the syntax or should I be trying something completly different?

Just in case anyone is curious I want to make this dynamic because I am pulling records based on a certain record ID and obviously as the record ID changes the list of records returned changes.

Thanks in advance. Any help would be great.

Mark

 

[mealbert3]

Ok. I have most of this figured out but I am having a problem with dbname property syntax. Does anyone know correct syntax for this property and if sql views can be used with it???

Thanks,

Mark