Search results for query: *

You're in the wrong forum - you'll just find tumbleweed in Seagate Info these days! You need to sort your report into the correct order, then use previousrecord({field}) in a formula. Andrew Baines www.pursuittechnology.co.uk

OK, checked the logs - nothing there. None of the databases report any errors. Any more ideas? Andrew Baines www.pursuittechnology.co.uk

I'll ask someone to take a look Andrew Baines www.pursuittechnology.co.uk

They're uprading from Crystal Enterprise 10 to Crystal Reports Server 2008. Crystal Server 2011 is just too resource intensive & you can't migrate from earlier versions if there are any non-rpt instances (fixed in SP soon). There's also no upgrade from Crystal Enterprise 10 to Crystal Server...

Thanks for the quick responses - to answer you both: It's a really simple install - the databases being loaded are tiny (MB, not GB), they're all stored on a local drive. No security is setup beyond only allowing a single user to connect. You really couldn't get any simpler - the database only...

I'm having a problem with SQL 2008 taking ages to make the databases available. Master, model etc are available very quickly, but the rest of the databases can take nearly a minute to accept connections. This means that an application on the server that needs to connect to the server won't...

I'm in the process of upgrading a customer from 10 to 2008. I must admit, I was surprised how much new stuff had been added - you tend to forget the old versions. Dynamic Parameters and Custom Functions alone are enough to upgrade for. There are always going to be alternative products. They'll...

Yes, but only since Crystal Reports 2008 (I don't have XI here to check, possibly there too) - it's in the export options setting - File|Export|Report Export Options Andrew Baines www.pursuittechnology.co.uk

You can't have the 2 server products installed together. Remove 2011 first, then install CRS2008 You can have both designers installed though. I don't do much with Sage, but if it's one of the products that needs SAge's own ODBC, I doubt it's available as 64 bit. Andrew Baines...

Yes, CRS2008 works fine on Windows Server 2008. Makes sure you get CRS 2008 V1, not V0. Works on both 64bit and 32bit Windows, you just need to make sure you use the 32 bit ODBC setup rather than 64 bit when creating your DSN. You can use any version client, but you won't be able to publish...

If you need 32 bit, try and downgrade to Crystal Server 2008 - needs lesser server too Andrew Baines www.pursuittechnology.co.uk

It won't cause a problem in it's own right, it's quite normal to have 32 bit client and 64 bit server. I assume you've set the password correctly! Are you using ODBC? If so, you need a 64bit ODBC installed on the server, with the same name as the ODBC on your PC. If you're not using ODBC, are...

RAS is only available to OEM customers now. Shame as it was a great product. You'll need to use the regular crystal runtime, or migrate to Crystal Reports Server (now just called Crystal Server). Andrew Baines www.pursuittechnology.co.uk

Don't forget the server is 64 bit only. If you're trying to use a 32 bit ODBC, it won't work. Either that, or you've not added the user name and password to the report in the admin console. Andrew Baines www.pursuittechnology.co.uk

Turn the time into a datetime with the same date as the datetime. If your fields are {myTime} and {myDateTime}: datetime(date({myDateTime}), {myTime}) Then use datediff to find the difference as earlier. When you use datediff, careful what difference you use - if you ask for hours, you will...

totext takes extra parameters - try totext({field},0,'') Something like that anyway Andrew Baines www.pursuittechnology.co.uk

Use datediff then Andrew Baines www.pursuittechnology.co.uk

Try turning off the grouping on server option. You can normally add unlinked tables, just have to be careful that Crystal doesn't try to be too clever. Andrew Baines www.pursuittechnology.co.uk

It's 5 years since I last used CRAXDRT, so apologies if I get this wrong as I use the .Net version now, plus C# rather than VB. Isn't it possible to just iterate through the subreport collection via the report object, rather than going through all the sections and reportobjects? I think is...

You don't say what version you're using, but take a look at datediff in the formula help text. If it's not there, could be time to upgrade? Datediff takes 3 parameters - 2 dates and an interval type. You can have intervals of pretty much anything - minutes, hours, days, weeks, months etc...