Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Go Back  Xtreme Visual Basic Talk > > > Loop Through SAP Crystal Reports Subreports


Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2013, 06:44 AM
mrkamran's Avatar
mrkamran mrkamran is offline
Centurion
 
Join Date: Jun 2003
Posts: 188
Question Loop Through SAP Crystal Reports Subreports


Hi,

I have report opening problems in those reports which have subreports when i change server name. All other reports without subreports are working fine even i change server name, user id or password. Actually subreports did not find connectioninfo. I want to loop through all subreports in a report and want to pass connectioninfo object. I am using following code to open report:

Code:
 Private Sub SetDBLogonForReport(connectionInfo As ConnectionInfo, reportDocument As ReportDocument)
        Dim tables As Tables = reportDocument.Database.Tables
        For Each table As CrystalDecisions.CrystalReports.Engine.Table In tables
            Dim tableLogonInfo As tableLogOnInfo = table.LogOnInfo
            tableLogonInfo.ConnectionInfo = connectionInfo
            table.ApplyLogOnInfo(tableLogonInfo)
        Next
    End Sub

'---- Print Button click event ----

Dim objRpt As New ReportDocument
objRpt.FileName = RepPath & RepModule & "\Reports\" & RepName

Dim ConnInfo As New ConnectionInfo

ConnInfo.ServerName = dbServer
ConnInfo.DatabaseName = dbName
ConnInfo.UserID = dbUser
ConnInfo.Password = dbPass

SetDBLogonForReport(ConnInfo, objRpt)

objRpt.SetDataSource(DataSet.Tables(0))
CRViewer.ReportSource = objRpt
CRViewer.Refresh()

Thanks
__________________
Thoughts determine what you want...Action determines what you get!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
 
Loop Through SAP Crystal Reports Subreports
Loop Through SAP Crystal Reports Subreports
 
-->