Weird output with associated field

Boaz Bezborodko boaz at mirrotek.com
Mon Jan 28 18:54:54 PST 2008


OK, I've figured out what part of my problem was.  The report was being 
sent to Printwizard to get converted to a PDF.  This is done through a 
queue on the file server which, unknown to me, had been switched to 
disable mode somehow.  My file naming system uses today's date to 
isolate when a report was run since who would need more detail than 
that, right?  Well I didn't realize that the program was bringing up the 
older reports and that the new ones were OK.

So now I just have to figure out what was different in my programs that 
kept the records from printing out properly.

Boaz

Jeff Harrison wrote:
> --- Boaz Bezborodko <boaz at mirrotek.com> wrote:
>
>   
>> I'm having trouble with a report.  I'm re-running an
>> accounting report 
>> that someone ran a week and a half ago, but I'm
>> getting a strange 
>> result.  One of the items in an associated field is
>> not being printed.
>>
>> Each record can store a few GL numbers in associated
>> fields A1.  The 
>> report selects the records by invoice date and sorts
>> them by A1.  The 
>> report that was run over a week ago seems to have
>> everything correct, 
>> but the report I'm running today has the associated
>> field missing on 
>> just one record.  Other records with associated
>> fields print out properly.
>>
>> I have the exact same problem with 3 other records
>> that are exactly the 
>> same in different months.  (They are monthly
>> insurance payments 
>> allocated to two different GL #s.)  For some reason
>> the second 
>> associated field on them also don't appear on the
>> reports for their 
>> respective months. 
>>
>> The records haven't been touched in between the runs
>> and the only change 
>> was indexing the selection to speed it up.  But the
>> records are 
>> definitely getting selected since the first
>> associated field appears on 
>> the file.  And the report is definitely printing
>> associated fields since 
>> other records with entries in the multiple
>> associated fields are 
>> displaying correctly.
>>
>> What is causing this and how do I fix it?
>>
>> Boaz
>> _______________________________________________
>>     
>
> Hi Boaz.  It is hard to answer this question without
> knowing the specifics of exactly what you are doing
> for sort/selection.  What does the -v table look like,
> what do the sort fields look like on the report?  What
> auto indexes do you have?  What does the selection
> table look like?
>
> A telling statement of yours was:
> ...
>   
>> and the only change 
>> was indexing the selection to speed it up. 
>>     
>
> Can you give more specifics here?
>
> Jeff Harrison
> jeffaharrison at yahoo.com
>
> Author of JHExport and JHImport.  The fastest and
> easiest ways to generate filepro exports and imports
>
>
>
>       ____________________________________________________________________________________
> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20080128/7479b62b/attachment-0001.html 


More information about the Filepro-list mailing list