Hi,
I'm setting up a data driven subscription for a report. I'm using email as
the delivery option, am NOT including the report in the email, instead using
the hyperlink feature to bring the user to the report on the server. I
tested it out and I received the email with the link but the link displays
the full address of the server, report path and parameters to the recipient.
We designed the system to use URL access and hidden parameters to hide all
paths and parameter options from the user, how can we have the link in the
email display something like: "Click here to view report" instead of:
http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
It is very important to my company that we hide this string from the user.
thank you
JerryI'm not sure how you could accomplish this. Even if we put just the text
you suggest and make it a hyperlink, the url would still be visible to the
user. You could always modify the comments section to include html and put
the hyperlink in yourself, but this would not hide the parameter.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry" <idroppeddabomb@.hotmail.com> wrote in message
news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm setting up a data driven subscription for a report. I'm using email as
> the delivery option, am NOT including the report in the email, instead
using
> the hyperlink feature to bring the user to the report on the server. I
> tested it out and I received the email with the link but the link displays
> the full address of the server, report path and parameters to the
recipient.
> We designed the system to use URL access and hidden parameters to hide all
> paths and parameter options from the user, how can we have the link in the
> email display something like: "Click here to view report" instead of:
>
http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> It is very important to my company that we hide this string from the user.
> thank you
> Jerry
>|||We worked around this by displaying the report within a pop-up window that we
instanciated via Javascript. That allowed us to turn off the address bar and
hide the URL. The user could still access it by right-clicking on the page
and going to properties, but at least it's not obvious.
sebring1130
"Daniel Reib [MSFT]" wrote:
> I'm not sure how you could accomplish this. Even if we put just the text
> you suggest and make it a hyperlink, the url would still be visible to the
> user. You could always modify the comments section to include html and put
> the hyperlink in yourself, but this would not hide the parameter.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jerry" <idroppeddabomb@.hotmail.com> wrote in message
> news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I'm setting up a data driven subscription for a report. I'm using email as
> > the delivery option, am NOT including the report in the email, instead
> using
> > the hyperlink feature to bring the user to the report on the server. I
> > tested it out and I received the email with the link but the link displays
> > the full address of the server, report path and parameters to the
> recipient.
> > We designed the system to use URL access and hidden parameters to hide all
> > paths and parameter options from the user, how can we have the link in the
> > email display something like: "Click here to view report" instead of:
> >
> http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> > It is very important to my company that we hide this string from the user.
> >
> > thank you
> >
> > Jerry
> >
> >
>
>|||In another situation, I didn't care that the URL was visible, I just had one
particular parameter that I couldn't allow the users to see (the username).
I solved this problem by "encrypting" that parameter. I created a simple SQL
function where I pass in the username, it manipulates the string a little and
then returns the SOUNDEX of the manipulated string. I used the function when
creating the data for the report and then again when selecting the parameters
for the data-driven subscription. I published the report, then went to
Report Manager and checked the "Prompt User" checkbox then set the "Prompt
String" to null. That allows me to send out the URL in the subscription
e-mails that are generated because the parameter value is meaningless to the
user (they see 'S165' instead of 'sebring', for example). They can click on
the URL link and the report comes up for them, but because the "Prompt
String" is set to null in the subscription, they cannot change that
parameter. It worked perfectly for what we needed.
sebring1130
"sebring1130" wrote:
> We worked around this by displaying the report within a pop-up window that we
> instanciated via Javascript. That allowed us to turn off the address bar and
> hide the URL. The user could still access it by right-clicking on the page
> and going to properties, but at least it's not obvious.
> sebring1130
>
> "Daniel Reib [MSFT]" wrote:
> > I'm not sure how you could accomplish this. Even if we put just the text
> > you suggest and make it a hyperlink, the url would still be visible to the
> > user. You could always modify the comments section to include html and put
> > the hyperlink in yourself, but this would not hide the parameter.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Jerry" <idroppeddabomb@.hotmail.com> wrote in message
> > news:OJUzVIblEHA.2820@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > I'm setting up a data driven subscription for a report. I'm using email as
> > > the delivery option, am NOT including the report in the email, instead
> > using
> > > the hyperlink feature to bring the user to the report on the server. I
> > > tested it out and I received the email with the link but the link displays
> > > the full address of the server, report path and parameters to the
> > recipient.
> > > We designed the system to use URL access and hidden parameters to hide all
> > > paths and parameter options from the user, how can we have the link in the
> > > email display something like: "Click here to view report" instead of:
> > >
> > http://myserver/ReportServer?/Reporting/FullReport&Client=xxx&date=xx/xx/xxxx.
> > > It is very important to my company that we hide this string from the user.
> > >
> > > thank you
> > >
> > > Jerry
> > >
> > >
> >
> >
> >
