Liveware Publishing Support Forum

[updated:LAST EDITED ON Dec-09-02 AT 00:08 AM (EST)]Why can you not sort on a calculated field whose expression includes both a preprocessed total and a database field?____I^m using version 9 SQL.____Thanks,____Robert Eshelman__

Well I attempted to update before I tested this, but I accidently updated R&R xbase ( I have both versions). I have now updated and tested and it works!

I forgot to mention, I also dropped seconds so on mine time will read in format 12:35pm.

One small correction:____If 24 hour time is 1230, then time is not >12, but still needs to be pm. I just happened to test this around 12:30pm...____I think this will work in all cases:____IIF(VAL(LEFT(TIME(),2))>11, __ IIF(VAL(LEFT(TIME(),2))=12, __ LEFT(time(),5)+"pm", __ str(VAL(LEFT(TIM...

I remember seeing this issue previously on the board and wanted to know if there is a workaround:____When using R&R SQL email burst with Outlook 2000, the email names submitted to Outlook have single quotes around them and will not send. An error message is returned saying "None of your e-m...

Yes my report does have a page footer and its distance from edge in Word is .5"

I^m exporting a report to rtf. When I open the report with Word, the page header starts about 2" from the top, and last few lines at the bottom of the page overflow to the next page. Specifically in Word, if I go to File - Page Setup - Layout, the header is 1.88" from the edge. Where does ...

hmm, well the link in my posting above shows their Manual released last year. In many of the screen shots, the program looks almost identical to R&R SQL ver. 8 or 9. Check out page 43 or 236 in PDF manual above and you will see what I mean. Seems to be too close for coincidence.____I^m just curi...

Progress Software sells a product call Report Builder - see http://www.progress.com/v9/documentation/rptls91b/rbu/rbu.pdf____The screens in the user guide look identical to R&R SQL edition. I^m wondering did you licence your product to them?____Thanks.

Have done further testing of this - what happens is parameter field value does change, but the filter is not regenerated. So if filter includes parameter value, it will not be updated. Only way to do so is to close report and reopen.____Have tested with date and numeric parameter field type.____Kath...