Custom Report on tasting notes

CellarTracker Main Site

Custom Report on tasting notes

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Cellar Talk] >> CellarTracker Support >> Custom Report on tasting notes

Page: [1]

Message

<< Older Topic Newer Topic >>

Custom Report on tasting notes - 11/15/2008 1:35:29 PM

mclancy10006

Posts: 76
Joined: 3/19/2007
From: New York City
Status: offline

I was trying to make the CT top 100 of 2008 report. I thought to use the custom report "tasting note summary (grouped) and "show everyone's" and it does not return any results with no filters applied. (I was going to do wines tasted in 2008 with more than X notes)

I am missing the idea of that reporting option?

-Mark

Post #: 1

RE: Custom Report on tasting notes - 11/15/2008 2:02:32 PM

Eric

Posts: 5738
Joined: 10/10/2003
From: Seattle, WA
Status: offline

Grouped by what? What is the exact URL?

Why not just click REPORTS at the top and then click one of these under community: TOP 100: ALL, 2008, 2007

_____________________________

Cheers!
-Eric LeVine

(in reply to mclancy10006)

Post #: 2

RE: Custom Report on tasting notes - 11/16/2008 12:09:43 PM

mclancy10006

Posts: 76
Joined: 3/19/2007
From: New York City
Status: offline

http://www.cellartracker.com/query.asp?EditField=&Table=PivotNote&iUserOverride=0&VB=&VT=&ProScore=&szReviewer=&PriceBottom=&PriceTop=&szSearch=&FullText=&T=&Min=&MinUsers=&BeginScore=&EndScore=&BeginDate=&EndDate=&TastingYear=&TastingQuarter=&TastingMonth=&TastingDay=&TastingWeekday=&HideNullNote=0&Defective=&SearchType=Advanced

-Mark

(in reply to mclancy10006)

Post #: 3

RE: Custom Report on tasting notes - 11/16/2008 2:47:30 PM

Eric

Posts: 5738
Joined: 10/10/2003
From: Seattle, WA
Status: offline

OK, that's just the screen to build the query and even then you still need to pick a parameter (individual one) to group by. This is the link you are looking for anyway: http://www.cellartracker.com/list.asp?Table=NotesTop&iUserOverride=0&Min=4&MinUsers=3&T=100&TastingYear=2008

_____________________________

Cheers!
-Eric LeVine

(in reply to mclancy10006)

Post #: 4