crystal reports 2016: merge data across two (BTrieve) databases

[imgodot]

We are trying to rewrite an ancient CR 8.5 report that merges data from two BTrieve databases and it works fine, but we need to convert it to CR 2016. 

The old report used a table of "months" as the main table and that table is joined to each of the two "real" data tables, which are transactions (TRX).  One of the TRX tables resides in the same database as the "months" table and the other TRX table resides in the other database. With this structure, the report doesn't complain about "More than one datasource has been used in this report."   

However, we cannot get the same functionality in CR 2016 when going against BTrieve data. It always complains about "more than one datasource" and the data returned is a cartesian product.

We can create stored procedures and views in the BTrieve database that gives us the data using a UNION (SQL), but the BTrieve driver in CR 2016 does not allow access to stored procedures or views (sigh).

Anyone, have any ideas on a solution/workaround?

NOTE:  The application that performs all the processing and drives the reports does not use ODBC which does allow access to stored procedures and views in BTrieve files.

Thanks.     -- Paul

SAP Crystal Reports 

[DonWilliams]

Hi Paul,

History lesson time...lol

Back in CR 8.5 days Pervasive managed the Native Btrieve CR database client dll. I don't recall when but at some point Pervasive sent the source code back to CR because they no longer wanted to maintain it.

SAP Developers did not want to either and focused on their ODBC Client.

So for simple links use the Native Btrieve ddf data source, for more complex structures as you noted use the ODBC Client.

SAP has no inkling to update the name client due to not many people use it, or at least reported to SAP.

I don't recall the last case SAP had for Btrieve, and I retired 2 years ago after 26 years of supporting Crystal Reports and focused on Pervasive...

Don

[msundararaja_perumal]

Dear@imgodot ,

Under Report options, enable the option 'Perform Grouping on Server'.

This should ignore the warning message in crystal report.

Thanks.

[imgodot]

Thanks for the response. I noted the warning message just for background. It is not a problem, because it doesn't prevent the report from running. Also, the server grouping option is grayed-out, I presume because it is not applicable with BTrieve data.