webapps30 Posted May 20, 2014 Share Posted May 20, 2014 I am trying to print the Top 10 rows from my subDataset in a table (which is in the Summary band). There is no other meaningful content.example expression (used in the reportElement tag just abouve the table tag):$V{REPORT_COUNT} < 10 I'm having some trouble with it, using it with a table. I've found that I can use this expression effectively to limit rows of the main dataset & query. Works great.I can even use $V{REPORT_COUNT} if I want to add an extra column to the table, and it prints out fine: 1 2 3 ... Since I didn't want any repeating record issues, and this is intended to be short, I'm putting the table into the Summary band, and it uses a subDataset.This seems like the most straightforward way to do this, but I must be missing something.Any tips, or suggestions on this, would be appreciated. Link to comment Share on other sites More sharing options...
nash.seq Posted May 20, 2014 Share Posted May 20, 2014 Why not just modify your dataset query to include where rownum <= 10 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