Hello all...

Not getting much love in my other post so I figured I'd try this area, and simplify my question a bit.

I have some data that was created using FnL, I've installed the Reports module along with the FnL data source.  I can create a report to show all the data in one grid view, which is fine for one report.

I'm "trying" to use Reports and FnL to display stats for a Baseball team.

1.  I would like to be able to create a report that shows a simply view of the data, lets say 5 items, (Name, Position, #, etc), of a 20 item table, then have the ability for the viewer to click on a link (or like in FnL a magnifying glass) that then shows all 20 items in the table for only that specific player, preferably in the same container that the simple view displays.  This works as needed in the FnL, once I modified the XsLStyleSheet, however can't quit figure out how to make it work using the Reports module, because there doesn't seem to be a "Details" option. 

2.  When a Player in the table, such as the Pitcher, as two sets of stats, (Hitting and Pitching), I would like to be able to include the Pitching stats along with the hitting stats in that same detailed view.  I would image that I could do some type of query that states if Position=Pitcher include this data as well, but again I'm not sure how that would be done in the Reports module, if I'm using the FnL datasource, I don't see a way to make queries.

I have looked at a couple of 3rd party modules to help with this but would really like to use the built in FnL and Reports modules, considering they come standard..

I'm open to any thoughts or idea of how to make this work, whether I should try a different approach of displaying the information or if using the current modules are not the best option..

Thanks,
Bob