Search results for query: *

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.

The add command is there to add new data sources. There is no Add command key, however there is a Create New Connection option. There are single and double arrows which are greyed out which actually do the adding, but only if you select a valid datasource or table.

I'm going to attempt to create views and circumvent CR10 vagueries, maybe that's the simplest way to get this going.

Vampire you've lost me I'll tell you what I do. go into Database Expert go to Data tab then it says Current Connections, Favourites,History etc no Add command or anywhere I can past code. I've Added selected tables, but I can only Add tables here, can't I?

Thanks Turkbear, the Oracle code and concepts are clear as crystal (pun) to me, but CR10 command objects aren't and I'll have to see what one is first. CR10 so far has been good, but this is tricky stuff if you don't know the guts of CR10, but I'll check out what a command object is and see if...

Vampire, where do you place the code in the add command? in the Create New Connection?, Repository?, is it within a text file with the sql code that you add?