Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal XI, MySQL, VB.NET, Stored Procedures

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
Not what you were looking for? View more on this topic or Ask a question