Jump to content
Changes to the Jaspersoft community edition download ×

Recommended Posts

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Thanks for help me yurab.


Currently I have this JasperServer version:

Product Version: 4.7.0

Build: 20120815_1737


But the parameter is ignored or something else, We are using the same report for 2 different databases.


I'm sending the parameters like this...




I'm using a PHP Library and PARAM_XXX is required for this lib. Everything works only the REPORT_CONNECTION it doesn't.


Thanks for your help


Best regards,

Oscar Romero

Link to comment
Share on other sites

Thanks for help me yurab.


Finally I've found a different solution, Is quite strange. I'm sending a DataSourceID parameter...


And In SQL Editor something like this




SET @iDSNumber = $P{DataSourceNumber}


IF @iDSNumber = 1

SET @cDBName = 'Contoso'


SET @cDBName = 'Fabrikam'


EXEC (@cDBName + '.dbo.Procedure ' + '[' + @cCustName + '], ' + @iCountry)

Link to comment
Share on other sites

  • 2 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...