I'm having two issues that I know I have seen on the list before, but I cannot find where there has been resolution:
First is the ARERR 553 - Operation Requested is too large for a single SQL Command when running reports. I have run these same (saved) reports before and had no issues. Usually, I can take off the Grouping and the report will run, but not always. One report, which I created today, will generate a SQL statement like: SELECT T9.C1,T9.C1,C536870942,C536870943,C3 FROM T9 WHERE ((T9.C1 = '0000 00000262731') OR (T9.C1 = '000000000262802') OR (T9.C1 = '000000000262803') OR (T9.C1 = '000000000262804') OR (T9.C1 = '000000 000262853') OR (T9.C1 = '000000000262870') OR (T9.C1 = '000000000262872') OR (T9.C1 = '000000000262875')... And it gives the 553 Error. This output is from an old report which was created as a macro and then triggered by an AL (button): SELECT C1,C536870950,C3,C536870970 FROM T290 WHERE C1 IN ( '0000000000505 29', '000000000050530', '000000000050532', '000000000030623'... This one still works fine. It has 4171 records, the first report has 2058. I did notice that the first one uses the "OR" to select each record and the second one uses "IN" to select. But, more importantly, the second one breaks down the statement into several statements, each with a different group of Request IDs, which show up in the sql.log. The first report does not - it tries to do them all. Second issue: We are still using DDE to send reports to Word and Excel. Although Microsoft says DDE is still supported in Windows 7, we cannot get the reports to output - the screen does a quick flash and then nothing happens. Of the several reports that we still use, we have to keep an XP machine to create and print the reports. Has anyone been able to make DDE work on a Windows 7 PC? Much thanks in advance, Kelvin _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
