Add additional columns to Listbox

CodeCharge Studio

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

Add additional columns to Listbox

Author

Message

swilson

Posts: 84

Posted: 01/08/2006, 9:07 AM

This is how I added additional columns to display in the Listbox or Checkbox List controls:

After Execute Select add Custom Code:

For j=0 To ListBoxSource.Count-1   
    ListBoxSource(j)("Column1")=ListBoxSource(j)("Column1")+" "+ListBoxSource(j)("Column2")  
Next

...where Column1 is the original Text Column and Column2 is the 2nd field you wish to add.
_________________
It continues to amaze me, how often the solutions to seemingly complex problems are so very simple.

dragoon

Posts: 173

Posted: 01/08/2006, 9:15 PM

what the advantage of your sollution over preparing the right SQL statement?

swilson

Posts: 84

Posted: 01/09/2006, 5:49 AM

In my case, the listbox is limited by assigning an expression variable from the form. For example, in the BeforeBuildSelect of the listbox:

Expr72.value = Item.model.value  
Expr74.Value = Mid(item.SERIAL_NUMBER.Value,5)  
Expr75.Value = Mid(item.SERIAL_NUMBER.Value,5)

Then, in the Table/View mode, Where:

Model = '{Expr0}' AND  
SubString(BegSN,5,10) <= '{Expr1}' And  
SubString(BegSN,5,10) >= '{Expr2}

I don't know how to build an SQL statement that would allow me to tie into a variable from the form. The above solution works well, and other questions in the forum were unanswered. I hope it helps.

_________________
It continues to amaze me, how often the solutions to seemingly complex problems are so very simple.

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login