 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Report on excel data | Login/Join |
| Member |
Hello, I need to create reports on data which is present in excel file. The data in the excel file is supposed to change. This excel file is placed on a server which the users will update. Could anybody suggest how to go about creating reoprts in this scenario. I am using version 764. Thanking You, Best Regards, VidyaThis message has been edited. Last edited by: Kerry, WF 764 Windows Excel, HTML, PDF, XML | ||
|
| Virtuoso |
You need to interface with excel using odbc connections. Once you have set that up and can connect and read from your sheet(s), then you can add the connection to the list of connections for the reporting server. This connection can then be used to firstly create your master and access file and secondly create your reports against the excel file. The first row in your sheet should contain the fieldnames to be used by webfocus, the range of cells to read in the worksheet should be defined to be able to name your master file and retrieve the records. And, last but not least, the excel file can not be opened by anyone at the time of reading it. Hope this helps ... GamP
| |||||||||
| ||||||||||
| Member |
Hello, Thanks for the info. Could you please explain how do i set up this interface with ODBC connections. Thanking You, Best Regards, Vidya WF 764 Windows Excel, HTML, PDF, XML | |||
|
| Virtuoso |
On the server workstation: Start - Programs - Administrative tools - Data sources (ODBC) Or: Start - settings - Control Panel - Administrative tools - Data Sources (ODBC). Once in the tol: select system DSN, click Add, select the appropriate driver and configure it. GamP
| |||||||||
| ||||||||||
| <JG> |
To use the ODBC adapter in WebFOCUS first you have to pay for it. | ||
|
| Expert |
I think this will only work on a windows environment. Another way, albeit obscure is to use SQL server. the latest releases can "Mount" an excel document and make it available as an SQL Server source. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
Thank you all for the suggestion! Regards, Vidya WF 764 Windows Excel, HTML, PDF, XML | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |