Forum | Synoptix

Learn, Create, Report
It is currently Thu Jul 18, 2019 9:33 pm

All times are UTC - 7 hours [ DST ]

Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Tue Mar 05, 2019 10:51 am 
Site Admin
User avatar

Joined: Tue Dec 10, 2013 3:27 pm
Posts: 403
Position: Forum Administrator
If you are connecting the reporting client to an Excel spreadsheet in order to access the data in a report, the location of the spreadsheet must be available to all users.
This means if the spreadsheet is on a protected server, or a user's personal desktop that not all other client users have access to, they will be unable to pull that data into their reports. This could cause reports to show the spreadsheet information as a zero when they run a report.

To resolve this, we recommend copying the spreadsheet to a server everyone has access to, and using a UNC (universal naming convention) path. If you place the spreadsheet on a server everyone has access to, but the server is mapped to their individual workstations, the drive letter could appear different from user to user. A UNC path uses double slashes to precede the name of the computer. The path (disk and directories) within the computer are separated by a single slash. This means the server name is included, but not the drive letter that it may be mapped to on their workstation—the UNC eliminates the need for a drive letter.
This is ideal, because the spreadsheet path in the Synoptix connection setup is universal across all users and workstations.

UNC uses the following format: \\server-name\shared-resource-pathname.filetype
There will be a slash between each breadcrumb.
Example: \\SQLdatabase\sharedfolder\examplespreadsheet.xls
That text is what you will add to the host connection setup spreadsheet path (under connection setup in Synoptix).
Spreadsheet Connection.png [56.44 KiB]
Downloaded 4747 times

Note that the default sheet should populate with either the name of the spreadsheet itself, or the name of the first tab within the spreadsheet.

Download this information in a 1 page PDF guide below.
UNC guide for spreadsheet connections.pdf [104.45 KiB]
Downloaded 22 times

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 7 hours [ DST ]

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Group
Powered by Reputation System © Pico88