Kinetic Report with direct SQL subreport - On Prem

Kinetic ERP
, ,
1

I have an Aged Receivables report which originates from a copied data definition within Kinetic, a subreport was added to include some extra information based on the customer contact.
The subreport is a direct query to the SQL server and is called into the main report using CustID field, to get the rdl for the subreport into Kinetic i took both reports from SSRS and uploaded them against the report style.
I changed the path to the subreport to remove all except the report name, however, when I run the report the area for the subreport says ‘Error: the subreport could not be shown’

Is it still possible to use a direct SQL query subreport now the rdl’s are stored in Kinetic? I am not sure if this is what is causing the issue, any ideas?

2

Personally I’d avoid doing any direct SQL queries in SSRS. I’d add the needed data to the Report Data Definition (RDD) and rebuild the subreport.

3 Likes
3

As Randy said, I’d avoid that. Do a BAQ to get the data and dump it into your RDD.

1 Like