Liveware Publishing Support Forum

We just upgraded to MOM 6 and R&R v12.5. I have tweaked all of our old R&R reports so they work well on R&R, but for those that I need to export to Excel from R&R I am having problems. The dates are looking fine on R&R but when I look at it in Excel, the date doesn^t translate; i...

The issues mentioned above have been worked out, but there is one lingering problem. It is not entirely clear how to remove returned items from the list, as MOM has a separate line entries for the original purchase and the return. Given that the gross sales field is calculated using quantity * list ...

We have the same problem at my workplace, but it only happens on one computer. If I open the file on one of the non-problematic computers and save it as an .xls file, it will then work on the problem computer. We^re a bit stumped as to why this happens, but hopefully this work-around will do the tri...

Thanks for the help. That did succeed in returning the proper date ranges, but there are still a few issues remaining.____The report is set up so that only the page header and group footer are displayed. I have my sales list grouped according to ITEM, and in the ITEM footer I have the following: ___...

I am trying to create a report that will create sums of product sales information (# sold, gross sales, total profit) in two columns. In the first column, I would like to return data form a range of one month as defined by a SUBMONS function; in the second column the same month but one year prior us...

That would get it if I were only trying to filter for a positive. The problem is, I need to filter for a negative as well; I need to return a list of all customers who have purchased products within a given list but have not purchased anything outside of that list. On a separate forum, someone poste...

I am using MOM 5.4 with R&R Infinity and am trying to accomplish the following:____I need to develop a report of customers who have only purchased from a narrow list of our products. I have tried building a report with CUST.dbf as the master table that links to INVOICE.dbf via the CUSTNUM field ...

Does anybody know how to calculate quartiles using R&R Infinity? I am presently exporting to Excel which is simple but time-consuming when dealing with hundreds of data sets. I have a hunch that R&R could accomplish this in far less time, but I^m at a loss as to how and have not been able to...

I have come across a situation where the alias workaround is not helping. It did work when I tried to relate an excel spreadsheet saved as .dbf with .dbf files created in MOM. This time, I tried to relate multiple excel spreadsheets saved as .dbf without any already-indexed .dbf files in the mix. Is...

Changing the related table Alias did work, though I don^t understand why this should make a difference. Is it just a work-around to a known bug, or is there a legitimate programming reason why this is so? If the latter is the case, I would like to know the principle behind the alias ^fix^ so as to u...