Recent content by cantademorna

Hi There, I have this peice of code: SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0' ,'Excel 12.0;HDR=YES;IMEX=1 ;Database=C:\Documents and Settings\Andrew\My Documents\Test_Worksheet.xls;' ,'Select * From [Sheet1$]') and am getting this error: OLE DB provider...

Hi There, I was looking for a way to be able to manipulate the registry on Windows 7 64 bit machine via vbscript. The below code works fine on a 32 bit machine running XP Pro I understand that the following reference: REG_KEY_PATH = "HKLM64\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\XXX" or...

...yes I think that Workbook_Open() works, but suppose this scenario: The macro is accessing a 2 million row SQL Server table which in itself joins another 500k table, so it runs and produces the report. What happens when a user then sees the report and opens it in the ordinary way? With this...

Hi Folks, I was wondering whether this was possible? Just a bog standard .xls 2003 flavour sheet with basic vba module setting the cell A1 to "hi world" in order to test. I would like to run this workbook welcome.xls from a batch file and to be able to have this batch scheduled - should be...

SELECT "c"."abc_category", "c"."product", "c"."description", "c"."warehouse", "c"."analysis_a", "c"."standard_cost", "c"."purchase_key", "a"."transaction_type", "a"."movement_date", "b"."quantity", "b"."invoice", "b"."dated", "b"."invoice_customer", "c"."supplier", "b"."sequential_number"...

Hi there I am using CR 2008 and having performance issues when running a report. There are 4 tables tableA - 546,232 rows tableB - 1,017,073 rows tableC - 11,311 rows tableD - 1,489 rows tableC is the main table and is connected via indexes to the other 3 tables. The links are left outer...

It's POP3

I'm getting this message "Send test e-mail message: The operation timed out waiting for a response from the sending (SMTP) server. If you continue to receive this message, contact your server administrator or Internet service provider (ISP)." I can receive messages but can't send any. I know...

I'm not retreiving any data from a sql server database from within the 2005 environment. I've built the report as standard using an ADO.NET connection to a sqlserver dataset table. In standard stand alone CR10 you just specify the datasource and away you go. Here though am I doing something...

We are running CR10 and now want to schedule the reports to run at a certan time every day/week/month/year and deliver to email customers. Is there a *reasonably* priced (possibly 3rd party) tool that could achieve this. I've heard of CRD but the price is pretty steep. Any ideas good people...

Hello there once again I'm trying to feed a formula figure into a chart. If the formula consists of the following: numbervar avg; if ({@FormattedGroup} = "Pgi" and {#calls_closed_assign} > 0) then avg := ({#avg_hours_assign} / {#calls_closed_assign}) else avg := 1; Then it isn't...

Code = A 2343 33 97 9 Code = B 122 20 Code = D 9 43 12 903 This is the structure I have and is grouped by code I break it down by code and print the variables beneath the code (group) headings. How do I print the heading and the zero that would account for code C if no records/figures...

Hello all. Have put together a report where it's broken down by group. there are 4 groups A, B, C and D How do I print the zero stats for say group C even if there were no records coming through for that group? I know there's a suppress section if null but that's not helping. Much thanks.

One other reason for this error I found was if that record you're using has a link to another table and the index in some way has failed to connect to the other table or if the key connection for that record has been corrupted then the error occurs.

Yep, I've seen it, I'll try that and the creation of views also. Much thanks. A.