Crystal Report Java
Tordis Hurrle
I was able to export directly to xlsx using the JAR files provided on the crystal reports web site: Crystal reports SAP , after downloading the crystal report viewer, I added some jars in the folders under: ..\Crystal Reports Viewer\SAP Crystal Reports viewer\plugins and using those jars I was able to export with:
Parameters:data - the java.sql.ResultSet object to be addedThrows:ReportSDKExceptionaddDataSourcepublic void addDataSource(IDataSet newDataSet) throws ReportSDKException Adds a IDataSet as a data source for the report. To set a runtime data source into a report, the report must be created with a data source using Crystal Reports, or added to the report using this, or one of the other three add methods. Set the data source in the report using the setDataSource method.
Parameters:newDataSet - the IDataSet object to be addedThrows:ReportSDKExceptionaddDataSourcepublic void addDataSource(java.util.Collection domainData, java.lang.Class domainClass) throws ReportSDKExceptionFor internal use onlyThrows:ReportSDKExceptionaddDataSourcepublic void addDataSource(java.util.Collection domainData, java.lang.Class domainClass, java.lang.String dataSourceName) throws ReportSDKExceptionFor internal use onlyThrows:ReportSDKExceptionaddDataSourcepublic void addDataSource(java.lang.Object newDataSource) throws ReportSDKException Adds a new data source to the report. To set a runtime data source into a report, the report must be created with a data source using Crystal Reports, or added to the report using this, or one of the other three add methods. Set the data source in the report using the setDataSource method.
Parameters:newDataSource - the object to be added. Can be a DataSet, java.sql.ResultSet, IXMLDataSet, or BusinessView object.Throws:ReportSDKExceptionaddDataSourcepublic void addDataSource(IXMLDataSet newDataSet) throws ReportSDKException Adds an IXMLDataSet as a data source for the report. To set a runtime data source into a report, the report must be created with a data source using Crystal Reports, or added to the report using this, or one of the other three add methods. Set the data source in the report using the setDataSource method.
Parameters:newDataSet - the IXMLDataSet object to be addedThrows:ReportSDKExceptionaddTablepublic void addTable(ITable table, TableLinks relatedTableLinks) throws ReportSDKException Adds a new table from the data source to the report. This method does not place any fields on the report itself. Rather, it makes the table available for selection by the user. Therefore, to add the table, the ConnectionInfo must be correct, but the fields do not have to be specified.
Parameters:table - The new table to be added. If the table you are adding to the report requires logon information, and this logon information has not been set, this method will fail.relatedTableLinks - An ITableLinks object that represents how tables are linked in the report.Throws:ReportSDKExceptionSee Also:Setting ConnectionInfoaddTablepublic void addTable(ITable table, TableJoins relatedTableJoins) throws ReportSDKExceptionFor internal use onlyThrows:ReportSDKExceptionaddTableLinkpublic void addTableLink(ITableLink tableLink) throws ReportSDKException Adds one or more links between two tables. Note: If the table link you are adding to the report requires logon information, and this logon information has not been set, this method will fail. See the setConnectionInfos method.
Parameters:tableLink - The ITableLink object that specifies how the two tables should be linked.Throws:ReportSDKExceptionaddTableJoinpublic void addTableJoin(ITableJoin tableJoin) throws ReportSDKExceptionFor internal use onlyThrows:ReportSDKExceptioncanExecuteSQLpublic boolean canExecuteSQL() Returns true if the database supports SQL, and false otherwise. This method returns true only if all connections are SQL executable.
Returns:true if the database supports SQL, and false otherwise.doSmartLinkingpublic void doSmartLinking() throws ReportSDKException Attempts to automatically link the tables in the report using TableLink objects. Smart linking is attempted by Name and then by Type only.
Throws:ReportSDKExceptiongetConnectionInfospublic ConnectionInfos getConnectionInfos(PropertyBag promptProperties) throws ReportSDKException Returns the collection of all database logons that exist in a report. This method returns logon information for both reports and subreports. You can obtain similar information using the getConnectionInfo() method in the Table object; however, this method does not return the logon information for subreports.
Logon information must be set using the modifyTableConnectionInfo method or the setConnectionInfos method. The setConnectionInfos method handles subreports, whereas the modifyTableConnectionsInfos does not.
As of version 11, managed RAS will respect the custom database logon settings specified in the Central Management Console (CMC). For example:
- Create a report and set the ConnectionInfo property to a test database.
- Publish the report to the CMS and configure the custom database logon information in the CMC to use a production database without modifying the original report.
- Use the ReportClientDocument.Open method to open the report on the RAS.
- The database connection information will be the custom database logon information that was specified in the CMC. RAS has respected the CMC custom database logon settings.
In most cases, the database connection information that is returned is the most recent database connection information. But if a report that is saved with data is published to the CMC, the RAS returns the database logon settings that belong to the saved data, rather than the custom database logon settings that were published to the CMC.
CMC database connection settings are applied when the saved data is regenerated automatically when, for example, a parameter value is changed, the report data is refreshed, a new field is added or referenced in the report, and so on.
Parameters:promptProperties - Information about the database logons and parameter prompts that are to be returned when the user makes a request to view a report or subreport.Returns:A ConnectionInfos object containing a collection of all database logons that exist in a report.Throws:ReportSDKExceptionSee Also:setConnectionInfosgetDatabasepublic IDatabase getDatabase() Returns the tables and fields available in the report. Note, to modify any database property, you must use the methods in the DatabaseController object. These methods also allow you to add and remove tables or fields.
Returns:An IDatabase object containing the tables and fields available in the report.getBlobFieldImageAttributespublic BlobFieldImageAttributes getBlobFieldImageAttributes(IDBField dbField) throws ReportSDKExceptionFor internal use only.Throws:ReportSDKExceptionlogonpublic void logon(java.lang.String sUser, java.lang.String sPassword) throws ReportSDKException Sets all of the tables in the report with a specified user name and password. This is a helper function that applies logon information to all of the database connections used in the report; use this method instead of setting the ConnectionInfo for each.
Parameters:sUser - the user namesPassword - the passwordThrows:ReportSDKExceptionlogonpublic void logon(IConnectionInfo connectionInfo, java.lang.String sUser, java.lang.String sPassWord) throws ReportSDKExceptionFor internal use onlyThrows:ReportSDKExceptionlogonExpublic void logonEx(java.lang.String sServerName, java.lang.String sDatabaseName, java.lang.String sUser, java.lang.String sPassword) throws ReportSDKException Sets the user and password on the specified server and database.
Parameters:sServerName - the name of the server on which the user and password is setsDatabaseName - the name of the database on the specified serversUser - the user name to be set on the serversPassword - the password to be set on the serverThrows:ReportSDKExceptionmodifyFieldHeadingpublic void modifyFieldHeading(IDBField dbField, java.lang.String newFieldHeadingText) throws ReportSDKException Modifies a field's heading. If the field has already been added to the report, changes to this value will not update the column heading in the report. To change a field heading that already appears in the report, you must remove the field, modify the field heading, and then re-add the field.
Parameters:dbField - The field whose field heading is modified. The field can be obtained by using the getDatabase method in the DatabaseController object, DataDefController object, or ReportClientDocument object.newFieldHeadingText - The new text for the heading.Throws:ReportSDKExceptionmodifyTableAliaspublic void modifyTableAlias(ITable table, java.lang.String newTableAlias) throws ReportSDKException Modifies the table's alias.
Database names and locations often change. If you create a report and then change the name or location of a table or file, the Report Application Server must be able to find the new name or location. This is especially important when you create formulas in your report that access a table that has been renamed or moved. Fixing the reference for a single field is not difficult, but to find every formula that uses that field can be a difficult and time-consuming task.
To solve this problem, the Report Application Server uses aliases to refer to database tables and files. An alias is a string that serves as a unique identifier for a table. If you change the name or location of the database, the name of the alias does not change, so your formulas are not affected. The Report Application Server looks to the alias for the location and name of the database, goes to the new location for the database field, and executes the formula.
4a15465005