Data drive subscritpion sQL2000- Hide parameter for email recipien

Hi,
I am looking for a way to hide the parameter input fields in the report. I
want to avoid that customer could modify his assigned parameter. If I disable
option in report property "prompt for user" (I have German version
"Eingabeaufforderung für Benutzer") I cannot assign parameter from my "data
driven" source.
Thanks for help.Hi,
I would "normally" get what I want if I attach report to mail and not the
link. But everytime I try this the scheduled execution fails. If I try it
with a simple test report it works fine. In My report I use a dynamic MDX
query like
="With meber..." & Parameters!Para1.Value & ...
Maybe here is the issue?
"mathiasr" wrote:
> Hi,
> I am looking for a way to hide the parameter input fields in the report. I
> want to avoid that customer could modify his assigned parameter. If I disable
> option in report property "prompt for user" (I have German version
> "Eingabeaufforderung für Benutzer") I cannot assign parameter from my "data
> driven" source.
> Thanks for help.|||I found it myself:
I need a domain user instead of sql authentication (sa user) in the
datasource property. Then the execution of report works unattended and can be
emailed.
"mathiasr" wrote:
> Hi,
> I would "normally" get what I want if I attach report to mail and not the
> link. But everytime I try this the scheduled execution fails. If I try it
> with a simple test report it works fine. In My report I use a dynamic MDX
> query like
> ="With meber..." & Parameters!Para1.Value & ...
> Maybe here is the issue?
> "mathiasr" wrote:
> > Hi,
> >
> > I am looking for a way to hide the parameter input fields in the report. I
> > want to avoid that customer could modify his assigned parameter. If I disable
> > option in report property "prompt for user" (I have German version
> > "Eingabeaufforderung für Benutzer") I cannot assign parameter from my "data
> > driven" source.
> > Thanks for help.

Cutting out the sentence

dear all,
I need do constantly queries against a remote server:
select * from [xxx.xx.xxx.xx].db.owner.table
I would like to avoid put every time the IP between brackets
Thanks a lot,Try using "Client Network Utility" to create an alias.
AMB
"Enric" wrote:

> dear all,
> I need do constantly queries against a remote server:
> select * from [xxx.xx.xxx.xx].db.owner.table
> I would like to avoid put every time the IP between brackets
> Thanks a lot,
>