Liveware Publishing Support Forum

Here is my test data. FoxPro free table.__ __We want to have the total qty sold of each item in a year column__and the last price, by date, for that item in a year column.__Qty sold is a no brainer but I^m having a problem with picking __the last price for the year to go in the column. __ __Picking ...

Thanks, It^s nice to see that it^s not me - just a limitation in R&R:)

The following code works in both FoxPro and Infinity__and if the invoice was in 2008 shows the quantity shipped __if in any other year shows 0.____IIF(year(invdte)=2008,QTYSHP,0)____I would like to have a space " " show up on the report - much easier to look at - if there were no shipments...

Never mind I figured it out.____The human brain is a wonderous thing.__I just went to bed last night and woke up about 2AM with the very simple solution (subconsious problem resolution).____Created a calculated field with a new name and used the 2nd company contents as the value, then replaced the f...

I have a report that runs fine. Previews to the screen and prints OK but when I try to export the detail line to a CSV for Excell use it drops one of the fields.__I think I know the source of the problem. __On the detail line I am gathering data from three files. Two of the files have a field named ...

Thanks kathleen,____That^s exactly what it was but I have no clue how that got __in there - Oh well.__That was a case of "can^t see the forest for the trees"__Trying to make things to complicated.____Thanks again,__H

I have built a very simple Accounts Receivable report that for some reason just stops after printing 4 pages. Same behaviour if previewed on screen.__Customers just stop in the "A"s does not even complete them much less the rest of the customers.__This has to be something simple that I kee...

Kathleen,__Thanks for the input but I still don^t understand how that would weed out the duplicates.__One of the files here is the current file and one is history - same structure.__If a record is still open in the current file, but was initiated in a prior month, the record will appear in both file...

This may sound like a very newbie question but I can^t figure out how to gather data from two files with identical structures to create a report. The two files are current and history and there may, at any time, be records of the same transaction in both files.__I think I need to write a function to...