C#: El famoso login y contraseña de crystal report

[jcalcalde]

hola ManuelV

te paso un codigo en visual basic 2005 no conozco C pero no creo que sea muy distinto por lo menos en esto

Código:

Imports CrystalDecisions.CrystalReports
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportSource
Imports CrystalDecisions.Shared
Imports CrystalDecisions.Windows

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim ireport As New ReportDocument()
        Dim iConnectionInfo As ConnectionInfo = New ConnectionInfo()


        ' *****************************************************************************************************************
        ' configuro el acceso a la base de datos
        ' *****************************************************************************************************************
        iConnectionInfo.DatabaseName = "base_de_datos"
        iConnectionInfo.UserID = "usuario"
        iConnectionInfo.Password = "password"
        iConnectionInfo.ServerName = "servidor"

        iConnectionInfo.Type = ConnectionInfoType.SQL


        ireport.Load("H:\jalcalde\informe1.rpt")
        SetDBLogonForReport(iConnectionInfo, ireport)

         Me.CrystalReportViewer1.ReportSource = ireport


    End Sub

    Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo, ByVal myReportDocument As ReportDocument)
        Dim myTables As Tables = myReportDocument.Database.Tables
        For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables
            Dim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo
            myTableLogonInfo.ConnectionInfo = myConnectionInfo
            myTable.ApplyLogOnInfo(myTableLogonInfo)
        Next
    End Sub

Bueno espero que te sirva, yo tambien di muchas vueltas hasta que lo logre

Juan carlos