Homemade Stress Test

I am trying to make a "homemade stress test" for an application we are
wanting to deploy soon. My idea was to make a few querys in MSAccess to do
some updates on tables in the database. I want to run the querys long enough
to see the transaction log grow. Has anyone tried something like this? I
just need some way to simulate activity to make the transaction log to grow.
Have a look here:
http://support.microsoft.com/?kbid=887057
Andrew J. Kelly SQL MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:01E6E7A7-1223-4E5C-8371-A800D8D43EB8@.microsoft.com...
>I am trying to make a "homemade stress test" for an application we are
> wanting to deploy soon. My idea was to make a few querys in MSAccess to
> do
> some updates on tables in the database. I want to run the querys long
> enough
> to see the transaction log grow. Has anyone tried something like this? I
> just need some way to simulate activity to make the transaction log to
> grow.

Homemade Stress Test

I am trying to make a "homemade stress test" for an application we are
wanting to deploy soon. My idea was to make a few querys in MSAccess to do
some updates on tables in the database. I want to run the querys long enoug
h
to see the transaction log grow. Has anyone tried something like this? I
just need some way to simulate activity to make the transaction log to grow.Have a look here:
http://support.microsoft.com/?kbid=887057
Andrew J. Kelly SQL MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:01E6E7A7-1223-4E5C-8371-A800D8D43EB8@.microsoft.com...
>I am trying to make a "homemade stress test" for an application we are
> wanting to deploy soon. My idea was to make a few querys in MSAccess to
> do
> some updates on tables in the database. I want to run the querys long
> enough
> to see the transaction log grow. Has anyone tried something like this? I
> just need some way to simulate activity to make the transaction log to
> grow.

Homemade Stress Test

I am trying to make a "homemade stress test" for an application we are
wanting to deploy soon. My idea was to make a few querys in MSAccess to do
some updates on tables in the database. I want to run the querys long enough
to see the transaction log grow. Has anyone tried something like this? I
just need some way to simulate activity to make the transaction log to grow.Have a look here:
http://support.microsoft.com/?kbid=887057
--
Andrew J. Kelly SQL MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:01E6E7A7-1223-4E5C-8371-A800D8D43EB8@.microsoft.com...
>I am trying to make a "homemade stress test" for an application we are
> wanting to deploy soon. My idea was to make a few querys in MSAccess to
> do
> some updates on tables in the database. I want to run the querys long
> enough
> to see the transaction log grow. Has anyone tried something like this? I
> just need some way to simulate activity to make the transaction log to
> grow.

History Tables

Can someone please give me a quick explanation for using histoy tables in an application. The usage i am looking at is a Date of Birth field on an order form to be used later fro reporting purposes.Maybe I'm wrong, but here it is: history tables are to be used to record changes of some data elements through time. In your example, there are customers who fill order forms and choose one or more items every time. Now, it is possible to write a report and show all items customer ordered in the past. This makes sense to me.

But, what kind of a history element is a date of birth? Everyone has only one date of birth and this information is always valid - 7 years ago, today, next year and in 500 years ...|||Perhaps i didn't explain it correctly.
i need to make a DOB field on an existing order form a required field so that this order may be pulled at a later date to record how many people over a certain age ordered the product. I thought it might be wise to create a history table so that running the query for the report would not cause a drain on the application. am I wrong?|||If you are building a data warehouse, then it would probably make sense. Otherwise, storing "date of birth" column along with "orders" would be an example of denormalized design. Unless there is a good reason to do so, I'd rather see "date of birth" along with customer data (name, address, ...); orders should contain a foreign key column to join "order" with a customer.

Highlight row

Hi,

After the report is rendered in the report viewer control (In windows forms application), I want to provide user with a facility to highlight rows (data). Is it possible with SSRS/Report viewer?

For example, amongst the list of 100 invoices, user should be able to highlight 10 invoices.

Thanks in advance.

Paresh

Not real easily. The only approach I can think of is to have a multi-value parameter on the report which contains invoice numbers. The user would need to select invoice report parameter values equal to the invoice numbers to highlight, then rerun the report checking to see if the row matched the selected report parameter values.

