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