locked
BUG : Crystal report with a dynamic dataset RRS feed

  • Question

  • User595697674 posted

     ------------------------------------

    running with:

    APS.NET 2.0 VB.Net 2005

    oracle 8i

    Crystal Report XI

    ---------------------------------

    Hello,

            I'm migrating an old vb6 application generating many crystal reports to ASP.NET and I have an error I cant figure out.

    I want to generate a crystal report with parameters passed down by the client using dowpdown list, so I dont use the parameter fields.

     

    I created a dataset file (.xsd .xss) from my oracle database and build my crystal report with it.

    Then, in my form's codefile, I get a dataset with a SQL query string tuned up with the parameters passed by the client. To merge the report with it.

    I get this error:

                                                         The object's reference isnt defined at an instance of the object.

    Logon failed. Details: crdb_adoplus : La référence d'objet n'est pas définie à une instance d'un objet. Error in File C:\DOCUME~1\glauzier\LOCALS~1\Temp\venteclient {550D8876-B3B6-4C76-BDE4-AAD209F2C636}.rpt: Unable to connect: incorrect log on parameters.

    the bug occurs at this line :

    <code>

    CrTable.Location = "ShemaName." & CrTable.Location.Substring(CrTable.Location.LastIndexOf(".") + 1)

    </code>

    on the following code:

    <code>

    Dim crtableLogoninfos As New TableLogOnInfos()

    Dim crtableLogoninfo As New TableLogOnInfo()

    Dim crConnectionInfo As New ConnectionInfo()

    Dim CrTables As Tables

    Dim CrTable As Table Dim reportdoc As New ReportDocument

    Dim reportPath As String

    Dim reportName As String

    reportName = "venteclient.rpt"

    reportPath = Server.MapPath("~/Ventes/" & reportName)

    reportdoc.Load(reportPath)

    With crConnectionInfo

    .ServerName = "SERVERNAME"

    .DatabaseName = ""

    .UserID = "USERID"

    .Password = "PASSWORD"

    End With

    CrTables = reportdoc.Database.Tables

    For Each CrTable In CrTables

    crtableLogoninfo = CrTable.LogOnInfo

    crtableLogoninfo.ConnectionInfo = crConnectionInfo

    CrTable.ApplyLogOnInfo(crtableLogoninfo)

    CrTable.Location =
    "ShemaName." & CrTable.Location.Substring(CrTable.Location.LastIndexOf(".") + 1)

    Next

    </code>

    If I just show the original report, I get the same error message.

    I belived my code was ok.....any help woulb be great

    Thank you

            Kotor2000

           

    Thursday, May 17, 2007 12:55 PM

All replies

  • User619082048 posted

    Hi,


    I have the same problem.


    Have u find any solution for the same.


    Thanks,

    Jay Dixit

    Wednesday, June 23, 2010 2:12 AM