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 of the Best Prctice Analyser

First of all I have to say THANK YOU to Microsoft for that tool.
It is a great tool for managing SQL databases - we got many many intersting
hints to enhance our SQL servers.
Using that tool we now got two interesting things:
On our server we're also hosting the Sharepoint databases of the Sharepoint
Services - a Microsoft product!
When scanning the server with BPA the most reported databases were the
Sharepoint databases! I gave this information to Mike Fitzmaurice of the
Sharepoint team yet!
But we have an own problem too! Maybe someone can help:
We had (don't know why!) some tables an stored procedures in our master
database - BPA told us this!
Then we dropped these objects because we don't need them.
Now BPA tells us that 2 user objects remained in the master database:
Scan Details
...
Object Name Object Type Object Type Description
pk_dtproperties PK PRIMARY KEY constraint
DF__dtpropert__versi__4A0EDAD1 D Default or DEFAULT constraint
...
How can we get rid of these objects?
Many thanks in advance
Thomas
Seems like these constraints are associated with a table dt_properties (used
for storing database diagrams). Can you check if this exists in your master
database?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Mueller-Lynch Thomas" <MuellerLynchThomas@.discussions.microsoft.com> wrote
in message news:63A92A40-BF14-4DE6-B43B-30C400266365@.microsoft.com...
First of all I have to say THANK YOU to Microsoft for that tool.
It is a great tool for managing SQL databases - we got many many intersting
hints to enhance our SQL servers.
Using that tool we now got two interesting things:
On our server we're also hosting the Sharepoint databases of the Sharepoint
Services - a Microsoft product!
When scanning the server with BPA the most reported databases were the
Sharepoint databases! I gave this information to Mike Fitzmaurice of the
Sharepoint team yet!
But we have an own problem too! Maybe someone can help:
We had (don't know why!) some tables an stored procedures in our master
database - BPA told us this!
Then we dropped these objects because we don't need them.
Now BPA tells us that 2 user objects remained in the master database:
Scan Details
...
Object Name Object Type Object Type Description
pk_dtproperties PK PRIMARY KEY constraint
DF__dtpropert__versi__4A0EDAD1 D Default or DEFAULT constraint
...
How can we get rid of these objects?
Many thanks in advance
Thomas

Report not in Database

I have a Tool Program (Tool Manager from QuickPen) that I need to add a feild that is in another report but I can't figure out how to get that feild in there I have tried to copy and paste but I get this error ( The field RptData.DisplayID does not exist in the database of this report)

Does anyone have any idea how I can fix this?If you copy a database field to another report, you must first make sure that your have the same database table and same field in the report you are pasting to. To be more precise, the table alias must be the same.
You can also copy and paste formulas, but all fields used in formula must also be present in destination report.