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.
>

bug: PageBreak does not work when set Hidden (visibilty) using parameters

In my report project, I used many subreport in my master report. Each
subreport was put in a rectangle area so that I could setup
PageBreakAtEnd or PageBreakAtStart. In the meantime I also need to set
the Hidden property which is based on the parameters or conditional
expression for showing/hidding subreports. BUT PAGE BREAK does not work
at all.
If setting this HIDDEN property using False or True instead of
expression, page break still works fine. It's definitely such a big bug
that it makes subreports or other report items less useful. When
rendering report the layout of report is so strange. I knew this issue
last year.
Is there any solution or other alternative way to the issue or does SP2
resolve it?
Thanks,
LeonLeon I agree with you and have the same issue. We would appreciate really if
Reporting Service help desk give us some definitive response on this ASAP.
"leon" wrote:
> In my report project, I used many subreport in my master report. Each
> subreport was put in a rectangle area so that I could setup
> PageBreakAtEnd or PageBreakAtStart. In the meantime I also need to set
> the Hidden property which is based on the parameters or conditional
> expression for showing/hidding subreports. BUT PAGE BREAK does not work
> at all.
> If setting this HIDDEN property using False or True instead of
> expression, page break still works fine. It's definitely such a big bug
> that it makes subreports or other report items less useful. When
> rendering report the layout of report is so strange. I knew this issue
> last year.
> Is there any solution or other alternative way to the issue or does SP2
> resolve it?
> Thanks,
> Leon
>

bug in focus

so i've got 5 parameters; a couple of booleans
refer to them as
1 2
3 4
5
#2 is the date parameter.. and I keep on getting the date prompt / drop
down...
a) select value for 1, 3, 5
b) enter #2; the value 4/1/06 in the date dropdown
c) mouse focus to #4
d) hit enter when I'm done filling out 4-- since im then DONE filling
in all of my parameters;..
do you know what happens?
i get .dropdown on the datepicker dropdown.
shouldn't they test these things before they start selling it?yeah; i've noticed the same thing.. im surprised MS didn't catch this
-Aaron
On Oct 4, 1:51 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
wrote:
> so i've got 5 parameters; a couple of booleans
> refer to them as
> 1 2
> 3 4
> 5
> #2 is the date parameter.. and I keep on getting the date prompt / drop
> down...
> a) select value for 1, 3, 5
> b) enter #2; the value 4/1/06 in the date dropdown
> c) mouse focus to #4
> d) hit enter when I'm done filling out 4-- since im then DONE filling
> in all of my parameters;..
> do you know what happens?
> i get .dropdown on the datepicker dropdown.
> shouldn't they test these things before they start selling it?

Breaking up parametersT

One of my parameters is a particular date (in the datetime format 11/05/2002 12:00:00 AM) and I wanted to display only the month and year. How can I do this to just display November 2002 on my report.Try using the DATENAME function. Here's an example using the current date:

declare @.CurrentDate datetime
set @.CurrentDate = GetDate()

select DATENAME(m, @.CurrentDate) + ' ' + DATENAME(yy, @.CurrentDate)

|||Im using visual basic business intelligence. I did figure out the year...

=Year(Parameters!reportdate.Value)

I want the month to be displayed as November, January, July...etc not 11, 1, 7 '

=Month(Parameters!reportdate.Value) gives me 10 which I dont want

and

=MonthName(Parameters!reportdate.Value) gives me an error. I am using SQL 2000.

|||Try the code that I gave above. My output from running the statement

select DATENAME(m, @.CurrentDate) + ' ' + DATENAME(yy, @.CurrentDate)

is:

Column1
-
April 2006
No rows affected.
(1 row(s) returned)

That gives the month name (not number), as you requested...|||Have a look at:
http://msdn2.microsoft.com/en-US/library/ms174395(SQL.90).aspx

It's the documentation for the TSQL DATENAME command.|||

try the following

Switch(Month(Parameters!BeginDate.Value)=01,"January" & Year(Parameters!BeginDate.Value),Month(Parameters!BeginDate.Value)=02,"Feb" & Year( Parameters!BeginDate.Value) )

|||The DATENAME function should also work in SQL Server 2000 - have a look here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_1dph.asp

Also have a look at this article for some further examples:
http://www.sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

Breaking up parameters

One of my parameters is a particular date (in the datetime format 11/05/2002 12:00:00 AM) and I wanted to display only the month and year. How can I do this to just display November 2002 on my report.Try using the DATENAME function. Here's an example using the current date:

declare @.CurrentDate datetime
set @.CurrentDate = GetDate()

select DATENAME(m, @.CurrentDate) + ' ' + DATENAME(yy, @.CurrentDate)

|||Im using visual basic business intelligence. I did figure out the year...

=Year(Parameters!reportdate.Value)

I want the month to be displayed as November, January, July...etc not 11, 1, 7 '

=Month(Parameters!reportdate.Value) gives me 10 which I dont want

and

=MonthName(Parameters!reportdate.Value) gives me an error. I am using SQL 2000.

|||Try the code that I gave above. My output from running the statement

select DATENAME(m, @.CurrentDate) + ' ' + DATENAME(yy, @.CurrentDate)

is:

Column1
-
April 2006
No rows affected.
(1 row(s) returned)

That gives the month name (not number), as you requested...|||Have a look at:
http://msdn2.microsoft.com/en-US/library/ms174395(SQL.90).aspx

It's the documentation for the TSQL DATENAME command.|||

try the following

Switch(Month(Parameters!BeginDate.Value)=01,"January" & Year(Parameters!BeginDate.Value),Month(Parameters!BeginDate.Value)=02,"Feb" & Year( Parameters!BeginDate.Value) )

|||The DATENAME function should also work in SQL Server 2000 - have a look here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_1dph.asp

Also have a look at this article for some further examples:
http://www.sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

bound table

I am wondering if anyone knows a solution to this question.

I have an sp that may return two different value fields depending on the parameters that are passed in. One way, the sp can return 5 values and another way it can return 10 values. I need to bind the returned values to a table. However, I only want to view the values that are intended to be shown. For example, if the input is SSN and show all is false then the 5 values that need to be outputted would be first name, last name, address, zip code, and contact number. However, if the input is SSN and the show all is true, then the 10 values would be the name plus, other info........

How can I go about outputting all of this info? should I use one bound table?

Or should I have two tables one on top of another and then differentiate on what to show based on what parameters have been inputted? how would i do that and is it possible?

Column headers should reflect all the data that is displayed. Therefore, i was thinking making two tables with hard coded column headers.

Any help would be grateful!

thanks

yadgor2000

I found the answer to my own question, I hope it might help someone else in future: http://www.codeproject.com/dotnet/DynamicReport.asp?df=100&forumid=205933&exp=0&select=1195355

YADGOR2000