Skip to Content
avatar image
Former Member

Crystal XI, MySQL, Stored Procedure, VB.NET

I'm using the "PULL MODE" to print Crystal Reports from VB.NET 2003 (letting the REPORT read the data / NOT doing the "select" in the VB...). If I only have one level of data in the report and read the TABLES directly into the report, they work fine using the "ApplyLogonInfo" method for pointing the report tables to the datasource. Subreports work fine using that, too, if the TABLES are the top-level data source.

BUT if the primary datasource of the report is a MySQL STORED PROCEDURE (with or without a parameter), I do NOT know how to assign the datasource to the procedure. There is no "PROC" or "STOREDPROC" or anything like that in the

CrystalDecisions.Shared.ReportObjectKind.??? to set the login for?

Anyone have any sample code to set the data source or logininfo for a STORED PROCEDURE??

Anything similar to :

"For Each tbCurrent In myReport.Database.Tables"

for procs??

Thanks, much - it's probably right there and I'm just not seeing it 😊

Robert

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2008 at 01:45 PM

    Ho Robert

    Please post your query in the SDK development forum.

    Follow the link below:

    https://www.sdn.sap.com/irj/sdn/businessobjects-sdk-forums

    Thanks

    Add comment
    10|10000 characters needed characters exceeded