hidden parameters are not hidden

Hello,
I've created a report with a parameter with no prompt ( hidden ) and a
second one with a prompt. When I switch to preview in Visual Studio only the
second parameter appears. This is OK.
When I launch the report in IE :
http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&Param2=2
both parameters appear in the parameter section !?!From the SP1 readme:
4.3.1 Hiding Parameters in a Published Report
In Report Manager, you can now set parameter properties in a way that
allows you to achieve two objectives simultaneously:
· Hide the parameter fields in a published report.
· Specify a parameter value at run time (for example, through a
subscription that is used to trigger report execution and delivery).
Previously, the only way to hide a parameter value was to clear the Prompt
User check box in the Parameters properties page. However, a side effect of
clearing the check box was that you could no longer specify a parameter
value for the report at run time. This limitation has been removed. In SP1,
you can clear the Prompt User check box to hide the parameter fields and
values in the report. Doing so does not introduce restrictions on how you
subsequently set the parameter value externally at run time.
--
| Thread-Topic: hidden parameters are not hidden
| thread-index: AcTjhM6KynxAWJglRZyZ76tv0LGvGQ==| X-WBNR-Posting-Host: 198.240.212.30
| From: "=?Utf-8?B?UGFzY2FsIFNpbWxlcg==?=" <Pascal
Simler@.discussions.microsoft.com>
| Subject: hidden parameters are not hidden
| Date: Thu, 16 Dec 2004 07:35:01 -0800
| Lines: 9
| Message-ID: <7E509939-5E13-4BBD-987D-F73CA24397CE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:37567
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello,
|
| I've created a report with a parameter with no prompt ( hidden ) and a
| second one with a prompt. When I switch to preview in Visual Studio only
the
| second parameter appears. This is OK.
| When I launch the report in IE :
| http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&Param2=2
| both parameters appear in the parameter section !?!
|
||||Brad, are you aware of any probelms when using hidden parameters along with
prompted credentials? The result I encounter when attempting this is that RS
continually prompts for credentials rather than proceeding to view the
report...
""Brad Syputa - MS"" wrote:
> From the SP1 readme:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that
> allows you to achieve two objectives simultaneously:
> · Hide the parameter fields in a published report.
> · Specify a parameter value at run time (for example, through a
> subscription that is used to trigger report execution and delivery).
> Previously, the only way to hide a parameter value was to clear the Prompt
> User check box in the Parameters properties page. However, a side effect of
> clearing the check box was that you could no longer specify a parameter
> value for the report at run time. This limitation has been removed. In SP1,
> you can clear the Prompt User check box to hide the parameter fields and
> values in the report. Doing so does not introduce restrictions on how you
> subsequently set the parameter value externally at run time.
> --
> | Thread-Topic: hidden parameters are not hidden
> | thread-index: AcTjhM6KynxAWJglRZyZ76tv0LGvGQ==> | X-WBNR-Posting-Host: 198.240.212.30
> | From: "=?Utf-8?B?UGFzY2FsIFNpbWxlcg==?=" <Pascal
> Simler@.discussions.microsoft.com>
> | Subject: hidden parameters are not hidden
> | Date: Thu, 16 Dec 2004 07:35:01 -0800
> | Lines: 9
> | Message-ID: <7E509939-5E13-4BBD-987D-F73CA24397CE@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:37567
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hello,
> |
> | I've created a report with a parameter with no prompt ( hidden ) and a
> | second one with a prompt. When I switch to preview in Visual Studio only
> the
> | second parameter appears. This is OK.
> | When I launch the report in IE :
> | http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&Param2=2
> | both parameters appear in the parameter section !?!
> |
> |
>

Help: ADO with Unix and Oracle

We have done a complex software with VB using SQL Server through ADO. Now
our customer is planning to switch from SQL Server to Unix/Aix Oracle 8 DB.

I'm a newbie both in Oracle and Unix and wonder how this will affect our
software. Would changing the connection string be enough (I quess not).

Any help would be appreciated !

Jyrki Hamalainen
Laukaa, Finland
jyrki . hamalainen @. ids . fiOn Thu, 04 Sep 2003 08:23:14 GMT in comp.databases.ms-sqlserver,
"Jyrki H" <jyrki@.nowhere.com> wrote:

>We have done a complex software with VB using SQL Server through ADO. Now
>our customer is planning to switch from SQL Server to Unix/Aix Oracle 8 DB.
>I'm a newbie both in Oracle and Unix and wonder how this will affect our
>software.

It will probably affect your income more, think of all the dosh you
can charge for that conversion :-)

>Would changing the connection string be enough (I quess not).

I'm no oracle expert but at a guess and from experience of people in
CDMA connecting Access to Oracle the ODBC/OLEDB driver you get in
Windows won't do you any favors, IIRC Oracle has something called
SQL.NET and that's probably your best bet for the connection.

The rest will depend on how you wrote your app, if a lot of stored
procedures and triggers, etc then you're going to have fun making them
all work, I'm not sure if there's any conversion tools for converting
a database over, standard stuff should be able to be scripted (tables
and columns) but when you get to the nitty gritty, UDFs, etc. then you
may find things that are not supported or that Oracle will implement
some functionality you need in a different way.

Again I stress that I don't know Oracle and that a lot more may be
instantly convertable than I indicated... or a lot less. You have to
investigate this and come up with some time frame about how long it
will take and how much it will cost before your customer commits as
although there's a smiley on my first paragraph, it may be closer to
to the mark than you think.

Sorry I can't give you any specifics on Oracle but it's something to
start thinking about on the planning side.

I'd suggest if you haven't already done so, post a similar question in
an Oracle news group, normally when talking about conversions or
interactions between products I would recommend cross-posting to both
groups but in this case I wouldn't, IME it would likely start a flame
war, some of those Oracle guys are little, how shall I put it...
esoteric. :-)

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)