kchavda Posted July 8, 2016 Share Posted July 8, 2016 Hello,I want to count the rows of my report using VIsualize.js. So that if rows < 1 then i can put "No Data Found" lable.I am not using table structure. I have many sub reports in my main report. Link to comment Share on other sites More sharing options...
dpetzold Posted July 10, 2016 Share Posted July 10, 2016 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: xExpression: $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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now