| Author |
Topic |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-09-24 : 12:56:48
|
| One of the columns in a table of ours is the path and name of a document on our server. I was asked of I could turn the data into a hyperlink. Has anyone ever had the opportunity to accomplish that?John |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-25 : 11:55:22
|
Google knows all:http://binaryworld.net/Main/CodeDetail.aspx?CodeId=4012Its abit annoying when sometimes no one replys to threads!quote:
Originally posted by JCirocco
One of the columns in a table of ours is the path and name of a document on our server. I was asked of I could turn the data into a hyperlink. Has anyone ever had the opportunity to accomplish that?John
|
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 12:10:25
|
| I'm a patient person plus I know not many people visit the SSRS threads.Thanks for the help!John |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-25 : 12:14:33
|
Ahh youve helped me before, thought id return the favour.quote:
Originally posted by JCirocco
I'm a patient person plus I know not many people visit the SSRS threads.Thanks for the help!John
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 12:15:51
|
| My data field did not have the full path including the "\\ServerName\ShareName\"Once I concatenated, it worked. Thanks.John |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-25 : 12:17:06
|
You replied early about folder management in report server website, is 100% you cannot stop users from looking at certain folders?quote:
Originally posted by JCirocco
My data field did not have the full path including the "\\ServerName\ShareName\"Once I concatenated, it worked. Thanks.John
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 12:18:28
|
| BTW - Everytime I see you are in UK, want to mention I have a true, Brit 1977 MiniJohn |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 12:19:45
|
| Actually if you remove FolderBrowsing from the Role (or copy to new name and remove) you can stop. Just playing with that this morning.John |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 12:24:37
|
| - Site Settings- Configure Item Level Role Def- Browser- Optionally copy to new name- Uncheck View Folders (and View Resources)John |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-25 : 12:29:19
|
There are only 2 members on the whole site me and the admin, but people are still able to browse to the website and fully view everything.Im assuming because everyone is able to log onto the server, where the site sits on?quote:
Originally posted by JCirocco
- Site Settings- Configure Item Level Role Def- Browser- Optionally copy to new name- Uncheck View Folders (and View Resources)John
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 12:44:42
|
| Are they browsing through report manager or a custom reporting site you have? If Report Manager, there must be a default. How aer they getting there to start?If normal IIS web site, you can remove the ability to browse folders in the Web Site properties.John |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 12:47:47
|
| If in IIS, Web Site Properties, click Virtual Directory Tab and uncheck Directory Browsing.John |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-28 : 05:29:36
|
Directory browsing is unchecked.quote:
Originally posted by JCirocco
If in IIS, Web Site Properties, click Virtual Directory Tab and uncheck Directory Browsing.John
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-28 : 12:49:13
|
| Are users using ReportManager?John |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-09-28 : 13:08:07
|
Yep,,Got another issue aswell, i have a report users export to excel, ive changed the data type to float, int, nvarchar etc but the user still has to change the cell to number from the spreadsheet. isnt there a format that automatically sets to number in excel?thanksquote:
Originally posted by JCirocco
Are users using ReportManager?John
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-28 : 14:41:37
|
| Re: Navigation - "Folder" structure is virtual and can only be controlled by security of the role the user is assigned to. Will grab an example in a bit. I replied on the other thread regarding the Excel.John |
|
|
|
|
Hyperlink In a report?