Report Parameters - Display Boolean Type As CheckBox

I have created a Report Parameter, and set the type of this to "Boolean".

This is displayed as a RadioButton with the options of True or False.

Is there anyway to change this to be displayed as a CheckBox?

Thanks,

Kate

See this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=562091&SiteID=1

Report Parameters

I have a report with a parameter set up for Account name. When I use
the drop down I do display the 5 accounts associated with the 5 rows
data. (One shows in the parameter drop down 3 times because it has
data for 3 different rows.)
Account 1
Account 1
Account 1
Account 2
Account 3
My question is, what else do I need to make the parameter at the top
work, currently my report is not filtering the data by Account. I
still see all 5 rows of data. Do I need a report filter as well?On Oct 1, 10:25 am, BLAW <brad...@.gmail.com> wrote:
> I have a report with a parameter set up for Account name. When I use
> the drop down I do display the 5 accounts associated with the 5 rows
> data. (One shows in the parameter drop down 3 times because it has
> data for 3 different rows.)
> Account 1
> Account 1
> Account 1
> Account 2
> Account 3
> My question is, what else do I need to make the parameter at the top
> work, currently my report is not filtering the data by Account. I
> still see all 5 rows of data. Do I need a report filter as well?
If I understand you correctly, you will want to set your dataset from
the Data tab to a variable. Something like:
select x, y, z, ... from table_x where AccountName = @.AccountName
Then in the Parameters tab (select via Edit Selected Dataset [...] ->
Parameters tab) set the variable @.AccountName (below Parameters:Name)
to Value: =Parameters!AccontName.Value
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Report Parameters

