BaBernd
12th October 2015, 13:00
Hello to All,

I've created a Report with a Sub Report in SSRS/BIDS for INFOR LN.
I've first try to get the Sub Report to run. In the BIDS it is running well.
The Sub Report fetches values out of a external data source "PCM" to an MS SQL-Server. The normal Infor data source "LN" I've also attached but is not necessary. (See Screenshot).
With the Infor ES Report Configurator I prepared the subreport for development. After design I prepared vor deployment an all values as mentioned in the ES Report Configuratior Manual are set as described.

But when I start the Sub Report in the Report Server Portal (2nd Screenshot) I've got the error:
"jca_uri Parameter is missing a value".

Can you help me for configuring the correct jca_uri Parameter?

Best Regards
Bernd

JaapJD
12th October 2015, 14:06
Because your subreport is not connected to an LN report data source, you should not convert it to a subreport with the LN configurator or manually add the jca_uri, etc.. If you remove those parameters except for the ones you need to access the external data (Firma, ProdId) and deploy again, it will work.

BaBernd
12th October 2015, 15:35
Hi Jaap,

thanks a lot. That was the solution!
I've deleted all Parameters from the Infor ES Report Conigurator and afterwards the Sub Report is running on the SQL Report Server Portal Website.

Best Regards,
Bernd