Report Parameters

Hi,
Is it possible to have report parameter of string type displayed as a text
box instead of dropdown ? This will enable the user to type-in the parameter
value rather than choosing one. I have one more question. Is report
parameter of type String always displayed as a drop down list ? Can I have
checkboxes as report parameters ? These question are very basic. Iam new to
SSRS. Please provide help.
Thanks,
RKOn Oct 17, 5:48 am, "S V Ramakrishna"
<ramakrishna.seeth...@.translogicsys.com> wrote:
> Hi,
> Is it possible to have report parameter of string type displayed as a text
> box instead of dropdown ? This will enable the user to type-in the parameter
> value rather than choosing one. I have one more question. Is report
> parameter of type String always displayed as a drop down list ? Can I have
> checkboxes as report parameters ? These question are very basic. Iam new to
> SSRS. Please provide help.
> Thanks,
> RK
Regardless of datatype, anytime you provide a choice of available
values, whether non-queried or queried, you'll be presented with the
drop down. The drop down is the only option for displaying available
values. The only time you'll see checkboxes is if you select the
Multi-Value option and even then the checkboxes appear by way of the
drop down.
If you want your users to enter the parameter value in a text box, you
will not be able to offer available values. There is a slight caveat
to my last statement. You can use the prompt to suggest potential
values to be entered into the text box. For example, you could have
your prompt read, "Enter one of the following values: Yes; No; Maybe."
HTH

Report out an html string

Is it possible to report out an html string into the rich format?
--> I use an html control (RichTextBox 2.5) that allows the user to create
the main body of a quote in a wysiwyg environment, and that formatting is
successfully saved as an html string to the SQL db and successfully displayed
when opening back up in the control.
--> Will Reporting Services allow me to take that html string and display in
the main body of a report, with the formatting applied (i.e. bold, bullets,
etc.)?
Any help would be greatly appreciated, from saving as a certain datatype in
SQL to rendering the code in the Reporting Services.
Many thanks,
AndyNo. This would most likely would be a security hole if reporting services
allowed that.
However, you could build your own ASP page around reporting services that
might give you a little of the functionality you want.
--
| Thread-Topic: Report out an html string
| thread-index: AcWie3YqffCUH69lRbybl0xkS1lurw==| X-WBNR-Posting-Host: 69.160.170.174
| From: =?Utf-8?B?cGFwYXJoaW5v?= <paparhino@.discussions.microsoft.com>
| Subject: Report out an html string
| Date: Tue, 16 Aug 2005 08:59:19 -0700
| Lines: 16
| Message-ID: <035749C9-7F6C-49E4-BFCD-2DA040AC5CAE@.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.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:50470
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Is it possible to report out an html string into the rich format?
|
| --> I use an html control (RichTextBox 2.5) that allows the user to
create
| the main body of a quote in a wysiwyg environment, and that formatting is
| successfully saved as an html string to the SQL db and successfully
displayed
| when opening back up in the control.
|
| --> Will Reporting Services allow me to take that html string and display
in
| the main body of a report, with the formatting applied (i.e. bold,
bullets,
| etc.)?
|
| Any help would be greatly appreciated, from saving as a certain datatype
in
| SQL to rendering the code in the Reporting Services.
|
| Many thanks,
| Andy
|

Report Hyperlink Opening New Window

Hi, I am trying to get a link out of a report to open another web browser
with the HTML
rs:target=_blank as part of the string parameter that is passed in...but it
still opens the link in the same window.
?How does one open a link out of a report so that it will open a new window?
THANKS!!!There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi, I am trying to get a link out of a report to open another web browser
> with the HTML
> rs:target=_blank as part of the string parameter that is passed in...but
> it still opens the link in the same window.
> ?How does one open a link out of a report so that it will open a new
> window?
> THANKS!!!
>|||ok, so I tried this and it didn't work...or maybe I didn't understand it...
I'm in a text box in a table under
properties>>advanced>>navigation>>Jump to URL
and I enter
="http://kingofthegreens.com&rc:LinkTarget=_blank"
results in it still opening in the same window'
"Robert Bruckner [MSFT]" wrote:
> There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> See also:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > Hi, I am trying to get a link out of a report to open another web browser
> > with the HTML
> > rs:target=_blank as part of the string parameter that is passed in...but
> > it still opens the link in the same window.
> >
> > ?How does one open a link out of a report so that it will open a new
> > window?
> >
> > THANKS!!!
> >
>
>|||I am having a similar issue, I can't find the syntax for adding
rc:LinkTarget. I am trying to add a url with one query string parameter and
open in a new window.
Thanks!
"Ben Sullins" wrote:
> ok, so I tried this and it didn't work...or maybe I didn't understand it...
> I'm in a text box in a table under
> properties>>advanced>>navigation>>Jump to URL
> and I enter
> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
> results in it still opening in the same window'
>
> "Robert Bruckner [MSFT]" wrote:
> > There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> > See also:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > > Hi, I am trying to get a link out of a report to open another web browser
> > > with the HTML
> > > rs:target=_blank as part of the string parameter that is passed in...but
> > > it still opens the link in the same window.
> > >
> > > ?How does one open a link out of a report so that it will open a new
> > > window?
> > >
> > > THANKS!!!
> > >
> >
> >
> >|||Here is a response of mine about exporting to CSV that covers your
situation. Note that you need to have SP1 or SP2 installed to be able to use
this:
>>>>>>
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager it puts CSV data in unicode which Excel puts all in one column. If
you export in ASCII then Excel does just as you want. To prevent a problem
with cells (Excel will object to sorting the data) you need to remove any
textboxes you have (for instance with a title, showing the parameters run
etc) and instead add additional header rows, merge the cells and put your
text in there instead. I add a link at the top of the report that says
Export Data. With RS 2005 you will be able to configure it to use ASCII
instead of Unicode.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Very nice and very fast.
>>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Rogers" <Peter Rogers@.discussions.microsoft.com> wrote in message
news:F4C1AC98-3B0D-443D-B18A-0E7896435958@.microsoft.com...
>I am having a similar issue, I can't find the syntax for adding
> rc:LinkTarget. I am trying to add a url with one query string parameter
> and
> open in a new window.
> Thanks!
> "Ben Sullins" wrote:
>> ok, so I tried this and it didn't work...or maybe I didn't understand
>> it...
>> I'm in a text box in a table under
>> properties>>advanced>>navigation>>Jump to URL
>> and I enter
>> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
>> results in it still opening in the same window'
>>
>> "Robert Bruckner [MSFT]" wrote:
>> > There is no rs:target parameter. I suppose you mean
>> > rc:LinkTarget=_blank
>> > See also:
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
>> >
>> > -- Robert
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
>> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
>> > > Hi, I am trying to get a link out of a report to open another web
>> > > browser
>> > > with the HTML
>> > > rs:target=_blank as part of the string parameter that is passed
>> > > in...but
>> > > it still opens the link in the same window.
>> > >
>> > > ?How does one open a link out of a report so that it will open a new
>> > > window?
>> > >
>> > > THANKS!!!
>> > >
>> >
>> >
>> >