hello
i am building a report which is going to show me list of candidates from
different groups for that i have created a qurey that display group list. and
a qurey display orginal data (candidate list) my problem is i can only select
one group at time for report parameter from group list can i do multi select
from that report pls any one help me out
Adnan AwanOn Oct 4, 10:30 am, Adnan Awan <AdnanA...@.discussions.microsoft.com>
wrote:
> hello
> i am building a report which is going to show me list of candidates from
> different groups for that i have created a qurey that display group list. and
> a qurey display orginal data (candidate list) my problem is i can only select
> one group at time for report parameter from group list can i do multi select
> from that report pls any one help me out
> Adnan Awan
If I'm understanding you correctly, you can create a multi-select
parameter via the Report tab -> Report Parameters... Then in the
stored procedure/query that is sourcing the report, you can create a
while loop to split the multiselect items in the input stored
procedure parameter (normally delimited by commas). You could load a
temp table w/these values and then base your query on ...'where xxxxx
not in (select xxxxx from #SomeTempTable)', etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report parameter 'x' was not found.

I created a simple report to display the default value of a report parameter.
But when I run in VS it works, but when I run it under the "Custom Report"
in SQL Server Managment Studio the report parameter is not found. Below is
the code what am I doing wrong. Thanks in advance for your help.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<DataSourceReference>DataSource1</DataSourceReference>
<rd:DataSourceID>b64e9e97-e752-4d30-8e40-ad77c2582190</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="x">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>5</Value>
</Values>
</DefaultValue>
<Prompt>x</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Left>2in</Left>
<Top>0.375in</Top>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>1.125in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.375in</Height>
<Value>=First(Fields!x.Value, "DataSet1")</Value>
</Textbox>
</ReportItems>
<Height>2in</Height>
</Body>
<rd:ReportID>397ab84d-5c20-454f-9ec1-a1548611ba69</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select @.x x</CommandText>
<QueryParameters>
<QueryParameter Name="@.x">
<Value>=Parameters!x.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="x">
<rd:TypeName>System.Object</rd:TypeName>
<DataField>x</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>6.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>Did you find a solution to this?
--
-sam
"Greg Larsen" wrote:
> I created a simple report to display the default value of a report parameter.
> But when I run in VS it works, but when I run it under the "Custom Report"
> in SQL Server Managment Studio the report parameter is not found. Below is
> the code what am I doing wrong. Thanks in advance for your help.
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <DataSources>
> <DataSource Name="DataSource1">
> <DataSourceReference>DataSource1</DataSourceReference>
> <rd:DataSourceID>b64e9e97-e752-4d30-8e40-ad77c2582190</rd:DataSourceID>
> </DataSource>
> </DataSources>
> <BottomMargin>1in</BottomMargin>
> <RightMargin>1in</RightMargin>
> <ReportParameters>
> <ReportParameter Name="x">
> <DataType>String</DataType>
> <DefaultValue>
> <Values>
> <Value>5</Value>
> </Values>
> </DefaultValue>
> <Prompt>x</Prompt>
> </ReportParameter>
> </ReportParameters>
> <rd:DrawGrid>true</rd:DrawGrid>
> <InteractiveWidth>8.5in</InteractiveWidth>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Left>2in</Left>
> <Top>0.375in</Top>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Width>1.125in</Width>
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <CanGrow>true</CanGrow>
> <Height>0.375in</Height>
> <Value>=First(Fields!x.Value, "DataSet1")</Value>
> </Textbox>
> </ReportItems>
> <Height>2in</Height>
> </Body>
> <rd:ReportID>397ab84d-5c20-454f-9ec1-a1548611ba69</rd:ReportID>
> <LeftMargin>1in</LeftMargin>
> <DataSets>
> <DataSet Name="DataSet1">
> <Query>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> <CommandText>select @.x x</CommandText>
> <QueryParameters>
> <QueryParameter Name="@.x">
> <Value>=Parameters!x.Value</Value>
> </QueryParameter>
> </QueryParameters>
> <DataSourceName>DataSource1</DataSourceName>
> </Query>
> <Fields>
> <Field Name="x">
> <rd:TypeName>System.Object</rd:TypeName>
> <DataField>x</DataField>
> </Field>
> </Fields>
> </DataSet>
> </DataSets>
> <Width>6.5in</Width>
> <InteractiveHeight>11in</InteractiveHeight>
> <Language>en-US</Language>
> <TopMargin>1in</TopMargin>
> </Report>

Report Parameter Display Problem

Hi,
I am developing several reports, I want to pass one parameter from
Report1 to Report2 and also make the same parameter selectable on
Report2. However I figured out that if I pass the parameter from
Report1 to Report2 and Report2 has the same report parameter, then the
parameter bar on the top of Report2 is not displayed. Moreover if I
click the Report2 on the report folder then the Report2 parameter bar
is displayed. How can I force Reporting Services to display the
parameter bar on the Report2?
Configuration:
Win2003 Standard Edition (Latest SP)
SQLServer 2000 (SP2)
SQLReporting Services (SP2)
Visual Studio 2003 (SP1) .Net 1.1
Alp Eren YILMAZAddition Information:
In visual studio Preview page, I can see the parameter on the parameter
bar while navigating from Report1 to Report2 but when I deploy the
reports, I could not see the parameter bar on the second report.
Alp Eren YILMAZ|||I believe there is a toggle on the right side of where the parameter
bar normally is that will display it after you jump to a report.
If you do a jump to url the parameter bar is always displayed.|||Hi Jon,
Yes actually I tried to jumping via URL and the parameters are
displayed but it's a bit hard to maintain the flow of reports because
you have to key the full URL everytime with the report names. Is there
any work around on that issue?
MS People, I found that the issue is resolved in RS2005, is there any
patch for RS2000 for that problem?
Thanks and Regards,
Jon Fife wrote:
> I believe there is a toggle on the right side of where the parameter
> bar normally is that will display it after you jump to a report.
> If you do a jump to url the parameter bar is always displayed.sql

Report Parameter Display Formatting

I have a report where I want to create a boolean parameter that has two radio
buttons, where one radio botton has label "With Approval" and the other radio
buttons label says "No Approval (Under Review or No Request), plus there is
not leading text prior to the first radio. Basically I want my report
parameter display to look like this:
X - With Approval X - No Approval (Under Review or No Request)
Note: X in the above text is the radio button.
How is this done?
I can easily set up the two radio buttons, with a single boolean report
parameter, but I can only get the labels to say "true", or "false", plus a
leading label that says "With Approval". Some thing like this:
With Approval X true X falseAre you using a custom viewer you wrote to render the reports? This is the
only way I know of to use webcontrols other than text boxes and drop down
lists.
"Greg Larsen" wrote:
> I have a report where I want to create a boolean parameter that has two radio
> buttons, where one radio botton has label "With Approval" and the other radio
> buttons label says "No Approval (Under Review or No Request), plus there is
> not leading text prior to the first radio. Basically I want my report
> parameter display to look like this:
> X - With Approval X - No Approval (Under Review or No Request)
> Note: X in the above text is the radio button.
> How is this done?
> I can easily set up the two radio buttons, with a single boolean report
> parameter, but I can only get the labels to say "true", or "false", plus a
> leading label that says "With Approval". Some thing like this:
> With Approval X true X false|||No. I'm just using the standard viewer in Reporting Services.
"Aaron Williams" wrote:
> Are you using a custom viewer you wrote to render the reports? This is the
> only way I know of to use webcontrols other than text boxes and drop down
> lists.
> "Greg Larsen" wrote:
> > I have a report where I want to create a boolean parameter that has two radio
> > buttons, where one radio botton has label "With Approval" and the other radio
> > buttons label says "No Approval (Under Review or No Request), plus there is
> > not leading text prior to the first radio. Basically I want my report
> > parameter display to look like this:
> >
> > X - With Approval X - No Approval (Under Review or No Request)
> >
> > Note: X in the above text is the radio button.
> >
> > How is this done?
> >
> > I can easily set up the two radio buttons, with a single boolean report
> > parameter, but I can only get the labels to say "true", or "false", plus a
> > leading label that says "With Approval". Some thing like this:
> >
> > With Approval X true X false

Report Parameter As CheckBox

Hello Sir,
I m working on Microsoft SQL reporting service tool 2005.
I want to know how can display a checkbox on report parameter form
which is automatilcally build by reporting service tool.
Means i want parameter field as checkbox.
I have a query :
select name from employeesTbl
where Sex = @.ParameterValue
User select designation from multiple CheckBox.
and i think remeber i want to know also that user select only one
checkbox at a time.
There may be number of checkboxes for this.
e.g : Male,Female,OtherOn Jun 21, 2:34 am, Dheeraj <dheeraj.dhiman.daffo...@.gmail.com> wrote:
> Hello Sir,
> I m working on Microsoft SQL reporting service tool 2005.
> I want to know how can display a checkbox on report parameter form
> which is automatilcally build by reporting service tool.
> Means i want parameter field as checkbox.
> I have a query :
> select name from employeesTbl
> where Sex = @.ParameterValue
> User select designation from multiple CheckBox.
> and i think remeber i want to know also that user select only one
> checkbox at a time.
> There may be number of checkboxes for this.
> e.g : Male,Female,Other
If I'm understanding you correctly, you will only be able to use a
checkbox as part of a multi-select parameter. Is there a particular
reason why you can't use the standard drop-down list for the parameter
selections?
Enrique Martinez
Sr. Software Consultant

Report Output

Normally, the report always display like the follow:
Department Employee No. Average Salary
---
HR 15 11250
IT 25 15510
Sales 5 10000
But I want to display the record as the follow: (the record is shown
horizontally, instead of vertical)
Department HR IT Sales
Employee No. 15 25 5
Average Salary 11250 15510 10000
How can I do that ?May Liu,
Use a matrix instead of a table, your scenario is exactly what they are for.
If your query finds a new department it will add another column automatically.
Regards
Chris
"May Liu" wrote:
> Normally, the report always display like the follow:
> Department Employee No. Average Salary
> ---
> HR 15 11250
> IT 25 15510
> Sales 5 10000
> But I want to display the record as the follow: (the record is shown
> horizontally, instead of vertical)
> Department HR IT Sales
> Employee No. 15 25 5
> Average Salary 11250 15510 10000
> How can I do that ?
>

Report Model Descriptions

Does anyone know if there is a way to display the "description" field of an attribute in Report Builder?Descriptions show up as tooltips in the Explorer pane of the Report Builder main window.|||

Thanks Bob,

It's the obvious answers...

Report Manager Home page is incomplete

First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.

All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.

Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.

Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT Authority\Network Service' are insufficient ..."

Some of the settings inside the Report Sever Config are as follows:

Windows Service Identity:

Service Acct: NT Authority\Network Service; Built-in Account: Network Service

Web Service Identity:

Asp.net Service Account; NT Authority\Network Service; Report Server and Manager are both using Classic.Net AppPool

I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.

I just spent two weeks figuring it out. I have a thread on here somewhere called "Vista & SSRS". It's not like one would expect Microsoft to be able to install their own software properly onto their own OS.....

I had to add both Report Mgr & Reporting Services to the Classic .net pool (whatever that is...it's in SSRS config)

I had to turn off that annoying thingie MS added to Vista to make it impossible to do anything - the thing Apple makes fun of in their commercials.

I had to add my user account and adin acct to the IIS user group

I had to install every IIS option, basic install leaves some out.

I think that was all.....good luck

|||

Thanks for the tips, JohnSLG. I had already done all but adding my user and admin accounts to the IIS User group. Unfortunately, my problem is still not resolved.

Just going to have to keep trolling here and Google in the hopes to find an answer. What twists my noodle more than anything is that I went through a helluva long and frustrating effort to get SRSS working before I had to upgrade Vista.

|||

I'm now just so flippin' lost ... Was finally able to access Report Manager after I created a new application pools from the RS Config Manager but then was unable to deploy reports from VS2005 and receive error message that "Report Server Web Service is unable to access secure ... verify WebServiceAccount is specified correctly in report server config file". Then I implusively hit "apply default settings" checkbox and then Apply and now I'm back where I started.

The simple fact is that I can no longer keep track of all the various settings I've changed from IIS Manager to RSConfig Manager to rsreportsever.config, user security settings, new app pools, etc. I'd like to start from scratch. removing every app pool every report server etc but that does not work because that stuff shows up again in RS Config Manager even after uninstall/reinstall. I simply don't know how to remove every last scrap and start the whole damn thing from scratch with the defaults. In short, I'm just in over my head and confused.

Think I'm going back to Access databases where I at least know what in the heck I'm doing. Right now, I'm just simply compounding problems by willy-nilly following every seemingly related tip I find on this board. It's my ignorance, but MS really could have done a much better job in making Reporting Services much less complicated with a simple to follow step by step install and configure instructions for those with my specific setup. I've got Vista Ultimate 64-bit edition with SQL Server 2005 Express SP2 and VS Studio 2005 and all I want to do is run the dam thing on my local machine so I can learn how it works. I want to be able to access the Report Manager via localhost\reports and be able to deploy reports from VS2005. Having to mess around with all these relatively arcane configuration and network settings is a royal pain in the rump.

/frustrated whining and moaning

|||

I hear you....I'm not sure exactly what I did to finally get it to work for me, but I think it was adding the admin user account to the IIS group. I've since dumped Vista 64 - it's ***, no drivers, buggy and went back to Vista - probably should have gone back to XP....I had to go through the same gyrations to get report manager to work again.....fortunately it worked for me after following my 4 step program.

I don't know why Microsoft cannot install their own software on their own operating systems.

Report Manager Home page is incomplete

First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.

All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.

Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.

Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT Authority\Network Service' are insufficient ..."

Some of the settings inside the Report Sever Config are as follows:

Windows Service Identity:

Service Acct: NT Authority\Network Service; Built-in Account: Network Service

Web Service Identity:

Asp.net Service Account; NT Authority\Network Service; Report Server and Manager are both using Classic.Net AppPool

I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.

I just spent two weeks figuring it out. I have a thread on here somewhere called "Vista & SSRS". It's not like one would expect Microsoft to be able to install their own software properly onto their own OS.....

I had to add both Report Mgr & Reporting Services to the Classic .net pool (whatever that is...it's in SSRS config)

I had to turn off that annoying thingie MS added to Vista to make it impossible to do anything - the thing Apple makes fun of in their commercials.

I had to add my user account and adin acct to the IIS user group

I had to install every IIS option, basic install leaves some out.

I think that was all.....good luck

|||

Thanks for the tips, JohnSLG. I had already done all but adding my user and admin accounts to the IIS User group. Unfortunately, my problem is still not resolved.

Just going to have to keep trolling here and Google in the hopes to find an answer. What twists my noodle more than anything is that I went through a helluva long and frustrating effort to get SRSS working before I had to upgrade Vista.

|||

I'm now just so flippin' lost ... Was finally able to access Report Manager after I created a new application pools from the RS Config Manager but then was unable to deploy reports from VS2005 and receive error message that "Report Server Web Service is unable to access secure ... verify WebServiceAccount is specified correctly in report server config file". Then I implusively hit "apply default settings" checkbox and then Apply and now I'm back where I started.

The simple fact is that I can no longer keep track of all the various settings I've changed from IIS Manager to RSConfig Manager to rsreportsever.config, user security settings, new app pools, etc. I'd like to start from scratch. removing every app pool every report server etc but that does not work because that stuff shows up again in RS Config Manager even after uninstall/reinstall. I simply don't know how to remove every last scrap and start the whole damn thing from scratch with the defaults. In short, I'm just in over my head and confused.

Think I'm going back to Access databases where I at least know what in the heck I'm doing. Right now, I'm just simply compounding problems by willy-nilly following every seemingly related tip I find on this board. It's my ignorance, but MS really could have done a much better job in making Reporting Services much less complicated with a simple to follow step by step install and configure instructions for those with my specific setup. I've got Vista Ultimate 64-bit edition with SQL Server 2005 Express SP2 and VS Studio 2005 and all I want to do is run the dam thing on my local machine so I can learn how it works. I want to be able to access the Report Manager via localhost\reports and be able to deploy reports from VS2005. Having to mess around with all these relatively arcane configuration and network settings is a royal pain in the rump.

/frustrated whining and moaning

|||

I hear you....I'm not sure exactly what I did to finally get it to work for me, but I think it was adding the admin user account to the IIS group. I've since dumped Vista 64 - it's ***, no drivers, buggy and went back to Vista - probably should have gone back to XP....I had to go through the same gyrations to get report manager to work again.....fortunately it worked for me after following my 4 step program.

I don't know why Microsoft cannot install their own software on their own operating systems.

Report Manager CreationDate...Display !New

Is there a way to configure how long to display the "!New" icon in the Report
Manger?The icon will display for 48 hours. It is not configurable.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"tjhazel" <tjhazel@.discussions.microsoft.com> wrote in message
news:D9E01423-83AB-43A6-AD8C-24531A09F2DC@.microsoft.com...
> Is there a way to configure how long to display the "!New" icon in the
> Report
> Manger?
>

Report Hiding Duplicates, not wanted

I created a report which has duplicates on one field. I want the report to display the duplicates, but cannot figure out how. Anywhere I have found where there is a "Hide Duplicates" option I have it turned off (in matrix properties), but the report matrix still hides the duplicates. I don't understand why this would happen since the other fields on the same record are not duplicates. I tried grouping but that was no help.

The query in the dataset DOES return the duplicates as expected.

Anyone know how to fix this, or if it is a bug?

Thanks,

Chris

Hide Duplicates could be set to true in one of your textboxes. Right click on all of your matrix columns (which are textboxes) and go to Properties where you will Hide Duplicates checkbox. Or you can even select the textbox and click on F4 to see the Properties window.

Shyam