How to use Attribute_<attribute-name> in a jasper report

[vipatil]

Hello,

 

I have created a sample report to fetch few columns using the query

SELECT * FROM dbo.XYZ
WHERE RetailerID = $P{Attribute_RetailerID}

I have created a server attribute as RetailerID on jasperserver and when I execute the report, I just get a blank sheet.

Please help.

 

 

[Scott Andersen]

In order to connect the attributes to the report you need to define a parameter at the report level "Attribute_RetailerID". That parameter should "Is For Prompting" unchecked.