Actuate Spreed Sheet - Connect and Configure Database

As i mentioned in the earlier post and open .vts file.

Step 1:

Click "Data Manager" in Data menu

Step 2:

You can use below connectivity to connect respective destination

- ODBC connection
- JDBC Connection
- File/URL Connection
- SAP Connection
- XML Connection
- Actuate data integration service connection

Step 3:

I have used ODBC connection to connect database for my report.

Note: There is a challenge, some time TNSnames.ora file configuration will not work here. better to create new connectivity datasource by using ODBC connection in control panel.
Also note: windows 7 - we need to use odbc bat file to create new datasource

happy coding
Bala

Actuate Spread Sheet Configure for existing report to modify

Step 1:
Install Actuate Spread Sheet report version 7

Step 2:
Download, There is a file name with extension called VTF.

Step 3:
Convert VTF extension in to .ZIP file and extract all the files.

Step 4:
After extraction, you can see three files with .vts,.guid and rop.
Example:
test.vts
test.guid
test.rop

Step 5:
we will take example of above mentioned files. open "test.vts" file, then it will take in to spreed sheet report to do the changes.

Note: The version 7, will not allow to open immediately, again you have to open same file by using 
menu option "open".