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...

http://

localhost/doreport.php?uri=/reports/customers/s04&PARAM_dm=0&format=PDF&PARAM_REPORT_CONNECTION=DATA_SOURCE_NAME

 

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

DECLARE @cDBName VARCHAR(100)

DECLARE @iDSNumber INTEGER

 

SET @iDSNumber = $P{DataSourceNumber}

 

IF @iDSNumber = 1

SET @cDBName = 'Contoso'

ELSE

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...