Crystal XI, MySQL, Stored Procedure, VB.NET

[Former Member]

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

[Former Member · Accepted solution]

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