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...

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...

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...

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...

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.

In the interest of not wanting to spend countless hours on this, is there a way of effecting SQL subqueries? The below doesn't work I know, but is there a way round this? Unfortunately CR10 is really vague on this crucial kind of thing. +++++++++++++++++++++++++++++++++++++++++++++++++++++++...

Can I build up a SQL where statemant? i.e. can I do this : the_where_action := "{JOBS.CONTRACT_NO} = {?contract_no}" + " and {JOB_TYPES.ORDER_TYPE} = 'R'" + " and {ADMIN.PRIORITY} <> '4'"; and then excecute the_where_action for the select query? Is there...

After making a new data connection using the Oracle Server option, the tables are recognised and appear in the available data sources box but when I click to select an actual table the first error is: Query Engine Error 'ORA-00942 : Table or view does not exist' second error appears as: Query...