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 parameters

Hi
On a 2000 platform is it possible to make a parameter field searchable ?
So instead of just taking the first letter it should search using what the
user enters.
For instance when looking for washington
entering Was would place the marker on washingtonMichael, I'm pretty new to SRS, but I used this in the criteria next to
the column pcname to allow a filter for the pcname in the parameter:
LIKE '%' + @.pcname + '%'
I guess you could leave out the first % sign if you wanted each return
to begin with a particular character. Therefore you could enter Wa in
the field and might return WA9300, WASH93k9, etc. or the way it is
written sWAkjh93, redwakoe might also be returned.
Karen
michael v wrote:
> Hi
> On a 2000 platform is it possible to make a parameter field searchable ?
> So instead of just taking the first letter it should search using what the
> user enters.
> For instance when looking for washington
> entering Was would place the marker on washington

Report Name in Subscription

Hi!
Is there a way to make the name of the report dynamic? instead of just
appending a number if a certain already exists, the name could append
the name of the current month or a selected parameter.
Thanks! :)Hi Sigh,
I think you need a data driven subscription which will require the
enterprise edition of reporting services..
Cheers
Matt
"Sigh" wrote:
> Hi!
> Is there a way to make the name of the report dynamic? instead of just
> appending a number if a certain already exists, the name could append
> the name of the current month or a selected parameter.
> Thanks! :)
>|||Hi Matt.
Unfortunately, we're running the standard edition. Thanks for the
idea. :)
Sigh.

report manager e-mail

If I schedule a report in the Report Manager, can I also do this if I run
Novel Groupwise instead of Exchange Server ?"joia" wrote:
> If I schedule a report in the Report Manager, can I also do this if I run
> Novel Groupwise instead of Exchange Server ?
Reporting Services (I assume this is what you mean?) delivers email via
SMTP. This should mean that the mail is interoperable with any mail server
and client. In practice, I've had problems with how messages look in Becky!
(a popular Email program in Japan). There were also bugs (fixed in SP2?)
with mail sent to Lotus Notes... so YMMV. I'd suggest installing it and
giving it a try.
-- J

report manager e-mail

If I schedule a report in the Report Manager, can I also do this if I run
Novel Groupwise instead of Exchange Server ?
"joia" wrote:
> If I schedule a report in the Report Manager, can I also do this if I run
> Novel Groupwise instead of Exchange Server ?
Reporting Services (I assume this is what you mean?) delivers email via
SMTP. This should mean that the mail is interoperable with any mail server
and client. In practice, I've had problems with how messages look in Becky!
(a popular Email program in Japan). There were also bugs (fixed in SP2?)
with mail sent to Lotus Notes... so YMMV. I'd suggest installing it and
giving it a try.
-- J

report manager e-mail

If I schedule a report in the Report Manager, can I also do this if I run
Novel Groupwise instead of Exchange Server ?"joia" wrote:
> If I schedule a report in the Report Manager, can I also do this if I run
> Novel Groupwise instead of Exchange Server ?
Reporting Services (I assume this is what you mean?) delivers email via
SMTP. This should mean that the mail is interoperable with any mail server
and client. In practice, I've had problems with how messages look in Becky!
(a popular Email program in Japan). There were also bugs (fixed in SP2?)
with mail sent to Lotus Notes... so YMMV. I'd suggest installing it and
giving it a try.
-- J