Print Page | Close Window

Runtime Installer

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3680
Printed Date: 20 Apr 2024 at 5:51am


Topic: Runtime Installer
Posted By: GHanosh
Subject: Runtime Installer
Date Posted: 11 Jul 2008 at 5:02am
Brian, plain and simple.....do you know how I might obtain a copy of a Crystal Reports XI runtime installer?  And/Or do you have documentation I could purchase that would teach me?  And/Or, would you be available to consult with me to produce one? 
 
I posted a query in the Technical forum.  To the best of my understanding, Crystal Reports XI permits runtime viewing of report files through an Office application on clients that do not have the designer installed.  I have downloaded the Crystal Reports 11 RDC merge modules before SAP changed everything, and created a windows installer package.  But as my Technical post indicates, my Office app fails to ".logonServerEx"
 
I am an owner of your Crystal Reports Book.  Loved it.  I look forward to hearing from you soon.
 
Thank you,
 
george


Replies:
Posted By: hilfy
Date Posted: 21 Jul 2008 at 1:44pm

The RDC is deprecated with Crystal XI and BO XI and it's going away with Crystal 2008 and BO XI 3.0.  It's being replaced by Crystal Server and the Report Application Server (RAS).

Have you tried downloading the Crystal merge modules from the BusinessObjects web site?  (I'm not sure if they're still there since all of the support stuff has been moved to the SAP support site, but you could do a search for them.)  It's an MSI file that can be installed.

 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: GHanosh
Date Posted: 21 Jul 2008 at 5:57pm
Thanks Dell,
 
Yes, I've downloaded all versions of the merge modules (9, 10, xi, release 2) and each one seems either not to work or I'm missing something in my calls to the CRAXDRT.  But I don't know what that could be - logonserver and logonserverex are pretty simple and it just doesn't work!  My client can't have Crystal XI designer on every box they will want to run a report.

Posted By: GHanosh
Date Posted: 26 Jul 2008 at 12:21pm
The RDC requires different logon under SQL Server than it does Oracle.  Here is the code for successful VBA logon to SQL Server.  This problem took two weeks out of my life; hope someone else can benefit.
 

Dim crwApplication As New CRAXDRT.Application

Dim crwReport As New CRAXDRT.Report

Dim crwSubReport As CRAXDRT.Report

Dim crwTables As CRAXDRT.DatabaseTables

Dim crwTable As CRAXDRT.DatabaseTable

Dim crwSections As CRAXDRT.Sections

Dim crwSection As CRAXDRT.Section

Dim crwReportObjects As CRAXDRT.ReportObjects

Dim crwSubReportObject As CRAXDRT.SubreportObject

 

    Set crwReport = crwApplication.OpenReport(searchrptno)

    For i = 1 To crwReport.Database.Tables.Count

        crwReport.Database.Tables(i).SetLogOnInfo strSQLDatabase, strSQLDatabase, "", ""

        tblLocation = strSQLDatabase & ".dbo." & crwReport.Database.Tables(i).Location

        crwReport.Database.Tables(i).Location = tblLocation

        If crwReport.Database.Tables(i).TestConnectivity Then

        End If

    Next i

    Set crwSections = crwReport.Sections

    For k = 1 To crwSections.Count

        Set crwSection = crwSections.Item(k)

        Set crwReportObjects = crwSection.ReportObjects

        For i = 1 To crwReportObjects.Count

            If crwReportObjects.Item(i).Kind = crSubreportObject Then

                Set crwSubReportObject = crwReportObjects.Item(i)

                Set crwSubReport = crwSubReportObject.OpenSubreport

                For j = 1 To crwSubReport.Database.Tables.Count

                    crwSubReport.Database.Tables(j).SetLogOnInfo strSQLDatabase, strSQLDatabase, "", ""

                    tblLocation = strSQLDatabase & ".dbo." & crwSubReport.Database.Tables(i).Location

                    crwSubReport.Database.Tables(i).Location = tblLocation

                    If crwSubReport.Database.Tables(i).TestConnectivity Then

                    End If

                Next j

            End If

        Next i

    Next k


Print Page | Close Window