Jump to content
Changes to the Jaspersoft community edition download ×

How to count rows of report using visualize.js

Recommended Posts

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

You may want to try passing total row numbers with $V{REPORT_COUNT}. If this is translated into a passable parameter within Studio then it could be used within the Visualize.js framework to indicate the row count. Keep in mind that the variable scope starts after the query has been executed.

If you can pass your calculation variable into a paramater it can then be easily passed into Visualize.js. In fact if you are only trying to discover if rows < 1 you can first do this calculation in a report variable and then pass a boolean paramater through Visualize.js to help aregister if the report has actual data.

Perhaps something like this two step process will work to pass values from main report variables to a sub dataset through paramaters.

1) Create a paramater ($P{x}) in your sub dataset with the same data type as the variable ($V{y}) data type you want to pass.

2) In the report component (table, list, charts, etc) using the sub dataset, add the paramater in the sub dataset to pass the values $V{y} through $P{x}.

Parameter: x

Expression: $V{y}

This will pass variable y to the sub dataset through its paramater x at run time when the report component is called.


Link to comment
Share on other sites

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