Showing posts with label button. Show all posts
Showing posts with label button. Show all posts

Tuesday, March 20, 2012

Bug? Available Values list for boolean parameters

Hi,
I have defined a boolean parameter in my report and I wish to display a list
of possible values instead of the True/False radio button. I have defined
two possible values in the Available Values list (Report Parameters Window)
but it looks as though they are ignored, the parameter toolbar still
displaying the True/False radio buttons...
Hope someone can help.Looks like a bug to me...best chance is to programatically create your
own parameter page.
"webfrog" <webfrog@.discussions.microsoft.com> wrote in message news:<11B5246A-F6E6-4583-8945-A945851F58CD@.microsoft.com>...
> Hi,
> I have defined a boolean parameter in my report and I wish to display a list
> of possible values instead of the True/False radio button. I have defined
> two possible values in the Available Values list (Report Parameters Window)
> but it looks as though they are ignored, the parameter toolbar still
> displaying the True/False radio buttons...
> Hope someone can help.|||If you change your datatype to integer, then put in available values such
that true = 1 and false = 0, you will get a drop-down list with true & false
options.
"webfrog" wrote:
> Hi,
> I have defined a boolean parameter in my report and I wish to display a list
> of possible values instead of the True/False radio button. I have defined
> two possible values in the Available Values list (Report Parameters Window)
> but it looks as though they are ignored, the parameter toolbar still
> displaying the True/False radio buttons...
> Hope someone can help.
>

Sunday, February 12, 2012

BPA Questions

Does BPA only read the database being scaned?
How do I print the report?
I only have a copy button, where's the print button?
Does BPA write anything to the database being scanned?
Thanks
> Does BPA only read the database being scaned?
Yes

> How do I print the report?
You can use Copy Report and paste it into Word and print from that
There is also the option to use Reporting Services to report on the results
and you can print from that, save to PDF etc
There are examples of reports that come with it

> I only have a copy button, where's the print button?
I don't think there is one (see above)

> Does BPA write anything to the database being scanned?
No
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:3747E300-1A39-4F44-91ED-71487D15179C@.microsoft.com...
> Does BPA only read the database being scaned?
> How do I print the report?
> I only have a copy button, where's the print button?
> Does BPA write anything to the database being scanned?
> Thanks
>
|||Hi Guys,
I was playing with the BPA and looks good but found that it does not
check for the SA password when I change it to Null or modify it to be
blank.
Is it something wrong with my machine or BPA does not check the
passwords at all.
I thought the BPA should pick up the accounts which have blank
passwords or the same name etc and this should be on the top of list
for the BPA tool to do .
Let me know your thoughts guys.
Cheers
--Ramesh
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message news:<ur9jiI$aEHA.2840@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Yes
> You can use Copy Report and paste it into Word and print from that
> There is also the option to use Reporting Services to report on the results
> and you can print from that, save to PDF etc
> There are examples of reports that come with it
> I don't think there is one (see above)
> No
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:3747E300-1A39-4F44-91ED-71487D15179C@.microsoft.com...
|||Hi Ramesh
BPA currently does not have any security checks. To do security you can use
Baseline Security Analyzer (http://www.microsoft.com/mbsa )
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"rams" <ramesh_sql@.yahoo.com> wrote in message
news:5ea6b47e.0407191828.41423a18@.posting.google.c om...
> Hi Guys,
> I was playing with the BPA and looks good but found that it does not
> check for the SA password when I change it to Null or modify it to be
> blank.
> Is it something wrong with my machine or BPA does not check the
> passwords at all.
> I thought the BPA should pick up the accounts which have blank
> passwords or the same name etc and this should be on the top of list
> for the BPA tool to do .
> Let me know your thoughts guys.
> Cheers
> --Ramesh
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:<ur9jiI$aEHA.2840@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
results[vbcol=seagreen]
message[vbcol=seagreen]