High Performance SQL Server (article)

I posted a link to a prior article in here, that one about high
performance hierarchies, and have the first two parts of a new series.
Hopefully this is of value to someone.

http://www.yafla.com/papers/SQL_Ser..._sql_server.htm

Thanks.Thank you article!
It make me to know what is bookmark lookup?
and why sometimes use full table scan.

Thank again. I wait and see your PART IIII will come soon.

> I posted a link to a prior article in here, that one about high
> performance hierarchies, and have the first two parts of a new series.
> Hopefully this is of value to someone.

Hiding parts of the report

Hello All,
I have to generate a report based on parameters. And each part of the
report depends based a particular set of parameters.
Is there a way to hide the parts of the report that i dont need to show
?
Thankx
BofoDid you look into the Visibility.Hidden property of reportitems? You can use
expressions based on parameter values to statically or dynamically hide
certain areas of a report.
More information can be found here:
*
http://msdn.microsoft.com/library/en-us/RShowto/htm/hrs_designer_v1_3kq5.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_0rc7.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Win2003InstallIssues" <bofobofo@.yahoo.com> wrote in message
news:1107047048.476551.144590@.c13g2000cwb.googlegroups.com...
> Hello All,
> I have to generate a report based on parameters. And each part of the
> report depends based a particular set of parameters.
> Is there a way to hide the parts of the report that i dont need to show
> ?
>
> Thankx
> Bofo
>|||Hello Robert,
I am partially successful in using the Hiding/hidden properties.
Here is the issue.
I have 7 diff parameters to my report, 2 main groups say A and B to gen
Areport and Breport
if the user enters any of the fields of Group A, the ReportB should not
appear and vice-versa.
Now I tried using the parameter.value of the Group B to hide Breport.
But to no avail. I can still see the Textbox label.
I can hide the table cos I created dummy fields in Select and use them
as the Labels for the table columns.
But what I need is something that will hide the entire part of the
report.
Any Ideas on how to go about it ?
Thx|||Finally got it.
This is the expr.
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo

Hiding Parts of a report.

I'm using a PageViewer control in SharePoint to view a Report in SQL Server,
so the URL that is pulling up is something like
http://servername/ReportServer/Pages/ReportViewer.aspx?%2fOceanSpray.SharePoint.OsciReports%2fSavings+By+Plant&rs:Command=Render
The report comes up and displays the report information the way that I want
it to, but what I would like to be able to do in some instance where I'm
doing this is to header the header information of the report. By the header
I'm refering to the Page Navigation, Zoom, Find, Export and Print Toolbar
that gets added above the report information.
Is there a way to remove this Toolbar?Search for URL Access in Books on line -.. The toolbar option ie
http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Paul" wrote:
> I'm using a PageViewer control in SharePoint to view a Report in SQL Server,
> so the URL that is pulling up is something like
> http://servername/ReportServer/Pages/ReportViewer.aspx?%2fOceanSpray.SharePoint.OsciReports%2fSavings+By+Plant&rs:Command=Render
> The report comes up and displays the report information the way that I want
> it to, but what I would like to be able to do in some instance where I'm
> doing this is to header the header information of the report. By the header
> I'm refering to the Page Navigation, Zoom, Find, Export and Print Toolbar
> that gets added above the report information.
> Is there a way to remove this Toolbar?

Hiding data regions based on Parameters

Hello all,
I have two parts in my report. Each part needs a diff set of
parameters.
Need a way to hide one of the 2 parts based on the parameters typed in
(like if they type in A or B or C i need to hide ReportX and vice-versa
if they type in D, E, F). Tried the table properties Visibility
properties but not much success.
Any ideas will be appreciated.
Thx
BofoI am able to get the thing working by using the following expression.
iif(Parameters!param1.Value="", TRUE, FALSE)
But the problem is I have 4 params like this.
I am trying to use the iif inside an iif. But havent had success yet.
Thx
Bofo|||iif(Parameters!param_numAvPrevia.Value="",
iif(Parameters!param_avPreviadesde.Value="",
iif(Parameters!param_avPreviaHasta.Value="",
iif(Parameters!param_estado.Value="", TRUE, FALSE), FALSE), FALSE),
FALSE)
trying the above expression. But no success yet.
I get the error saying its not a proper boolean value.|||finally Got it going.
Thought may help someone.
Here is the expr i am using for the Visibility.hidden
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo|||finally Got it going.
Thought may help someone.
Here is the expr i am using for the Visibility.hidden
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo