Hello all..

I've created a table in FnL (aka UDT) that will contiains baseball stats, currently only hitting stats.  Using the XSLT creater in FnL I created a view that simply shows the basics, Name, Number, Postion, Grade, and if someone wants to view the details of that specific player they just click on the magnifying glass, which works really well.

I wanted to be able to pull all the Players stats into one view so I could present a team stats view.  Do do this I installed the Reports module along with the UDT Data Source.  I created a Team Hitting Stats report and used the grid view to display the results and it works fine.

Now I've got a couple of major challenges:  #1 is seperating out one specific player, the Pitcher. I 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 and #2, using the Reports module I'd like to create a simply report view output of the roster and then have a details link, such as the one in FnL, that will change the view output to a more detailed view, which includes all data for just that specfic player.

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 "details link", currently the magnifying glass on the FnL page, 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.  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 magnifying glass (details) link, I think.

If I use a XSLT to view the output, is there a way I can include a details link, simliar to the one in FnL where a magnifying glase shows and the end user is taken from a simply roster layout to a more detailed view of the indiviual?

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

Thanks,
Bob