Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Runtime Installer Post Reply Post New Topic
Author Message
GHanosh
Newbie
Newbie
Avatar

Joined: 10 Jul 2008
Online Status: Offline
Posts: 10
Quote GHanosh Replybullet Topic: Runtime Installer
    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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3639
Quote hilfy Replybullet 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
9-Time SAP BusinessObjects Partner of the Year.
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
GHanosh
Newbie
Newbie
Avatar

Joined: 10 Jul 2008
Online Status: Offline
Posts: 10
Quote GHanosh Replybullet 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.
IP IP Logged
GHanosh
Newbie
Newbie
Avatar

Joined: 10 Jul 2008
Online Status: Offline
Posts: 10
Quote GHanosh Replybullet 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

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.