Search results for query: *

To resolve the problem above. Set 'Currency' as a column Do not enter anything for rows For the summary field, enter in each field that you want depicted and seeing as you should only be expecting one of each, it doesn't matter which mathematical function you use for it (eg: sum(), max() etc)...

Hi, I am trying to develop the report below (with any number of currencies). Is this possible in Crystal Reports? If I use a cross tab, the values in the left hand column appear as field values rather than field names, while the detail fields do not display these values. * The column names are...

Hi All, I'd really appreciate any help with this one. Scenario: User gets on to network Via VPN and can access his mailbox as normal. However, when the session is ended, he no longer has access to changes he has made, contacts, new mail items etc... Question: Is it possible to synchronise...

mrdenny, Provider=SQLOLEDB.1

Type: SQL Server 2000 Database Driver: Microsoft OLE DB Provider for SQL Server

But would that be the Connect Timeout parameter, or is there a separate timeout parameter? I thought connect timeout would only apply to the initial connection setup? Thanks

A quick way to enter just the date into a datetime column is: CONVERT(DATETIME, '12/15/2003', 102)

Hi, I'm having a similar problem, maybe you can help. I'm calling a stored procedure from vb.net with the connection string "user id=sa;database=myDB;data source=Server;Connect Timeout=60" I am inserting a large number of records into a tblStuffArchive and it times out after approx 30...

Loomah: My appologies, you're quite correct. This has speeded up my application process by a few seconds. :-)

The code works fine for all of the above, except that it always finds the very last row in the worksheet. eg: i might have only 100 rows populated, but when I try to find the lastRow, it gives me row 1305. Any tips on stopping it from misjudging the selection area? Thanks.