Adding a check box to a report

I need to create a nice fomatted report in RS and part of that is checking a box if the data = Yes. Is there a way to add controlsOk try this, I spent a little time but was able to find a way to make it work with a list control,
Add the list,
Drag and drop the Image control, bring in a checked and unchecked image and have them embedded in the report. You can even have the images stacked ontop of eachother, so that they will have the same alignment in the report row for row,
Go to the properties area for the image, go to the visibilty area, and choose Expression,
I find that the expression box works a little counter intuitive, so for the unchecked/other than "yes" box do this
=Fields!YourField.Value = "Yes"
Then If the field value is = "Yes" (make sure its cased correctly) then the unchecked box will appear,
=Fields!YourField.Value <> "Yes"
Conversley have it check for if it is not equal to "Yes" and It will have the checked box appear. It seems backwards but i guess the visibility expression takes the negative or something funny, Heres a lil screen shot of what i got,...


I dont see why this couldnt work in a table or matrix control if it came to that
Happy Reporting!!

add memory?

Hi,
I'm checking my performance of sql 2000 ent. on a w2k adv. server. There
are 2gb's of memory available. the server is dedicated for sql server
(at least i think it is).
I've noticed that the counter sql server: cache manager - cache hit
ratio is on average 67-70. The counter sql server:buffer manager -
buffer cache hit ratio is always above 99%. SQL Server uses dynamic mem
alloc.
All other import counters like processor and physical disk shows low values.
Could there be a memory bottleneck where the asigned cache for sql is
too low?You donâ't have a memory issue.
From SQL Server Books Online (BOL):
â'SQL Server: Cache Manager Object
The Cache Manager object provides counters to monitor how Microsoft® SQL
Serverâ?¢ uses memory to store objects such as stored procedures, ad hoc and
prepared Transact-SQL statements, and triggers.â'
Any SP, Trigger or Transact-SQL statements which are being called for the
1st time will not have an Execution Plan kept in the Cache. Besides, there
are many scenarios when SQL Server decides to generate a fresh Execution
Plan.
Have a look at the â'Execution Plan Caching and Reuseâ' topic in the BOL.
"Jason" wrote:
> Hi,
> I'm checking my performance of sql 2000 ent. on a w2k adv. server. There
> are 2gb's of memory available. the server is dedicated for sql server
> (at least i think it is).
> I've noticed that the counter sql server: cache manager - cache hit
> ratio is on average 67-70. The counter sql server:buffer manager -
> buffer cache hit ratio is always above 99%. SQL Server uses dynamic mem
> alloc.
> All other import counters like processor and physical disk shows low values.
> Could there be a memory bottleneck where the asigned cache for sql is
> too low?
>

add memory?

Hi,
I'm checking my performance of sql 2000 ent. on a w2k adv. server. There
are 2gb's of memory available. the server is dedicated for sql server
(at least i think it is).
I've noticed that the counter sql server: cache manager - cache hit
ratio is on average 67-70. The counter sql server:buffer manager -
buffer cache hit ratio is always above 99%. SQL Server uses dynamic mem
alloc.
All other import counters like processor and physical disk shows low values.
Could there be a memory bottleneck where the asigned cache for sql is
too low?You don’t have a memory issue.
From SQL Server Books Online (BOL):
“SQL Server: Cache Manager Object
The Cache Manager object provides counters to monitor how Microsoft? SQL
Server? uses memory to store objects such as stored procedures, ad hoc and
prepared Transact-SQL statements, and triggers.”
Any SP, Trigger or Transact-SQL statements which are being called for the
1st time will not have an Execution Plan kept in the Cache. Besides, there
are many scenarios when SQL Server decides to generate a fresh Execution
Plan.
Have a look at the ‘Execution Plan Caching and Reuse’ topic in the BOL.
"Jason" wrote:

> Hi,
> I'm checking my performance of sql 2000 ent. on a w2k adv. server. There
> are 2gb's of memory available. the server is dedicated for sql server
> (at least i think it is).
> I've noticed that the counter sql server: cache manager - cache hit
> ratio is on average 67-70. The counter sql server:buffer manager -
> buffer cache hit ratio is always above 99%. SQL Server uses dynamic mem
> alloc.
> All other import counters like processor and physical disk shows low value
s.
> Could there be a memory bottleneck where the asigned cache for sql is
> too low?
>

Add a variable from custom component

Hi

I am writing a custom transformation component that utilises a user variable.

Before using the variable at run time I am checking that the variable exists, but it would be nice to be able to add it if it does not. I cannot find any documentation on the subject, though I can see that the Variables class is derived from a ReadOnlyCollectionBase.

Is there a way to add a user variable with package scope from a custom component, either at run time or design time?

Thanks . . . Ed

I do not think it is possible currently.

Thanks.