<div>
<div class="content wysiwyg-content">
Ok, my turn to post something. :)<br />
<br />
For those of you familiar with the Java SDK, I was hoping you might be able to answer this question.<br />
Through the SDK can apply a filter to a report instance?<br />
We need row level security on instances, and on demand reports for the few people who have the rights, based upon a security table. &nbsp;A users rights can change daily.<br />
If we use Business Views, we can tie into the table, but a user will only be able see data in the reprt based upon the rights that they had at the time the report was generated.<br />
We also have way to many users and roles that would make administering Business Views a nightmare.<br />
Anyway, my thought was that if we could schedule the report, and then whenever it is viewed, we could read the scurity table, determine what data they should see, and then filter the SAVED DATA accordingly. &nbsp;I know we can get this functionality with on demand reports, but the requirement is for instances.<br />
So, any information that you can provide would be very helpful.
</div>
</div>


Ok, my turn to post something. :)

For those of you familiar with the Java SDK, I was hoping you might be able to answer this question.
Through the SDK can apply a filter to a report instance?
We need row level security on instances, and on demand reports for the few people who have the rights, based upon a security table.  A users rights can change daily.
If we use Business Views, we can tie into the table, but a user will only be able see data in the reprt based upon the rights that they had at the time the report was generated.
We also have way to many users and roles that would make administering Business Views a nightmare.
Anyway, my thought was that if we could schedule the report, and then whenever it is viewed, we could read the scurity table, determine what data they should see, and then filter the SAVED DATA accordingly.  I know we can get this functionality with on demand reports, but the requirement is for instances.
So, any information that you can provide would be very helpful.

Business Objects Enterprise XI R2 Java SDK

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.