Saving from v 11 to v 8.5

This is a very basic question, but I've created a report for a client in v11 and they are only running 8.5. I can't see any option in the Save As... or elsewhere that would explain how to save to an earlier version.
Can someone help please?
KyleAs far as I know, You can't do that...

But... try Exporting the report and look for a Crystal Reports 8.5 Format|||Thanks for that tip. There is an option to export to Crystal, but not sure if that means that it then can be read by earlier versions. Will check.|||There is a fundamental difference between 11 and 8.5. CR 9 is the oldest version which will work with 11. We have a maintenance agreement and we had Business Objects open up a case for us on this.

Basically we are out of luck.

8.5 simply will not open saved in 11.sql

Saving a database into an importable file format

I am brand new to SQL. Have limited coding experience w/ Visual Basic and database ops w/ Access.

I have come into possession of a SQL 2005 database. The problem is that the designer tried to re-invent the wheel and code a very very poor LMS back end for tracking and reporting. I would like, if possible, to save the database and as far as I am aware - should be able to import into Access and generate statistics and reports to my hearts content.

I have tried w/out success to save the database going through SQL Server Management Studio Express.

Any help or information that could be provided would be appreciated. Any additional information that I can provide, please let me know.

Thanks - Will

You can not save the database as is, you will still need the sql enine to read the information. The easiest way to store the information is to use the backup and restore functions.

To export the data to Access you will need to use SSIS (Sql Server Intergration Services), but if all you want to do is report off it using access why don't you just use the linked tables functions inside Access.

|||Thanks Glenn.

Any suggested reading material on the basics operating through SQL Server Management Stuido?

Save printer options

Hello,

I've a little problem with Visual Basic 6.0 and Crystal Report.

I must print different reports (from different files) with the same printer with the same options.

Unfortunately, the printer options gets reset when I change report. How can I save theses settings, or at least, tell the crystal engine not to reset them ? (It seams that the settings are stored as a part of the rpt file).

Thank you

LluudNot sure which settings you're referring to, but you should be able to declare a few variables and set them to the Printer options before you call you first report, then set the Printer options to the saved variables before you call your second report...|||I did this, but I can't save the printer's driver specific options.

I've resolved my problem by saving the report to the disk using saveas() and then print it with the Crystal Printing Engine API. I use windows' API to retrieve a DEVMODE structure that I can pass to the Printing Engine.

Thank you for you answer.

SAN expansion with Basic disks instead of Dynamic?

Hi all,
From what I've read, dynamic disks are not supported as shared drives
when using a Windows 2003 cluster, only basic disks.
What happens when you want to add more capacity to your cluster's shared
disk by adding more physical disks to the SAN? Will it work if the
shared disks are basic? I thought you needed to use dynamic disks to do
this?
thanks a lot,
alec
It is possible but it isn't easy. It also depends on how the manufacturer
presents the LUN to the OS.
How to Extend the Partition of a Cluster Shared Disk
http://support.microsoft.com/default...uct=winsvr2003
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alec Waters" <alec.waters@.NdatalineO.ScoP.AukM> wrote in message
news:4163fc8b$0$17588$afc38c87@.news.easynet.co.uk. ..
> Hi all,
> From what I've read, dynamic disks are not supported as shared drives
> when using a Windows 2003 cluster, only basic disks.
> What happens when you want to add more capacity to your cluster's shared
> disk by adding more physical disks to the SAN? Will it work if the
> shared disks are basic? I thought you needed to use dynamic disks to do
> this?
> thanks a lot,
> alec
> --
>