Hi all -

I'm looking for some suggestions on how to accomplish the following task.

We're running a fundraiser for our organization.  We're using FNL to let people enter pledges in different categories.   We need to show a 'leaderboard' which sums up the pledges in each category and puts them in order.  While the pledge campaign is running, we're not showing individual totals, just the ranking, but we'd also like to show the overall total of all pledges in some kind of graph.
To complicate things, we need a couple of diffent views on different pages, so just using the "list" to expose columns is not working since any change to the visible columns affects all instances of the module.

I can capture all the data in the FNL module, but reporting on it is the challenging part for me.  I tried to use the standard reports module, but am running into problems where I try to sort by "amount" when "Amount" is not a visible field and it bombs out since it appears that field is required... and I have no idea how to accomplish the overall graph.

Suggestions here?

Kevin


Fields
Sponsor Name,     (text)
Pledge Category,   (text selection of 4)
Pledge Group,     (text)
Pledge Amount   (currency)

Report 1
Top Pledge group for each category - show just category and pledge group, not amount

Report 2
All pledges (subtotal on group) for each category, order by Amount - do not show amount.

Report 3
total pledges versus goal.  Display as graph if possible.

Hello Kevin,
I would suggest you look into using XSLT layout sheets to display the information you want.
I'm still in the process of learning XSLT, but it's coming along and have learned a lot.  XSLT is very powerful and you can create custom layouts, looks, etc.  You can even setup logic within the XSLT as well so that different views can be shown for different circumstances.
I would first turn on the views for all your columns you want to see and within the F&L module, generate a new XSLT.  Use this generated layout as a guide as to what the column names look like, etc.  Then create a custom XSLT for each page you want.
Then on each separate page, you can either reference the main F&L and use the custom XSLT for the layout you want, or use the XML module in conjunction with the F&L data provider (http://xmlproviders.codeplex.com/rele...) to just display the F&L information without editing abilities.
With the use of the XSLT and Filtering within the F&L module, anything is pretty much possible; as I've been learning.

Hope this helps.. -Jeff

Hello Kevin,
Yea, the first couple times I looked at the XSLT, I just stared and it and didn't understand what was occurring; especially looking at some of the advanced forms available with the install of the F&L module.

If you have a development side of the house, generate different XSLT layouts and look at them in something such-as Notepad++.  You'll start seeing patterns as how the XSLT works and then what you can do with the XSLT.

You can implement logic within, and as I've just learned mathematical processes as well; adding integer columns together, dividing columns between each other, etc.

One thing which I've learned the hard way, if you have a table or a list setup and need a space between items, etc, use   instead of   .

As I'm learning new features, after posting for assistance, I try to post my XSLT code so that it may help something else. I think I've posted a couple of my XSLT's within these forums. You may be able to search and find these postings. Hope this helps.. -Jeff