baselkanaan
New Member
I have dynamic List boxes in my asp page. and I need to select the items from each list boxes for the below ex. selected item\[code\][Date].[Calendar Date].[Calendar Year].&[2002]\[/code\] from one list box\[code\][Date].[Calendar Date].[Calendar Semester].&[2002]&[2]\[/code\] from another list box\[code\][Date].[Calendar Date].[Calendar Quarter].&[2001]&[4]\[/code\] from another etc....I need to bring those above selected items as below\[code\]FROM ( SELECT { [Date].[Calendar Date].[Calendar Year].&[2002]} ON COLUMNS FROM ( SELECT { [Date].[Calendar Date].[Calendar Semester].&[2002]&[2]} ON COLUMNS FROM ( SELECT { [Date].[Calendar Date].[Calendar Quarter].&[2001]&[4]} ON COLUMNS\[/code\]Remember: these values comes from dynamic listboxesI appreciate your help.