ReportServer Forum

palacio

Member

Registered: 2018-06-27

Working with parameter????

Hi all,

I'm new to ReportServer.

I built my jasperreports report with Parameter and it works well.
Now I wanted to run the same report on ReportServer and it does not work (it sends me a blank page without data)

NB: I created the necessary parameters with the same class as that of jasper.

What is the problem please !!!!!!

Version: bitnami-reportserver-3.0.3-2-linux

jalbrecht

Administrator

Registered: 2016-10-21

Re: Working with parameter????

Dear palacio,

pls check: https://reportserver.net/en/guides/admi … erReports/

In ReportServer you have to additionally configure all parameters entered in the report by the parameter management (tab at the bottom of the screen). Here, ReportServer will support you by automatically creating parameters from the master report. This function can be activated via the Suggest parameter button in the tool bar. We note that the automatic extraction of parameters is rudimentary and for may need manual adjustments for more complex parameter settings. The configuration of the parameters is otherwise identical to the configuration of dynamic list parameters.

happy reporting !

wbr jan

palacio

Member

Registered: 2018-06-27

Re: Working with parameter????

Dear palacio,

pls check: https://reportserver.net/en/guides/admi … erReports/

In ReportServer you have to additionally configure all parameters entered in the report by the parameter management (tab at the bottom of the screen). Here, ReportServer will support you by automatically creating parameters from the master report. This function can be activated via the Suggest parameter button in the tool bar. We note that the automatic extraction of parameters is rudimentary and for may need manual adjustments for more complex parameter settings. The configuration of the parameters is otherwise identical to the configuration of dynamic list parameters.

happy reporting !

wbr jan

OK @jalbrecht
Let me see and come to you after.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Working with parameter????

Hi palacio,

"NB: I created the necessary parameters with the same class as that of jasper."
What parameter type are you using? Could you post some screenshots?
Try to create a simple jasper report using a similar parameter but deleting everything else. When you have complex reports the problem may be not completely straightforward.

Regards,
Eduardo

palacio

Member

Registered: 2018-06-27

Re: Working with parameter????

Hi palacio,

"NB: I created the necessary parameters with the same class as that of jasper."
What parameter type are you using? Could you post some screenshots?
Try to create a simple jasper report using a similar parameter but deleting everything else. When you have complex reports the problem may be not completely straightforward.

Regards,
Eduardo

After many test I still have lot of problem,

May main reprot have 8 parameters: integer type(4), string(2) and date(2)

It don't work when I test. It show me blank space without data.
But, when I delete all parameter and use only one (integer type), it work good.

Test with 3 parameters: 1 integer and 2 date don't work!!! Why???

That's what I write in my sql code: AND os.dateinvoiced::date BETWEEN ($P{Inv_DateFrom}::date AND $P{Inv_DateTo}::date)

Regards,

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Working with parameter????

Hi palacio,

can you post a *minimal* jasper report which doesn't work and the table definition? What DB are you using ?

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Working with parameter????

Hi palacio,

check out the tomcat logs. You should get an error there.

Regards,
Eduardo

palacio

Member

Registered: 2018-06-27

Re: Working with parameter????

Hi palacio,

can you post a *minimal* jasper report which doesn't work and the table definition? What DB are you using ?

Regards,
Eduardo

I use PostgreSQL