I created a Datasource conected to the mdb server, his conection works and i can retrieve all the tables, but some fields does not appear.
For example in call_req does not appear assigned, or costumer or any fields that had a relation with other table.
By the look of that listing, I'd say you have created a datasource accessing the MDB database using a MS-SQL JDBC driver. In order to access linked fields without doing a lot of manual configuration, you need to create an SDM datasource using the SDM OpenAccess driver, which interfaces with the SDM object layer rather than going directly to the underlying database. Please review the steps listed here: Install and Configure CABI JasperReports Server r6.2.0 for CA Service Management - CA Service Management - 14.1 - CA Tec… and specifically Step 3 - Configure CABI JasperReports Server for CA SDM.
I'd also suggest that you consider upgrading from CABI 6.2 to a more recent release.
Hope that helps... If you're still having problems please get back to us.
Thanks for the reply.
I had a datasource with the SDM OpenAccess drive, and it datasource retrieve objects from the SDM object layer.
But it datasource does not filtering date time fields, in fact before it did not retrieve date fields, so i found a modification to the file.\jasperserver-pro\WEB-INF\applicationContext-semanticLayer.xml file. described on another post of the community. But even with this modification the date fields cannot be filtering in dashboards, so i want to connect directly to the mdb for achieve this filtering.
The target is filter datetime fields in dashboards.
If you're connecting to the MDB, it might be easier to create a SQL View and then use that to create the domain, otherwise you need to set up all the Joins in Jaspersoft. Here is an example (sorry for the long reply).
Steps would be:
1. Create a SQL View that has the data you need. (I can send you an example if you need one, let me know)
2. Use the SQL View to create a domain.
The following url documents how to create a SQL datasource in CABI:
Launch CABI: http://yourserver:port/jasperserver-pro/login.html
Login with: superuser/<password>
Select Create under Data Sources
Complete the fields as noted below.
For MS SQL Server, define the following datasource details:
Test the connection, save the datasource, and give it a name.
3. Now create the domain
Select Create under Domains
Name : CR_SQL_Domain
Description: SQL View Domain
Save Location: /organizations/servicemanagement/capability/domains
Select your data source
Select dbo, and OK
In the Data Source pane, scroll down to dbo_View_SDM_Tickets_JS
Select the Add button to bring it over to the right
(Optional Step) Select Calculated Fields tab
Field Name: Ticket_Count
Expression: count(dbo_View_ SDM_Tickets_JS.Ticket_Num)
Click Save Field
Select the Display tab, and add any or all fields to your Domain
Now test your domain.
Great post! i'll work on it, thanks!