Liveware Publishing Support Forum

Running version 12 against a SQL Server 2005 database.____A user-SQL report, with filtering based on 4 parameters, crashes when printing from print preview, but not from a straight file-->print.____The crash only occurs when the parameters are set to certain values (i.e. we get a specific resultset) and can be reproduced this way at will. Yet, I cannot see a pattern.____Error message is ^The instruction at "0x73dd11c7" referenced memory at "0x00000004". The memory could not be read^____The SQL is below & the parameters filter as follws:__XASTRANS.XTRANSDATE >= start_param__XASTRANS.XTRANSDATE <= end_param__XASTRANS.XDEALREF like dealref_param__XASTRANS.XCOMPANY like company_param____The dates are char type, format yyyymmdd eg ^20070331^__dealref_param is entered with a wildcard suffix____select__ XASTRANS.XCOMPANY,__ XASTRANS.XTRANSDATE,__ XASTRANS.XORIGCURR,__ XASTRANS.XORIGVALUE,__ XASTRANS.XCOMMENT1,__ XASTRANS.XCOMMENT2,__ XASTRANS.XDEALREF,__ XASTRANS.XALTERNATE,__ XCOMBINED.XCTP,__ XCOMBINED.XTTYPE,__ XCOMBINED.XPAYBANKNM,__ XCOMBINED.XRECBANKNM__ from __XASTRANS__LEFT OUTER JOIN XCOMBINED __ON (XASTRANS.XDEALREF = XCOMBINED.XDEALREF)__order by__ XASTRANS.XORIGCURR, XASTRANS.XALTERNATE, XASTRANS.XCOMPANY, XASTRANS.XTRANSDATE____Any help greatly appreciated!

Are these R&R parameterr fields and a local filter?____Kathleen__R&R Support

Stuart,____Thank you for communicating this problem !!! ____I hope that the frequency of this kind of problem, which I am convinced is identical to the problem I reported, helps Kathleen realize that it is a bug in the Viewer software and get the programmers on it. ____Here is a note from one of my customers who is frustrated with my application because of the problems with the RRWRUN.EXE Viewer (both versions 8.1 and Infinity).____"As for the "send" don^t send" error messages...I get these messages if I try to view a report and print from the view report screen. If I simply select a report and print without viewing it will print fine. I am also getting the error message if I view a report and then close the report screen. ____This is the message that I am getting... ____"R&R Report Viewer has encountered a problem and needs to close. We are sorry for the inconvenience."...."If you were in the middle of something, the information you were working on might be lost. Please tel Microsoft about this problem." Then I have 3 options - Debug, Send error report, Don^t send. If I click Debug, the program simply closes. ____If I click Don^t send, a box containing the following appears.."The instruction at 0x73dd11c7 referenced memory at 0x00000004. The memory could not be "read" Click on ok to terminate the program."__