Crystal Reports 10 with D7 -- Changing BDE/Px filename/path at runtime with Connection Properties!

From: Tom (none_at_none.com)
Date: 01/27/05

  • Next message: Nic Roche: "Add resource to exe by end user?" 
    Date: Thu, 27 Jan 2005 12:09:58 -0800

    We're trying to use the Crystal Reports 10 RDC (CRAXDRT) with D7.

    We able to load and print reports, change formulas. But, we've been unable
    to figure out how to access the Connections Property to change table names
    or paths.

    We can see the Location property in IDatabaseTable, but assignments don't
    stick to it. (Maybe because it's a WideString?) The Location property is
    deprecated anyway by Business Objects, so we think we should be doing
    something like this:

    IReport.DataBase.Tables[1].ConnectionProperties.Item['Database Name'] :=
    'C:\foldername';
    Report.DataBase.Tables[1].ConnectionProperties.Item['TableName'] :=
    'PxTable.db';

    However, ConnectionProperties is of type INameValuePairs and we can't figure
    out how to access the ConnectionProperties.NameIDs to see what the proper
    Item name to refer to is. The NameIDs variable is an OleVariant containing
    OleStrVariants.

    Is anyone here doing this?

    Also, is anyone using D2005 with Crystal? How well integrated is it. Do you
    still have to reverse engineer the CRAXDRT_TLB that's created from the
    ActiveX component, or is there good documentation and API.

  • Next message: Nic Roche: "Add resource to exe by end user?"