date and time diffs: link

Showing posts with label link. Show all posts

Wednesday, March 7, 2012

Data-Driven Subscription Link

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
> > >
> > >
> >
> >
> >

Databse Link will not connect

I have a couple new servers - Windows 2003 R2 - with SQL Server 2000
SP4 installed. They are all Active/Active clustered instances (my
first ones).

I am trying to create database links to other SQL Server instances, but
there are 3 that I cannot connect to.

The dblink works if I connect to the instance as "sa", but not as my
Windows Authenticated account. We use Active Directory and I am in the
Administrator group on all of the boxes.

Of the 3 I can't get to, 1 is a cluster (Active/Passive) and the other
2 are just regular Enterprise instances. They are all SQL 2000 SP4.

I have several other instances, all SP4 on 2003 boxes and I can connect
to all of them.

Also, on the instances where the dblink does not work, I can actually
connect to these databases w/in Enterprise Manager successfully.

I am using a different port for the instances, but I have set them up
in the Client Network Utility as well and still can't connect.

I can connect via a dblink TO these new instances from the older boxes
fine.

I'm really stumped - I've had the Network people verify we don't have a
firewall issue or something.

Must be some sort of permissions problem, but I don't know what else to
check - - -

Please help!!

THANK YOU!!Not completely sure what you mean by a dblink, but what SQL permissions
do the Administrators have on each server? Are you sure the
BUILTIN/Administrators Windows group have the appropriate permissions
on the databases you want to select from?

Stu

traceable1 wrote:

Quote:

Originally Posted by

I have a couple new servers - Windows 2003 R2 - with SQL Server 2000
SP4 installed. They are all Active/Active clustered instances (my
first ones).
>
I am trying to create database links to other SQL Server instances, but
there are 3 that I cannot connect to.
>
The dblink works if I connect to the instance as "sa", but not as my
Windows Authenticated account. We use Active Directory and I am in the
Administrator group on all of the boxes.
>
Of the 3 I can't get to, 1 is a cluster (Active/Passive) and the other
2 are just regular Enterprise instances. They are all SQL 2000 SP4.
>
I have several other instances, all SP4 on 2003 boxes and I can connect
to all of them.
>
Also, on the instances where the dblink does not work, I can actually
connect to these databases w/in Enterprise Manager successfully.
>
I am using a different port for the instances, but I have set them up
in the Client Network Utility as well and still can't connect.
>
I can connect via a dblink TO these new instances from the older boxes
fine.
>
I'm really stumped - I've had the Network people verify we don't have a
firewall issue or something.
>
Must be some sort of permissions problem, but I don't know what else to
check - - -
>
Please help!!
>
THANK YOU!!

|||Thank you!

By dblink I am referring to a linked server. (I apologize - I come
from an Oracle background).

The BUILTIN/Administrators group has all of the System Roles and it
still did not work.
Other boxes have links into the server/instance which work fine, and
the new server can link to other servers.
It's strange because it's just this one combination that does not work.

Group A: oldest servers; non-clustered; Win 2003 SP1

Group B: medium servers; 1 a/p cluster; 2 non-clustered; Win 2003 SP1

Group C: newest servers; 3 a/a clusters; Win 2003 R2

All SQL Server 2000 SP4

Group A can link to Group B
Group A can link to Group C
Group B can link to Group A
Group B can link to Group C
Group C can link to Group A
Group C CANNOT link to Group A if logged in using Windows
Authentication

All of the links are set up using "sa".

Stu wrote: