PDA

View Full Version : Excel Template Report for Actix



wirelesIub
2012-08-09, 03:04 PM
Hi
Do you guys have a guide on how to create an Excel Template report to use along with actix queries...Thanks in advance for your help

BR,

Jerry
2012-08-09, 06:18 PM
these create queries and network image. Then load workbook: menu>workbook> select your excel template.

wirelesIub
2012-08-10, 12:10 AM
Thanks Jerry

Could you point out the steps involved in creating an Excel Template Report from scratch...Thanks for your help

BR//

Jerry
2012-08-10, 12:35 PM
the basic points are to get the result in excel workbook. to do that simple locate and right click on the attribute (example ServRxLevSub) and choose Display on workbook. this will open excel and inserts the results on worksheets. Do not edit any resulted sheets. You can also add your queries by the same way by choose Display on Workbook (active). note dont change on resulted sheets.
Now you can customize your report by adding new sheets and link to other resulted sheets. You should use formula to get the result automatically. Save that excel workbook and that is your excel template.

Hope this help.