In other words, not real easily.

Highlight Keywords

I am using asp.net (C#) to create full text searching using SQL Server
2005 in our application. Everything is working fine, but I am trying
to highlight the resultset keywords from the full text results. Can
sql server provide you with a way to highlight the keywords from the
full text search?
I was able to kind of hack it by programatically replacing my keyword
search terms with the sql server resultset. However, when I do certain
searches, like "Frank's", sql server will return Frank using my
CONTAINS query, and I want the other results like "Frank" to be
highlighted too. Anyone know a good way to go about doing this?
Thanks
You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.
http://www.indexserverfaq.com/sqlhithighlighting.htm
"guate911" <guatemala911@.gmail.com> wrote in message
news:1179417689.771131.84700@.k79g2000hse.googlegro ups.com...
>I am using asp.net (C#) to create full text searching using SQL Server
> 2005 in our application. Everything is working fine, but I am trying
> to highlight the resultset keywords from the full text results. Can
> sql server provide you with a way to highlight the keywords from the
> full text search?
> I was able to kind of hack it by programatically replacing my keyword
> search terms with the sql server resultset. However, when I do certain
> searches, like "Frank's", sql server will return Frank using my
> CONTAINS query, and I want the other results like "Frank" to be
> highlighted too. Anyone know a good way to go about doing this?
> Thanks
>

High reads

Some of my sps are showing high reads if executed from a >net application.
Like if sp is executed from .net app it shows some wayy around 5000000
reads and does not complete even in 10 min. Same sp , same time on th e same
server executes in 10 sec using sql query analyzer, and shows 30000 reads.
Can anyonme explains whats the problem?Bad query plans. Try adding the option WITH RECOMPILE to your stored
procedures.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"VSS" <aa@.aa> wrote in message news:e04bYa6rGHA.2452@.TK2MSFTNGP03.phx.gbl...
> Some of my sps are showing high reads if executed from a >net application.
> Like if sp is executed from .net app it shows some wayy around 5000000
> reads and does not complete even in 10 min. Same sp , same time on th e
> same
> server executes in 10 sec using sql query analyzer, and shows 30000 reads.
> Can anyonme explains whats the problem?
>|||Check whether SET NCOUNT ON is set in SP .
M A Srinivas
VSS wrote:
> Some of my sps are showing high reads if executed from a >net application.
> Like if sp is executed from .net app it shows some wayy around 5000000
> reads and does not complete even in 10 min. Same sp , same time on th e sa
me
> server executes in 10 sec using sql query analyzer, and shows 30000 reads.
> Can anyonme explains whats the problem?

High reads

Some of my sps are showing high reads if executed from a >net application.
Like if sp is executed from .net app it shows some wayy around 5000000
reads and does not complete even in 10 min. Same sp , same time on th e same
server executes in 10 sec using sql query analyzer, and shows 30000 reads.
Can anyonme explains whats the problem?Bad query plans. Try adding the option WITH RECOMPILE to your stored
procedures.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"VSS" <aa@.aa> wrote in message news:e04bYa6rGHA.2452@.TK2MSFTNGP03.phx.gbl...
> Some of my sps are showing high reads if executed from a >net application.
> Like if sp is executed from .net app it shows some wayy around 5000000
> reads and does not complete even in 10 min. Same sp , same time on th e
> same
> server executes in 10 sec using sql query analyzer, and shows 30000 reads.
> Can anyonme explains whats the problem?
>|||Check whether SET NCOUNT ON is set in SP .
M A Srinivas
VSS wrote:
> Some of my sps are showing high reads if executed from a >net application.
> Like if sp is executed from .net app it shows some wayy around 5000000
> reads and does not complete even in 10 min. Same sp , same time on th e same
> server executes in 10 sec using sql query analyzer, and shows 30000 reads.
> Can anyonme explains whats the problem?

high availability

Does anyone know any application which can provide high availability
solution for SQL2000? Thanks.> Does anyone know any application which can provide high availability
> solution for SQL2000? Thanks.
>
Failover Clustering is the solution - check it at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
Additionally, you can use Log Shipping -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||If you have a serious requirement you should look at ftserver from Stratus
and Double take.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > Does anyone know any application which can provide high availability
> > solution for SQL2000? Thanks.
> >
> Failover Clustering is the solution - check it at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> Additionally, you can use Log Shipping -
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>|||Ladies and gentlement,
Thanks for the advice. Will have a look on that.
Supernova
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Do you know what is advantage of the double take over the failover
clustering in SQL 2000?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> > > Does anyone know any application which can provide high availability
> > > solution for SQL2000? Thanks.
> > >
> > Failover Clustering is the solution - check it at
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp.
> > Additionally, you can use Log Shipping -
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>

high availability

Does anyone know any application which can provide high availability
solution for SQL2000? Thanks.> Does anyone know any application which can provide high availability
> solution for SQL2000? Thanks.
>
Failover Clustering is the solution - check it at
http://msdn.microsoft.com/library/d...ering_7t9v.asp.
Additionally, you can use Log Shipping -
http://msdn.microsoft.com/library/d...
ver_8elj.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||If you have a serious requirement you should look at ftserver from Stratus
and Double take.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
> Failover Clustering is the solution - check it at
>
http://msdn.microsoft.com/library/d...9v.a
sp.
> Additionally, you can use Log Shipping -
>
http://msdn.microsoft.com/library/d...lj.asp
.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>|||Ladies and gentlement,
Thanks for the advice. Will have a look on that.
Supernova
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Do you know what is advantage of the double take over the failover
clustering in SQL 2000?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>|||Does anyone know product which is similar to Double Take?
"Tiffany" <tiffany.edwards@.vodafone.net> wrote in message
news:O0sNGsi9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> If you have a serious requirement you should look at ftserver from Stratus
> and Double take.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:O4PV3ph9DHA.3900@.tk2msftngp13.phx.gbl...
>
http://msdn.microsoft.com/library/d...9v.a
sp.
>
http://msdn.microsoft.com/library/d...lj.asp
.
>

Hiding URL from User

I have a web application written in ASP, not ASP.Net. We set up a page with an iframe that we populate the SSRS reports into. The url of the report is visible through a right click/properties. Is there a way to either disable the right click or hide the url?

you can disable the right click by adding oncontextmenu="return false" in the body tag:

<body oncontextmenu="return false">

Hiding the DB Design.

Hi all,

I am going to install my application at my Client's place.

I do not want them to know about my DB design and also i have a lot of master information that I dont want the Client to view.

The Client insists that he would have the Super Administrator user ids and passwords (ie. "sa" - user).

Is there any way i can encrypt my DB design and the data in the DB.

Or is there any other way of restricting the Client from viewing my DB design and data?

Thanks

VishalDisallowing access to the Super User ... i dont think its possible in any system ...|||So how do i hide the DB design?
Is there any way?
May be encription?

Pls suggest...|||Not posible to hide anything from the System Admin user|||Though you may encrypt your stored procs .. decryption algorithms for those are readily availible on the net.|||Hi,

Thanks.

So there is no way that the DB design can be hidden.

Except that I hold the Super Admin password with myself?

Hiding table contents without sacrificing too much on performance?

An application uses a database table having proprietary information. We do not want our customer to be able to look at that.

This being a real-time application, performance can not be sacrificed. What is the best way to keep the table data non-viewable without sacrificing the performance?

The easiest way to do this without sacrificing performance is to use permissions and deny select or view permissions on the table in question. Create a special group and only grant that one group access to the table.

This, of course, only protects against an online attack (i.e. the server is running). To protect your database against an offline attack (i.e. someone steals your hard drive), you will need to use some form of encryption. Unfortunately, this does require a performance hit. Depending on how you structure your data, this could be either very large or pretty minor.

If your customer is a database admin, the only way to secure against this would be to use encryption.

Sung

|||

I think Rajeev is looking for some DRM type of solution, in which case this has already been discussed on threads like http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=52094&SiteID=1.

Thanks
Laurentiu

Hiding System Tables when connecting with non-microsoft clients

I have a user who would like to connect to a SQL Server database using SAS (a
statistical application) and have the system tables not be displayed
Currently, when the user connects they are shown all of the tables
(including system table). We have inquired on the SAS side and have been
told that it is something that must be on the database side.
Do I need to remove some default permissions? Or send a special connection
string? I know in Ent. Manager, you just clear the show system tables
checkbox - but there is not an option like that when connecting with SAS.
No, it is not something that you can do in the database. You'll have to get
your SAS guys to change their query that retreives the table list. For
example, the following query returns system and user tables, where as the
second one doesn't:
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
--AND OBJECTPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME),
'isMSShipped') = 0
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME),
'isMSShipped') = 0
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Mike" <Mics_79@.online.nospam> wrote in message
news:AD6C6A91-7912-429F-90BA-7169CA29B641@.microsoft.com...
I have a user who would like to connect to a SQL Server database using SAS
(a
statistical application) and have the system tables not be displayed
Currently, when the user connects they are shown all of the tables
(including system table). We have inquired on the SAS side and have been
told that it is something that must be on the database side.
Do I need to remove some default permissions? Or send a special connection
string? I know in Ent. Manager, you just clear the show system tables
checkbox - but there is not an option like that when connecting with SAS.

