Dynamic XML or HTML in SWF with columns?

[realdoyle]

I am having a lot of trouble figuring out how to dynamically display 3 columns of text in my swf. They are somewhat long lists of song/album/label titles and all 3 columns need to scroll as one unit. My client gave me Excel files with the lists in spreadsheet form. I've tried exporting as XML and HTML. I've gotten the lists to disply in my SWF using dynamic text boxes but now I can't figure out how to get all 3 text boxes to scroll as one.

Am I going about this the wrong way? I don't need any complex database functions just for these 3 columns to display and scroll, I just want them to work like they would in Excel.

Is there a way to create a simple table in Flash and have each list load into Column1, Column2, and Column3 and then attach a srollbar to the table?

Thank you for your help.

[SandeR2]

You could put the 3 columns in one sprite or movieclip and make that one scroll instead.

[realdoyle]

You could put the 3 columns in one sprite or movieclip and make that one scroll instead.

That is a cool idea. How do you scroll a movie clip? I've added scrollbar components to text boxes but it doesn't seem to be working with MC's.

Thanks again for the ideas.

[realdoyle]

So I found this tutorial here on Kirupa that goes through the process of building a scrollbar for a movie clip: http://www.kirupa.com/developer/flash8/scrollbar.htm

I went through the first 3 pages and was able to replicate the results I need but only when I follow the demo tutorial. When I try and apply the same thing to my movie clip (with the dynamic text boxes) it doesn't work. As matter of fact, when I apply the mask to my contentMain_mc and publish it, it comes up completely empty (except for the scrollbar floating in space by itself).
I've tried removing the dynamic text actionscript out of my movie clip, in case it was conflicting with the scrollbar code, but it didn't help.

Please help! I feel like I'm really close but I'm missing something. I don't understand how I can get it to work in one example but not in another.

Thank you.

[realdoyle]

Kirupa forums comes to the rescue again. I found the answer. As strange as it seems to me, Embedding the fonts solved the problem. I thought I didn't need to embed until I was publishing to upload to a server. Guess I was wrong.
Here is the forum post for future reference: http://www.kirupa.com/forum/showthread.php?t=256058