I'm creating a List, using Baseball stats. I've reviewed the tutorial for UDT. But I'm not getting the results I was hoping for. My first issue and most pressing is that I'm using the advancedtable.xsl for the Rendering Method. The first page looks ok but when I click on the Mag glass to view the inter contents they are listed vertically and I need them to be horizontal. Is that a setting in the .xsl I need to change or somewhere in the module settings I'm overlookig? I don't belive its a .css change, at least not the skin.css or my container css file because if I make the colums visable then it shows horizontal on the fisrt page. Any thoughts or suggestions? My second issue is that I'd like to get the data, such as the player name or position to be centered under the header text. I can understand if that is a .css edit, but not sure where that would be. Thoughts on that one? Finally I'd like to know if its possible to pull the data from one list module to a completely different one so that I can display the stats info in one big table as well as keeping the indiviual players stats seperate. Thanks, Bob

I can't give you very detailed answers, but ... allow me to change the subject. You might want to take a look at SQL Selected Grid View (SGSV) from Tressleworks.ca. I've found it to be a very useful module. There is a free version. The paid version costs all of $7.

The answer to your final question depends on whether or not you have all of the statistics in a single table, or if you have statistics for each player in a different table. If the answer is different tables, you will need to write a rather complicated SQL query to return all of the results. If the data is all in one table, you can write a query to return all of the data, or use a filter to return just one player, i.e. WHERE PlayerName = 'Joe Smith'.

More details will help.

Note that if you go to SGSV, there are dropdowns that you could use to select by player, by team, etc.

Thanks for the reply Joseph..

I actually got my look and feel looking the way I wanted, just had to find the right css files and played around with the .xsl creater. Pretty handy once you get the hang of it, plus it helped that I watched the tutorial again.. :-)

On the main Roster page shows just some simple information, (Name, Jersery #, Position, and Grade), and when an end user clicks the Mag they see all the detail hitting stats for that specific player.

Anyway on my final issue of pulling data from one List to another I've kinda of gotten that addressed as well. I installed the Reports module along with the Forms and List Data source. Now using the Reports module I'm grabing everyones data and setting up as a Team Hitting Stats so the entire team stats can be viewed at once, works really nice.

My newest challenge is seperating out one specific player, the Pitcher. Since Pitcher's stats are just as important as hitting stats I now need a way to display not only the hitting stats of a player but also the pitching stats, only if the player is a pitcher.

Right now only hitting related stats, plus the name, jersery #, grade, and postion are in one table. I have not create a new table specificlly for Pitching or including the pitching related stats headers in my original hitting stats table. I need to figure out a way so that if the player is a Pitcher than when the Mag (details) is click on it not only shows his hitting stats but his pitching stats as well.

I suppose I could add the pitching stats to the original table (hitting stats), change the name of course to simply stats. Then create 3 reports with filtering; one report for just the basic Roster, one for Hitting Stats and a final report with filtering so that if Postion=Pitcher than show both sets of stats. But then I'm not sure how I would get the user from the Roster simply layout to the detailed stats layout for only that specific player, I would lose out on the Mag (details) link, I think.

If anyone has any suggests or thoughts I'm all ears..

I did take a quick look at the SGSV that you suggested, and this may work for me, I haven't had the chance to download and try yet, when/if I do I'll let you know how it worked out. I say if cause you or someone may have another suggestion based on the details above. BTW..I can't use IngoGrid, just not in the budget..

Thanks,
Bob