Hiding SOME parameters in the parameter toolbar

I am using the ReportViewer.dll in a ASP.NET web application. The report
being displayed takes 2 parameters. One of these is programmatically set. I
would like the user to select values only for the other parameter. So when
displaying the report within the control, can I just show the second
parameter on the toolbar and hide the first one?
The Parameters toolbar property in the ReportViewer control corresponds to
the 'Parameters' URL access parameter, which hides/displays the entire
parameter toolbar
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?OK I solved the problem...You just type in a blank string for the Prompt
value...
"Aparna" wrote:
> I am using the ReportViewer.dll in a ASP.NET web application. The report
> being displayed takes 2 parameters. One of these is programmatically set. I
> would like the user to select values only for the other parameter. So when
> displaying the report within the control, can I just show the second
> parameter on the toolbar and hide the first one?
> The Parameters toolbar property in the ReportViewer control corresponds to
> the 'Parameters' URL access parameter, which hides/displays the entire
> parameter toolbar
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?|||On Wed, 26 Jan 2005 12:21:03 -0800, Aparna
<Aparna@.discussions.microsoft.com> wrote:
>OK I solved the problem...You just type in a blank string for the Prompt
>value...
>
How exactly does one "type in" a blank string? :)))
>"Aparna" wrote:
>> I am using the ReportViewer.dll in a ASP.NET web application. The report
>> being displayed takes 2 parameters. One of these is programmatically set. I
>> would like the user to select values only for the other parameter. So when
>> displaying the report within the control, can I just show the second
>> parameter on the toolbar and hide the first one?
>> The Parameters toolbar property in the ReportViewer control corresponds to
>> the 'Parameters' URL access parameter, which hides/displays the entire
>> parameter toolbar
>> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?|||haha...Not quite sure...However, it turns out my excitement was in vain...If
the prompt value is not specified, then the paratmeter becomes Read-only..So,
if you programatically want to assign values to it, you are out of luck! The
only way to set the value of that parameter is via the parameter property
page. So my orginal problem still stands...SOMEBODY HELLLP...
"Usenet User" wrote:
> On Wed, 26 Jan 2005 12:21:03 -0800, Aparna
> <Aparna@.discussions.microsoft.com> wrote:
> >OK I solved the problem...You just type in a blank string for the Prompt
> >value...
> >
> How exactly does one "type in" a blank string? :)))
>
> >"Aparna" wrote:
> >
> >> I am using the ReportViewer.dll in a ASP.NET web application. The report
> >> being displayed takes 2 parameters. One of these is programmatically set. I
> >> would like the user to select values only for the other parameter. So when
> >> displaying the report within the control, can I just show the second
> >> parameter on the toolbar and hide the first one?
> >>
> >> The Parameters toolbar property in the ReportViewer control corresponds to
> >> the 'Parameters' URL access parameter, which hides/displays the entire
> >> parameter toolbar
> >> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?
>