Search results for query: *

I am experiencing very long times when exporting very large e.g.9587kb reports (in eportfolio) to .rpt format using the Active X viewer. I usually end up cancelling. Anyone else have this issue? Or is there a workaround this. Pageserver settings: 20 M before Idle Connect Closed 60 M Idle...

Just finished reading the thread-Wow. We are in the midst of converting a Platinum DB (SQL) to Apprise (Progress V9.1D08). Part of this coversion is having to re-write all Crystal Reports 8.5. The registry has been updated to allow left joins; Using ODBC Merant 3.60 32-bit Progress SQL92 v...

One advantage is speed. Complex formulas can be processed on the server instead of the report.

I need to convert a tables' julian dates to DateTime. Is there a simple way to do this? Any help is appreciated. Thanks

I have Access 97 App, that, until July, has worked fine. July 1 the subj error started appearing. Unable to de-bug - hitting blank. I've located the field which is null (ptdEnd) but unable to locate where this field is being updated. I documented the report form and discovered that the row...

Thanks Terry, I appreciate your reply. DBCC CHECKDB uses a lot of resources against the system. I'm wondering if there is a way to target a specific table. Cenie

I've joined several large tables into 1 table that is updated nightly. There must be bad data in the table because I received this error last night: Server: Msg 614, Level 18, State 3, Line 8 A row on page 774351 was accessed that has an illegal length of 0 in database 'THWG'. How do you...

Anyone heard of an XP patch available for Access applications to handle possible VBA scrip corruption. I have an Access97 application which will be moved to a PC running XP.

I have an OTC 850XL printer, used for invoices, that I send a Crystal Report to. I have a driver which is v3.3. I believe I may need version 2.5 or a generic windows text print driver. Anyone know where I can download drivers like these? Thanks in advance for your help

Thank you all for your expert advice. I ended up with this: &quot;Delete * From tblSales where date_shipped >= #&quot; & LastUpdate & &quot;#&quot; & _ &quot;OR (date_shipped >= #&quot; & DateAdd(&quot;d&quot;, -20, LastUpdate) & &quot;# And qty_shipped < 0)&quot;

Thanks for your help! I'll try this now and let you know.

Thank you for your help. The error I get is &quot;Data type mismatch in criterior&quot; The code worked fine, before I added this statement: &quot;or tblSales.qty_shipped < 0 and tblSales.date_shipped >= dateadd(d,-20,#&quot; & LastUpdate & &quot;#)&quot;

Following is more of the code: sql = &quot;INSERT INTO tblSales &quot; & _ &quot;SELECT tblSales.* &quot; & _ &quot;FROM &quot; & _ *******ODBC CLAUSE HERE****** &quot;INNER JOIN tblSalesOrganization &quot; & _ &quot;ON (tblSales.ship_to_code =...

I'm pulling data from a SQL DB table to a local table in the application.

I am having difficulty adding the dateadd function to a sql script &quot;where&quot; clause within an application. I want to include records that have neg qty within a 20day period. The original code is: sql = &quot;Delete * From tblSales where date_shipped >= #&quot; & LastUpdate &...

Thanks Rishi146 appreciate your suggestion. I am passing variables along the way - not that many though. Maybe there's another option...

I have a procedure that is scheduled to run hourly and accesses production tables used by our order entry application. This procedure populates a table that is used by a crystal report (report runs hourly as well). I've run into blocking problems. I've tried to make the procedure as...

Thanks pdldavis!! I believe that will work.

I have a report that's grouped by VP, Region, Item then Customer. So Customer is at the detail level. I'd like to add line numbers to count the customers for each item. I'd appreciate any help for this basic question. Thanks!

Thank You! That was the command I needed. I was able to get to the bottom of the issue in the table. Thanks again and Merry Xmas!