Who is online?
In total there are 2 users online :: 0 Registered, 0 Hidden and 2 Guests :: 1 Bot

None

[ View the whole list ]


Most users ever online was 73 on Sat Apr 07, 2012 6:43 pm
Latest topics
» EDH Regular casual Game
Fri Aug 23, 2013 8:37 am by rock.strongbow

» Places to play EDH in Philly
Fri Aug 23, 2013 8:34 am by rock.strongbow

» Looking to get into Magic
Fri Jun 21, 2013 11:21 pm by Bigc215

» So when can I play someone?
Wed Jun 05, 2013 6:32 pm by nick.martin.144734

» Legacy Needs
Tue May 28, 2013 5:15 pm by Bigc215

» James's No Rare Cube
Fri May 24, 2013 10:29 am by intrinsic

» Yavimaya Hollow
Thu Dec 13, 2012 3:09 am by idTAPthat

» Alumni of "MtG Sunday" Comic Book Theater on Passyunk Ave.
Thu Dec 13, 2012 3:02 am by idTAPthat

» Ravnica foils needed - have dual lands and more to trade
Mon Nov 12, 2012 11:49 am by PatrickR


Magic Reports

Go down

Magic Reports

Post  Slyphidine on Wed Aug 19, 2009 9:03 am

So you may have noticed I make those snazzy printouts of the Cube's stats. I do this using a reporting program called Crystal Reports (that I use at work). Unless you have a few hundred dollars to spare, it's not too accessible (plus the learning curve is through the roof).

However, the way it works is by pulling the data from an existing data source. In my case, I use Excel since it's pretty simple and easily accessible. You can see my Excel template here.

I can "trick" Crystal Reports into running a report on anything that follows that Excel template. I can even sort and filter it to show me only a subset of the information (say, just the unfoiled cards in the Cube).

What this means is that if you download the Excel template and replace my Cube data with your, say, Big Deck data, then I can produce a full report just by clicking a button.

I like this report because it not only does a nice layout of the cards, but it also charts cards by CMC, both by color as well as overall. Of course, this only works if you actually fill all the information in on the Excel sheet. The "Promo/Foil" and "Special" fields are more for my organizational purposes, but with everything else in there, it will work just fine.
avatar
Slyphidine
Admin

Posts : 1449
Join date : 2009-07-13
Location : Mt Airy

http://www.neonandshy.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum