<div>
Perhaps it's because the SP returns the count of records.<br />
If this is SQL Server, use <b>SET NOCOUNT ON</b> in the SP definition.<br />
If this is a different DBMS, look for a similar option.
</div>


Perhaps it's because the SP returns the count of records.
If this is SQL Server, use SET NOCOUNT ON in the SP definition.
If this is a different DBMS, look for a similar option.

<div>
I tried that but same result... &nbsp;It just seems that since nothing is being return, it still tries to map the expected data.
</div>


I tried that but same result...  It just seems that since nothing is being return, it still tries to map the expected data.

MTL999

<div>
Thank You ! &nbsp; &nbsp;I did a select top 1 col1, col2 from tablea where 1 = 2. &nbsp;That did the trick. &nbsp;It returned the row header without rows..
</div>


Thank You !    I did a select top 1 col1, col2 from tablea where 1 = 2.  That did the trick.  It returned the row header without rows..

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a subreport that is using a sql server stored procedure as its source. &nbsp; When the sp returns data, the report works fine. &nbsp;If it has no data to return, the report fails with the message below.<br />
How do I get around that ? &nbsp;I tried page suppression via section expert but without any luck. &nbsp;<br />
<br />
<br />
Error - ExportReportToDisk: One or more fields could not be found in the result set. &nbsp;Use Verify Database to update the report.<br />
Failed to export the report.<br />
<br />
Error in File brm_ecn 4224_5880_{0A81305B-6030-4<wbr />6E1-8C30-8<wbr />C35C1AB446<wbr />4}.rpt:<br />
The rowset column could not be found.<br />
<br />
Cheers<br />
Bruno Campoli
</div>
</div>


Hello,

I have a subreport that is using a sql server stored procedure as its source.   When the sp returns data, the report works fine.  If it has no data to return, the report fails with the message below.
How do I get around that ?  I tried page suppression via section expert but without any luck.  


Error - ExportReportToDisk: One or more fields could not be found in the result set.  Use Verify Database to update the report.
Failed to export the report.

Error in File brm_ecn 4224_5880_{0A81305B-6030-46E1-8C30-8C35C1AB4464}.rpt:
The rowset column could not be found.

Cheers
Bruno Campoli

Subreport fails when its stored procedure does not return any data, otherwise ok

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.