Solved: ReportDocument.ReadRecords() does not query for su...

Hello,

May I preface that I am a first time user of these libraries and have just started this project with very little knowledge or help, just some examples of what our business has done in the past.

I'm building my project around reportxml.txt (attached, can't upload the actual report so I converted it with RptToXML).

The report has 1 main report and 2 subreports. the main has no parameters, which I'm using ReportDocument.RecordSelectionFormula instead for. there are 4 linked parameters on the subgroups.

I've been able to set the ConnectionInfo and DbConnectionAttributes correctly for the main report and subreports, and the ReportDocument.ReadRecords method appears to query the DB at least once correctly, according to SQL Server Profiler.

That is where everything shuts down. It doesn't make any further queries and when I try and export a document, there is nothing in it. ReadRecords produces 0 ReportDocument.Rows.

The report comes from a system that is currently querying the DB and successfully producing a report when I use their interface. I've watched the Sql Server profiler and it appears to query 3 times (one for main, 2 subreport queries) when running a report in their interface.

EDIT: using SAP Crystal Reports version: 13.0.3501

Here is the code I am using:

		static void SetConn(ReportDocument doc, ConnectionInfo cinfo)
			{
			Tables tables = doc.Database.Tables;


			foreach (Table table in tables)
				{
				TableLogOnInfo tableLogonInfo = table.LogOnInfo;
				tableLogonInfo.ConnectionInfo = cinfo;
				table.ApplyLogOnInfo(tableLogonInfo);
				}


			if (!doc.IsSubreport)
				{
				foreach (ReportDocument theSub in doc.Subreports)
					SetConn(theSub, cinfo);
				}
			}


		static void Main(string[] args)
			{
				string file = "C:\\report.rpt";
				try
					{
					ReportDocument doc = null;
					ConnectionInfo cinfo = new ConnectionInfo();
					DbConnectionAttributes dbAttributes = new DbConnectionAttributes();
					cinfo.LogonProperties.Clear();
					cinfo.Attributes.Collection.Clear();


					dbAttributes.Collection.Set("Auto Translate", "-1");
					dbAttributes.Collection.Set("Connect Timeout", "15");
					dbAttributes.Collection.Set("Data Source", "<servername>");
					dbAttributes.Collection.Set("General Timeout", "0");
					dbAttributes.Collection.Set("Initial Catalog", "<dbname>");
					dbAttributes.Collection.Set("Integrated Security", false);
					dbAttributes.Collection.Set("Locale Identifier", "1033");
					dbAttributes.Collection.Set("OLE DB Services", "-5");
					dbAttributes.Collection.Set("Provider", "SQLOLEDB");
					dbAttributes.Collection.Set("Tag with column collation when possible", "0");
					dbAttributes.Collection.Set("Use DSN Default Properties", false);
					dbAttributes.Collection.Set("Use Encryption for Data", "0");


					cinfo.LogonProperties.Clear();
					cinfo.Attributes.Collection.Clear();
					cinfo.DatabaseName = "<dbname>";
					cinfo.ServerName = "<servername>";
					cinfo.UserID = "<username>";
					cinfo.Password = "<password>";
					cinfo.Attributes.Collection.Set("Database DLL", "crdb_ado.dll");
					cinfo.Attributes.Collection.Set("QE_DatabaseName", "<dbname>");
					cinfo.Attributes.Collection.Set("QE_DatabaseType", "OLE DB (ADO)");
					cinfo.Attributes.Collection.Set("QE_LogonProperties", dbAttributes);
					cinfo.Attributes.Collection.Set("QE_ServerDescription", "<servername>");
					cinfo.Attributes.Collection.Set("QE_SQLDB", true);
					cinfo.Attributes.Collection.Set("SSO Enabled", false);
					cinfo.LogonProperties = dbAttributes.Collection;


					doc = new ReportDocument();
					doc.Load(file);


					SetConn(doc, cinfo);
					doc.Refresh();


					doc.RecordSelectionFormula = "{person.person_id}='86A835D1-F85C-4EEB-82CC-43866414F490' AND {patient_encounter.enc_id}='98AA1E61-9334-4D9E-A3D0-36E041FBCA31'";


					doc.VerifyDatabase();
					doc.ReadRecords();
					int rowcnt = doc.Rows.Count;
					
					doc.ExportToDisk(ExportFormatType.PortableDocFormat, @"C:\DocTemp\" + DateTime.Now.ToString("yyyyMMddHHmm") + ".pdf");




					}
				catch (Exception ex)
					{
					}

			}

former_member11696 · ‎2020 Oct 23

Did you uninstall what ever previous version you had installed and replace all CR Assemblies with SP 29 and verify by looking a the properties of each assembly it's being loaded from the same location and same platform?

If all CR assemblies are x86 then you'll see this location for each dll.

C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet\CrystalDecisions.CrystalReports.Engine.dll

Check your references also, you should have all of these:

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using CrystalDecisions.ReportAppServer;
using CrystalDecisions.ReportAppServer.ClientDoc;
using CrystalDecisions.ReportAppServer.Controllers;
using CrystalDecisions.ReportAppServer.ReportDefModel;
using CrystalDecisions.ReportAppServer.CommonControls;
using CrystalDecisions.ReportAppServer.CommLayer;
using CrystalDecisions.ReportAppServer.CommonObjectModel;
using CrystalDecisions.ReportAppServer.ObjectFactory;
using CrystalDecisions.ReportAppServer.Prompting;
using CrystalDecisions.ReportAppServer.DataSetConversion;
using CrystalDecisions.ReportAppServer.DataDefModel;
using CrystalDecisions.ReportSource;
using CrystalDecisions.Windows.Forms;
using CrystalDecisions.ReportAppServer.XmlSerialize;

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My SAP Profile

My SAP Profile

Know the answer?

Need more details?