webapps30
-
Posts
3 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by webapps30
-
-
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.
-
I would like to use a Logged in User Profile Attribute in the report SQL. ( yes, another example of row-level security )
My initial test failed; just showing a User Profile Attribute in the title of a report. I believe you should create a Parameter for each attribute, which I did. But there was no way to define it, using the expression editor.
I've found a few things from the .pdf manual set, and reference links (many of which are old), which I will include. The topics are relevant, even if the links they reference are dead links.
btw - Where is the Jasper Reports API published ?
------ From the Server Admin Guide ------
4.4.2 Built-in Parameters for Query-based Input Controls
Table 4-1 Built-in Parameters for Query-based Input Controls
LoggedInUser ....
LoggedInUserAttribute_<attribute-name>
If there is no match, the parameter is empty.
This parameter is only available if it is defined in a query
or as a report parameter.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://community.jaspersoft.com/questions/541574/user-parameterhttp://community.jaspersoft.com/questions/523017/referencing-logged-user-attributes-sql
http://community.jaspersoft.com/questions/530433/how-use-looggedinuser-getting-role
http://community.jaspersoft.com/questions/532644/ireport-row-level-security
keywords API: Jasper Reports Library API IQueryManipulator
There are Parameter available which provide this data: ?? Old Post ??
http://community.jaspersoft.com/questions/532644/ireport-row-level-security
?? Old Post ?? No Replies
https://community.jaspersoft.com/questions/543844/getting-profile-attributes-ireport
keywords API: Jasper reports API MetadataUserDetails
http://community.jaspersoft.com/wiki/how-access-user-profile-attributes-report
Problems with table width, Table cell indents, padding, etc. when I publish to JRS
in Products
Posted
Table width specifications
and table cell indent (ex: rightIndent)
seem to be ignored when I publish to JRS ( jasper report server ) and view in the Report Viewer.
I'm trying to right align currency values, but don't want them hugging the right side of the table cell.
The preview, using Jasper Studio looks great, as expected; It just loses the settings when I publish. Any one have a solution ? TIA