Showing posts with label second. Show all posts
Showing posts with label second. Show all posts

Friday, March 23, 2012

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

Wednesday, March 7, 2012

Help:Select query

I have 3 tables in my database

The first Table is called Customers

The second Table is called Rooms

And the third table is a combination of the primary keys of Customer table and the Rooms Table.

The Room tables consist of 50 rooms and only 30 of these rooms are currently
occupied. I need a query to find the available room numbers that are not
currently in use.

The query below the retrieve the occupied room

SELECT Room.Room, Room.Telefon

FROM ThirdTableINNER JOIN

Room ON ThirdTableINNER .RoomID = Room.RoomID

Thanks in advanceSELECT Room.Room, Room.Telefon

FROM ThirdTable a RIGHT JOIN

Room b ON a .RoomID = b.RoomID

WHERE a.RoomId IS NULL

Are the rooms rented in units of 15 minutes?

:D|||Originally posted by Brett Kaiser
SELECT Room.Room, Room.Telefon

FROM ThirdTable a RIGHT JOIN

Room b ON a .RoomID = b.RoomID

WHERE a.RoomId IS NULL

Are the rooms rented in units of 15 minutes?

:D

Thank u Brett Kaiser for the help. The query was great. Actually all rooms are almost full, but because you did a great job, as the Manager of the Hotel I will offer you 3 nights stay FOC.|||And where might that be?|||Originally posted by Brett Kaiser
And where might that be?

We have branch offices world wide, all you need to do is to specify your location I will send a comfirmation to that branch.