Advertisement

05.19.2008 at 09:40AM PDT, ID: 23414335
[x]
Attachment Details

Accessing DSN properties from a Crystal Report using VBA via RDC

Asked by rabroersma in Crystal Reports Software, Access Coding/Macros

Tags: Crystal Report RDC (Report Designer Component) VBA, CRAXDRT V.11 MS-Access 2003

I have a working crystal reports viewer embedding in an access form.

I would like to store the DSN connection Property for an opened crystal report into an ACCESS table.  Is there a way via code to access the DSN connection string used by a crystal report to connect to a back-end database?

Background:  I see that there is a way to change an opened reports data-set by first clearing the current data set and then passing it a new ADO record-set.  To achieve this automatically, I would like to get the connection information for the report and use it for the ADO record-set to pass a different set of data.Start Free Trial
[+][-]05.19.2008 at 05:21PM PDT, ID: 21602602

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Crystal Reports Software, Access Coding/Macros
Tags: Crystal Report RDC (Report Designer Component) VBA, CRAXDRT V.11 MS-Access 2003
Sign Up Now!
Solution Provided By: mlmcc
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628