GENBOX-L Archives

Archiver > GENBOX > 2004-08 > 1092588232


From: "Cheri Casper" <>
Subject: RE: [GENBOX] Begging the Report Question
Date: Sun, 15 Aug 2004 09:44:26 -0700
In-Reply-To: <20040815102035.FSPI20894.amsfep19-int.chello.nl@KANTOOR>


Wim - You are a lifesaver! Thanks so much; that worked.

Reports need to be simplified in how they are run and how content options
are selected. Users need to be able to select, for example, HOW they want
names to populate the report, i.e., Given + Surname or Surname + Given.
Those options don't currently exist. It would be useful to have report
where you could break the information into columns so that the person's name
was parsed into separate fields (see above). By allowing the user to
control output into columnar form with more specificity, reports could then
be used in Excel for different types of manipulation.

I think reports (and possibly queries) might be deal-breakers for people who
are test driving this program. As much as I love GB, I was about ready to
put my fist through the monitor (but you didn't hear me say that I was about
ready to revert to TOP). I certainly hope that this area of the program
moves to the top of Bill's list for attention and refinement.

CheriC

-----Original Message-----
From: wim prange [mailto:]
Sent: Sunday, August 15, 2004 3:21 AM
To:
Subject: RE: [GENBOX] Begging the Report Question


CheriC - I think I've found the problem. I've defined a Cen-LkUp-template
and created a couple of events for several people with different years and
different combinations. This is what I found.

The reportoption: "Name; Cen-LkUp = 1850 (Show All); Note" will list only
people who have ONE Cen-LkUp event IN TOTAL (the one that occurred in 1850).
If the individual has two Cen-LkUps (in different years), the individual
doesn't mach the criteria so will not get listed.

The reportoption: "Name; Cen-LkUp = 1850 (Show One); Note" will list people
who have their FIRST Cen-LkUp event in 1850. If they had another Cen-LkUp
BEFORE 1850 they will not get listed.

I couldn't find a way to circumvent this in the current version of Genbox,
it could be done in the beta-version:
Report > Events > Content;
Delete the ID + Name allready under selected fields;
Select Name under Available Fields, enter "Cen-LkUp*1850*" in the filterbox
and bring it to selected fields;
Select Primary plus Research Note without any criteria and bring it to
selected fields too;
Run the report.

You could still send me the gedcom/database if you want. Did you receive my
mails concerning the +5Mb limits of my mailboxes?

Gr. Wim





> -----Oorspronkelijk bericht-----
> Van: Cheri Casper [mailto:]
> Verzonden: zondag 15 augustus 2004 9:44
> Aan:
> Onderwerp: RE: [GENBOX] Begging the Report Question
>
> Nope, I get an empty report with a heading only, same as I
> get when I use
> Individuals > Events and select basically the same options.
>
> I must have really made God angry.
>
> CheriC
>
>
>
> -----Original Message-----
> From: s.lloyd9 [mailto:]
> Sent: Sunday, August 15, 2004 12:26 AM
> To:
> Subject: Re: [GENBOX] Begging the Report Question
>
>
> Hi again Cheri,
> Oops - you are quite right it doesn't work does it - all
> years as you say.
> Try this (if you haven't already):-
> Choose 'Individual - Date Range' Report. Select List Members. On the
> Content Tab select Events from the drop down List, Highlight
> 'Event' in the
> 'Available Fields' box, tick 'Type' under 'Multiple Events', choose
> Cen-LkUp from the dropdown List, move back to the 'Available Fields' ,
> highlight ' Event date', enter the year in the Filter Field,
> move selection
> to right hand 'Selected Fields'. Highlight 'Event Research
> Note', again
> move selection to 'Selected Fields', repeat for 'Event Place'
> if you want
> that included. Name and ID are included in the 'Selected
> Fields' by
> default I seem to remember, otherwise of course you'll have
> to select
> them too.
>
> Does this give you what you want?
> Odd, I included Event Place, but I'm not getting the Local
> Site in my report
> and I can't see why.
>
> Sally
>
>
>
>
> Sally
> ----- Original Message -----
> From: "Cheri Casper" <>
> To: <>
> Sent: Sunday, August 15, 2004 5:19 AM
> Subject: [GENBOX] Begging the Report Question
>
>
> > I still haven't gotten sufficient answers to run the report
> that I want so
> > I'll try again, hoping someone can give me absolutely the
> lowest level
> > explanation/steps needed to accomplish this:
> >
> > I have events called Cen-LkUp. Each of those events has a
> Research Note
> and
> > a Date (year only). I want a report that will give me the
> Name & Research
> > Note for every individual that has a Cen-LkUp event with a
> date of 1850
> (or
> > 1860, or 1870, etc.). Some people have Cen-LkUp events
> with differing
> > dates, i.e., they may have one for 1850 and 1870, etc.
> Some folks only
> have
> > one Cen-LkUp event. I need to get a list of individuals on
> a year-by-year
> > basis. For example I want *everyone* who has a Cen-LkUp
> event for 1860,
> > another report for 1870, etc. I do not want "mixed years"
> in a single
> > report.
> >
> > Usually my reports are blank when I try running them. When
> I do get one
> for
> > 1860, it contains only two names. Yet when I run a query
> for all Cen-LkUp
> > events with a date of 1860, I get 13 hits. Of those 13,
> I'm getting the 2
> > that show up when I try to run the report. I can't figure
> out why the
> other
> > 11 names are hiding from me when I run the report, but are
> there when I do
> a
> > query.
> >
> > I've tinkered with this for at least 4 hours over the
> course of 3 or 4
> days
> > and still can't get the *&^%$#@~)_+$%^ report out! I
> really, really need
> to
> > get these reports generated before Monday.
> >
> > I'm sending a box of goodies to the first person who can
> give me steps
> that
> > result in complete and accurate report results and who will
> provide their
> > snail mail address for shipping of same. I'm absolutely at
> wits' end; Wim
> > offered to help, but mail to him is bouncing.
> >
> >
> > CheriC
> > I desire no future that will break the ties of the past.
> ~George Eliot
> >
> >
> >
> >
> > ==== GENBOX Mailing List ====
> > To join this list, send an email to
> with the
> word "subscribe" as the subject line. Then email your messages to
> and they will appear on this list.
> >
> > ==============================
> > Gain access to over two billion names including the new Immigration
> > Collection with an Ancestry.com free trial. Click to learn more.
> > http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.736 / Virus Database: 490 - Release Date: 10/08/04
>
>
> ==== GENBOX Mailing List ====
> To join this list, send an email to
> with the
> word "subscribe" as the subject line. Then email your messages to
> and they will appear on this list.
>
> ==============================
> Gain access to over two billion names including the new Immigration
> Collection with an Ancestry.com free trial. Click to learn more.
> http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>
>
>
>
> ==== GENBOX Mailing List ====
> To join this list, send an email to
> with the word "subscribe" as
> the subject line. Then email your messages to
> and they will appear on this list.
>
> ==============================
> Gain access to over two billion names including the new Immigration
> Collection with an Ancestry.com free trial. Click to learn more.
> http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>


==== GENBOX Mailing List ====
To join this list, send an email to with the
word "subscribe" as the subject line. Then email your messages to
and they will appear on this list.

==============================
Gain access to over two billion names including the new Immigration
Collection with an Ancestry.com free trial. Click to learn more.
http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237


This thread: