High Light Words in Query

I creating an SQL script that will query a database and return the results to an html page. The script searches for a keyword and then displays the results. What I want to do is when the result is returned, I want to highlight the word that was being searched in the result set. I would like the word to be bolded in the query. How can this be done?please, don't cross-post

see http://www.dbforums.com/t1100603.html

High Availability over Distance

Hi,
I am looking for suggestions on creating a mirror site. Currently we have a
SQL server in a MS Cluster Environment. We will be creating another
clustered environment which will be 5+ miles away from the primary site.
What is the best way to create a mirror of the primary site?
I am looking for the Best option available (MS or third party). Currently I
am looking at Double Take and Replistor. We have sued Replistor in the past
with some good and very bad experiences. Primary goal is to make sure
secondary site is always up to date (within a minute or so). Money is not an
object (within reason, No Million $ options please :-) )
Thank you.
Hi Henrik,
Just be careful at using the high availabilty mode when the servers
(partners) are not on the same data center and pay special attention to
network reliability, network throughput and performance.
Take a look at this paper
Database Mirroring Best Practices and Performance Considerations
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Henrik Davidsen" wrote:

> Try to read up on SQL Server's Mirroring feature.
>
> There are different modes the mirroring can operate in. One is a High
> Availability mode, whichs offers guarantee that the mirror is ALWAYS 100%
> up-to-date. That however produces some performance degrading. But read up on
> the mirroring
>
> The mirrorring funktionality is available within SQL Server 2005, so no
> extra expenses is nessecary.
> /Sjang
>
>
|||Thanks Guys. I will look into mirroring for sure.
What about any other options?
Thanks.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...[vbcol=seagreen]
> Hi Henrik,
> Just be careful at using the high availabilty mode when the servers
> (partners) are not on the same data center and pay special attention to
> network reliability, network throughput and performance.
> Take a look at this paper
> Database Mirroring Best Practices and Performance Considerations
> http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Henrik Davidsen" wrote:
|||There are technologies available from SAN vendors. Although they probably
have million dollar + price tags. Call up EMC and tell them what you want to
do.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Dragon" <noSpam_baadil@.hotmail.com> wrote in message
news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
> Thanks Guys. I will look into mirroring for sure.
> What about any other options?
> Thanks.
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...
>
|||Thank you Jason.
"jason" <jason-r3move@.statisticsio.com> wrote in message
news:72BEA593-F945-4A39-B413-E25B118AFA7B@.microsoft.com...
> There are technologies available from SAN vendors. Although they probably
> have million dollar + price tags. Call up EMC and tell them what you want
> to do.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "Dragon" <noSpam_baadil@.hotmail.com> wrote in message
> news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
>

High Availability over Distance

Hi,
I am looking for suggestions on creating a mirror site. Currently we have a
SQL server in a MS Cluster Environment. We will be creating another
clustered environment which will be 5+ miles away from the primary site.
What is the best way to create a mirror of the primary site?
I am looking for the Best option available (MS or third party). Currently I
am looking at Double Take and Replistor. We have sued Replistor in the past
with some good and very bad experiences. Primary goal is to make sure
secondary site is always up to date (within a minute or so). Money is not an
object (within reason, No Million $ options please :-) )
Thank you.> I am looking for suggestions on creating a mirror site.
Try to read up on SQL Server's Mirroring feature.

> Primary goal is to make sure secondary site is always up to date (within a
> minute or so).
There are different modes the mirroring can operate in. One is a High
Availability mode, whichs offers guarantee that the mirror is ALWAYS 100%
up-to-date. That however produces some performance degrading. But read up on
the mirroring

> Money is not an object (within reason, No Million $ options please :-) )
The mirrorring funktionality is available within SQL Server 2005, so no
extra expenses is nessecary.
/Sjang|||Hi Henrik,
Just be careful at using the high availabilty mode when the servers
(partners) are not on the same data center and pay special attention to
network reliability, network throughput and performance.
Take a look at this paper
Database Mirroring Best Practices and Performance Considerations
http://www.microsoft.com/technet/pr...ct.
mspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Henrik Davidsen" wrote:

> Try to read up on SQL Server's Mirroring feature.
>
> There are different modes the mirroring can operate in. One is a High
> Availability mode, whichs offers guarantee that the mirror is ALWAYS 100%
> up-to-date. That however produces some performance degrading. But read up
on
> the mirroring
>
> The mirrorring funktionality is available within SQL Server 2005, so no
> extra expenses is nessecary.
> /Sjang
>
>|||Thanks Guys. I will look into mirroring for sure.
What about any other options?
Thanks.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...[vbcol=seagreen]
> Hi Henrik,
> Just be careful at using the high availabilty mode when the servers
> (partners) are not on the same data center and pay special attention to
> network reliability, network throughput and performance.
> Take a look at this paper
> Database Mirroring Best Practices and Performance Considerations
> http://www.microsoft.com/technet/pr...c
t.mspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Henrik Davidsen" wrote:
>|||There are technologies available from SAN vendors. Although they probably
have million dollar + price tags. Call up EMC and tell them what you want to
do.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Dragon" <noSpam_baadil@.hotmail.com> wrote in message
news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
> Thanks Guys. I will look into mirroring for sure.
> What about any other options?
> Thanks.
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...
>|||Thank you Jason.
"jason" <jason-r3move@.statisticsio.com> wrote in message
news:72BEA593-F945-4A39-B413-E25B118AFA7B@.microsoft.com...
> There are technologies available from SAN vendors. Although they probably
> have million dollar + price tags. Call up EMC and tell them what you want
> to do.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "Dragon" <noSpam_baadil@.hotmail.com> wrote in message
> news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
>

High Availability over Distance

Hi,
I am looking for suggestions on creating a mirror site. Currently we have a
SQL server in a MS Cluster Environment. We will be creating another
clustered environment which will be 5+ miles away from the primary site.
What is the best way to create a mirror of the primary site?
I am looking for the Best option available (MS or third party). Currently I
am looking at Double Take and Replistor. We have sued Replistor in the past
with some good and very bad experiences. Primary goal is to make sure
secondary site is always up to date (within a minute or so). Money is not an
object (within reason, No Million $ options please :-) )
Thank you.> I am looking for suggestions on creating a mirror site.
Try to read up on SQL Server's Mirroring feature.
> Primary goal is to make sure secondary site is always up to date (within a
> minute or so).
There are different modes the mirroring can operate in. One is a High
Availability mode, whichs offers guarantee that the mirror is ALWAYS 100%
up-to-date. That however produces some performance degrading. But read up on
the mirroring :)
> Money is not an object (within reason, No Million $ options please :-) )
The mirrorring funktionality is available within SQL Server 2005, so no
extra expenses is nessecary.
/Sjang|||Hi Henrik,
Just be careful at using the high availabilty mode when the servers
(partners) are not on the same data center and pay special attention to
network reliability, network throughput and performance.
Take a look at this paper
Database Mirroring Best Practices and Performance Considerations
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Henrik Davidsen" wrote:
> > I am looking for suggestions on creating a mirror site.
> Try to read up on SQL Server's Mirroring feature.
> > Primary goal is to make sure secondary site is always up to date (within a
> > minute or so).
> There are different modes the mirroring can operate in. One is a High
> Availability mode, whichs offers guarantee that the mirror is ALWAYS 100%
> up-to-date. That however produces some performance degrading. But read up on
> the mirroring :)
> > Money is not an object (within reason, No Million $ options please :-) )
> The mirrorring funktionality is available within SQL Server 2005, so no
> extra expenses is nessecary.
> /Sjang
>
>|||Thanks Guys. I will look into mirroring for sure.
What about any other options?
Thanks.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...
> Hi Henrik,
> Just be careful at using the high availabilty mode when the servers
> (partners) are not on the same data center and pay special attention to
> network reliability, network throughput and performance.
> Take a look at this paper
> Database Mirroring Best Practices and Performance Considerations
> http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Henrik Davidsen" wrote:
>> > I am looking for suggestions on creating a mirror site.
>> Try to read up on SQL Server's Mirroring feature.
>> > Primary goal is to make sure secondary site is always up to date
>> > (within a
>> > minute or so).
>> There are different modes the mirroring can operate in. One is a High
>> Availability mode, whichs offers guarantee that the mirror is ALWAYS 100%
>> up-to-date. That however produces some performance degrading. But read up
>> on
>> the mirroring :)
>> > Money is not an object (within reason, No Million $ options please
>> > :-) )
>> The mirrorring funktionality is available within SQL Server 2005, so no
>> extra expenses is nessecary.
>> /Sjang
>>|||There are technologies available from SAN vendors. Although they probably
have million dollar + price tags. Call up EMC and tell them what you want to
do.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Dragon" <noSpam_baadil@.hotmail.com> wrote in message
news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
> Thanks Guys. I will look into mirroring for sure.
> What about any other options?
> Thanks.
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...
>> Hi Henrik,
>> Just be careful at using the high availabilty mode when the servers
>> (partners) are not on the same data center and pay special attention to
>> network reliability, network throughput and performance.
>> Take a look at this paper
>> Database Mirroring Best Practices and Performance Considerations
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
>> Hope this helps,
>> Ben Nevarez
>> Senior Database Administrator
>> AIG SunAmerica
>>
>> "Henrik Davidsen" wrote:
>> > I am looking for suggestions on creating a mirror site.
>> Try to read up on SQL Server's Mirroring feature.
>> > Primary goal is to make sure secondary site is always up to date
>> > (within a
>> > minute or so).
>> There are different modes the mirroring can operate in. One is a High
>> Availability mode, whichs offers guarantee that the mirror is ALWAYS
>> 100%
>> up-to-date. That however produces some performance degrading. But read
>> up on
>> the mirroring :)
>> > Money is not an object (within reason, No Million $ options please
>> > :-) )
>> The mirrorring funktionality is available within SQL Server 2005, so no
>> extra expenses is nessecary.
>> /Sjang
>>
>|||Thank you Jason.
"jason" <jason-r3move@.statisticsio.com> wrote in message
news:72BEA593-F945-4A39-B413-E25B118AFA7B@.microsoft.com...
> There are technologies available from SAN vendors. Although they probably
> have million dollar + price tags. Call up EMC and tell them what you want
> to do.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "Dragon" <noSpam_baadil@.hotmail.com> wrote in message
> news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
>> Thanks Guys. I will look into mirroring for sure.
>> What about any other options?
>> Thanks.
>>
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...
>> Hi Henrik,
>> Just be careful at using the high availabilty mode when the servers
>> (partners) are not on the same data center and pay special attention to
>> network reliability, network throughput and performance.
>> Take a look at this paper
>> Database Mirroring Best Practices and Performance Considerations
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
>> Hope this helps,
>> Ben Nevarez
>> Senior Database Administrator
>> AIG SunAmerica
>>
>> "Henrik Davidsen" wrote:
>> > I am looking for suggestions on creating a mirror site.
>> Try to read up on SQL Server's Mirroring feature.
>> > Primary goal is to make sure secondary site is always up to date
>> > (within a
>> > minute or so).
>> There are different modes the mirroring can operate in. One is a High
>> Availability mode, whichs offers guarantee that the mirror is ALWAYS
>> 100%
>> up-to-date. That however produces some performance degrading. But read
>> up on
>> the mirroring :)
>> > Money is not an object (within reason, No Million $ options please
>> > :-) )
>> The mirrorring funktionality is available within SQL Server 2005, so no
>> extra expenses is nessecary.
>> /Sjang
>>
>>
>

High Availability

Does anyone have a good starting point for creating a "high availabilty"
solution. I'm working on designing a solution that will allow for us to have
a primary site in Orlando and a secondary site in another state. The system
needs to have data moving in almost real time between the master and
secondary site. I've looked into the sql "active-passive" setup as well as
CA's HA solution, but would like input from someone whose accomplished
something similar.
Thanks,
GTM.
Have you looked at this white paper yet?
http://www.microsoft.com/windowsserv...lustergeo.mspx
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Greg" <yaya@.yaya.com> wrote in message
news:eLulS41VEHA.2168@.TK2MSFTNGP10.phx.gbl...
> Does anyone have a good starting point for creating a "high availabilty"
> solution. I'm working on designing a solution that will allow for us to
have
> a primary site in Orlando and a secondary site in another state. The
system
> needs to have data moving in almost real time between the master and
> secondary site. I've looked into the sql "active-passive" setup as well as
> CA's HA solution, but would like input from someone whose accomplished
> something similar.
> Thanks,
> GTM.
>
|||Note that one of the considerations for the active/passive GEO Cluster is that the network connections must be able to provide a maximum guaranteed round trip latency between nodes of no more than 500
milliseconds. The cluster uses heartbeat to detect whether a node is alive or not responding. These heartbeats are sent out on a periodic basis (every 1.2 seconds). If a node takes too long to respond to
heartbeat packets, MSCS starts a heavy-weight protocol to figure out which nodes are really still alive and which ones are dead; this is known as a cluster re-group. The heartbeat interval is not a configurable
parameter for the cluster service (there are many reasons for this, but the bottom line is that changing this parameter can have a significant impact on the stability of the cluster and the failover time). . 500 ms round-
trip is significantly below any threshold to ensure that artificial re-group operations are not triggered
You may want to research SQL Server Replication/ Log Shipping if you can have some latency (few secs).
Addtional Information:
=====================
http://www.microsoft.com/technet/pro...n/default.mspx
SQL Server 2000 High Availability Series
Plan and deploy a highly available data center that uses SQL Server 2000. This guide covers procedures to help you increase availability of your servers, recover from catastrophic disasters, and prevent and
minimize downtime.
SQL Server 2000 Failover Clustering
Understand how failover clustering works and how to implement, administer, and troubleshoot a failover cluster. Also included: worksheets and checklists to assist you during installation.
Log Shipping in SQL Server 2000 - Part 1
Increase your SQL Server availability by setting up, reconfiguring, and monitoring log shipping, which is supported in both SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition.
Log Shipping in SQL Server 2000 - Part 2
Find out how to change the roles of the primary and secondary servers, how to fully reverse their roles, and where to place the monitor server for the most effective monitoring.
Replication Overview
http://msdn.microsoft.com/library/de...lover_694n.asp
Typical Uses of Replication
http://msdn.microsoft.com/library/de...intro_6trn.asp
How Replication Works
http://msdn.microsoft.com/library/de...intro_6trn.asp
Planning for Each Type of Replication
http://msdn.microsoft.com/library/de...lplan_82zy.asp
Transactional Replication and Log Shipping
http://msdn.microsoft.com/library/de...ackup_3js7.asp
Microsoft SQL Server 2000: The Types of Replication and When to Implement Each
http://support.microsoft.com/default...b;EN-US;818714
Introducing New Features in Microsoft SQL Server 2000 Transactional Replication
http://support.microsoft.com/default...b;en-us;324966
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||another option would be to use an asynchronous replication software that
also does failover.
Async replication is real-time, as opposed to the scheduled Log Shipping
function, which reduces the latency of the data.
And for availability, you can failover similar to a cluster (assuming a
server name, IP and starting services) without the distance limitation.
Check out Double-Take by NSI Software - here is a link to their SQL
whitepaper.
http://www.nsisoftware.com/pro/white/
jason
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:qhGiyIlYEHA.2688@.cpmsftngxa06.phx.gbl...
> Note that one of the considerations for the active/passive GEO Cluster is
that the network connections must be able to provide a maximum guaranteed
round trip latency between nodes of no more than 500
> milliseconds. The cluster uses heartbeat to detect whether a node is alive
or not responding. These heartbeats are sent out on a periodic basis (every
1.2 seconds). If a node takes too long to respond to
> heartbeat packets, MSCS starts a heavy-weight protocol to figure out which
nodes are really still alive and which ones are dead; this is known as a
cluster re-group. The heartbeat interval is not a configurable
> parameter for the cluster service (there are many reasons for this, but
the bottom line is that changing this parameter can have a significant
impact on the stability of the cluster and the failover time). . 500 ms
round-
> trip is significantly below any threshold to ensure that artificial
re-group operations are not triggered
> You may want to research SQL Server Replication/ Log Shipping if you can
have some latency (few secs).
> Addtional Information:
> =====================
>
http://www.microsoft.com/technet/pro...n/default.mspx
> SQL Server 2000 High Availability Series
> Plan and deploy a highly available data center that uses SQL Server 2000.
This guide covers procedures to help you increase availability of your
servers, recover from catastrophic disasters, and prevent and
> minimize downtime.
> SQL Server 2000 Failover Clustering
> Understand how failover clustering works and how to implement, administer,
and troubleshoot a failover cluster. Also included: worksheets and
checklists to assist you during installation.
> Log Shipping in SQL Server 2000 - Part 1
> Increase your SQL Server availability by setting up, reconfiguring, and
monitoring log shipping, which is supported in both SQL Server 2000
Enterprise Edition and SQL Server 2000 Developer Edition.
> Log Shipping in SQL Server 2000 - Part 2
> Find out how to change the roles of the primary and secondary servers, how
to fully reverse their roles, and where to place the monitor server for the
most effective monitoring.
> Replication Overview
>
http://msdn.microsoft.com/library/de...lover_694n.asp
> Typical Uses of Replication
>
http://msdn.microsoft.com/library/de...intro_6trn.asp
> How Replication Works
>
http://msdn.microsoft.com/library/de...intro_6trn.asp
> Planning for Each Type of Replication
>
http://msdn.microsoft.com/library/de...lplan_82zy.asp
> Transactional Replication and Log Shipping
>
http://msdn.microsoft.com/library/de...ackup_3js7.asp
> Microsoft SQL Server 2000: The Types of Replication and When to Implement
Each
> http://support.microsoft.com/default...b;EN-US;818714
> Introducing New Features in Microsoft SQL Server 2000 Transactional
Replication
> http://support.microsoft.com/default...b;en-us;324966
>
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

hierarchy

hi All,

i am facing a problem while creating a simple product hierarchy in SSAS.

i am able to create the hierarchy and deploy the cube,but in the browser while analysing i drag and drop the hierarchy .but only the key are displayed not the caption.

Please do help me with this

thanks in advance

Lalitha

You need to post this to the SQL Server Analysis Services forum.|||

There shouldn't be any secrets to getting this to work, so I would just double check what you've done. Check the definition of the hierarchy/level/attribute and ensure that you are browsing the correct object. If you are still having troubles, please provide more info such as what version of SSAS you are using (2000 or 2005), what browser you are using, and more details about just what the problematic hierarchy looks like (key columns, name columns, etc).

Hope this helps

|||

hi,

i am using SSAS 2005 . and i am using the browser tab which is available when the cube is proccessed.

i'll give the steps what i have done

i created a dimension of product consisting of attribute

productid

productname

producttypeid

priducttypename

productcategoryid

productcategoryname

then i am creating the heirarchy in the dimension Structure tab available.

the level were automatically identified and there was no caption avaliable

i draged and dropped the captions to the appropriate levels

and the caption didnot appear while browsing the cube..

This what is did

please do help me as soon as possible

Thanks in advances

Lalitha

|||

What exactly are you doing when you "drag and drop captions" to appropriate levels? I'm guessing you're dragging attributes onto the hierahcy panel and dropping them under levels which creates attribute relationships (and thus Member Properties), but is not related to the caption of the level.

Levels are based on attributes and get their members from the values of the attribute on which they are based. Each attribute contains a KeyColumns property that determines how members are uniquely identified by the server and a NameColumn property that determines how the members are displayed. If the NameColumn is not specified, then the KeyColumn will also be used as the name. (If multiple key columns are specified, then a name column must be specified.) (In addition to names, translations can also be specified in the translations tab but as long as you've not changed anything in the translations tab it should have no impact.)

|||

hi Matt Carroll

Thanks , I solved it. You'r information help me a lot

Regards

Lalitha

Hiding Reports in Sharepoint Integration Mode

I'm setting the Hidden property to True and then creating the report using the CreateReport method from the ReportingService2006 class. When I check the reportserver database Hidden is set to true. But when I call the GetProperties method it shows Hidden as being false. And in the document library the reports are visable.

I tried calling the SetProperties method after I created the report but it still didn't work.

Here's how I create the report.

Dim props(0) As ReportServer.Property

Dim SetProp As New ReportServer.Property

SetProp.Name = "Hidden"

SetProp.Value = "True"

props(0) = SetProp

rs.CreateReport(Path.GetFileName(fileName), Folder, True, bytes, props, warnings)

Any idea?

Thanks,

-Somsong

The Hidden property isn't respected by SharePoint document libraries. We would have had to make code changes in SharePoint itself in order to get document libraries to respect RS's Hidden property, and we didn't pursue that.|||

So we would have to set up a default view and set a filter on it so that certain items can be hidden right? I can create a column in the document library and call it hidden, if the value in here is 'Yes' I could hide it. Do you know if I can set this value when I use the CreateReport method from the Reporting Services 2006 Web Service by passing in properties? I'm guessing this won't work cause those properties are probably just for the Report Server Database. I would probably have to use the Sharepoint Object Model to edit that column value right?

Thanks,

-Somsong

Hiding parameters

I have a report that has to show values in the Report Header section. This is
solved by creating parameters that gets the values from a dataset.
But I can't hide these parameters from the user. If I leave the promt field
empty it will become read only, but not hidden.
Is there a way of hiding these parameters?I beleive if you install SP1 for Reporting Services you can hide the header
(by not providing the prompt) but still be able to set the values...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"karl" <karl@.discussions.microsoft.com> wrote in message
news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
>I have a report that has to show values in the Report Header section. This
>is
> solved by creating parameters that gets the values from a dataset.
> But I can't hide these parameters from the user. If I leave the promt
> field
> empty it will become read only, but not hidden.
> Is there a way of hiding these parameters?|||Thanks.
But SP1 is already installed.
"Wayne Snyder" wrote:
> I beleive if you install SP1 for Reporting Services you can hide the header
> (by not providing the prompt) but still be able to set the values...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "karl" <karl@.discussions.microsoft.com> wrote in message
> news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> >I have a report that has to show values in the Report Header section. This
> >is
> > solved by creating parameters that gets the values from a dataset.
> >
> > But I can't hide these parameters from the user. If I leave the promt
> > field
> > empty it will become read only, but not hidden.
> >
> > Is there a way of hiding these parameters?
>
>|||Karl - did you set the prompt to blank via the report manager or the
designer? You have to do it via the designer. I don't trust using the report
manager to set properties.
If you do it via the report designer - just leave the prompt blank. I have
had great success using this method.
=-Chris
"karl" <karl@.discussions.microsoft.com> wrote in message
news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
>I have a report that has to show values in the Report Header section. This
>is
> solved by creating parameters that gets the values from a dataset.
> But I can't hide these parameters from the user. If I leave the promt
> field
> empty it will become read only, but not hidden.
> Is there a way of hiding these parameters?|||Thanks.
This is done in the Report Designer.
But since I now know that this should work, I'll just look around in my
solution to see if something is done wrong.
Thanks again.
Karl
"Christopher Conner" wrote:
> Karl - did you set the prompt to blank via the report manager or the
> designer? You have to do it via the designer. I don't trust using the report
> manager to set properties.
> If you do it via the report designer - just leave the prompt blank. I have
> had great success using this method.
> =-Chris
> "karl" <karl@.discussions.microsoft.com> wrote in message
> news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> >I have a report that has to show values in the Report Header section. This
> >is
> > solved by creating parameters that gets the values from a dataset.
> >
> > But I can't hide these parameters from the user. If I leave the promt
> > field
> > empty it will become read only, but not hidden.
> >
> > Is there a way of hiding these parameters?
>
>|||By the way...
I have the Report Server and SQL Server on two different servers.
Currently the SP1 is only installed on the Report Server (server).
Do I also need to install the SP1 on the server where SQL Server is located?
Karl
"karl" wrote:
> Thanks.
> This is done in the Report Designer.
> But since I now know that this should work, I'll just look around in my
> solution to see if something is done wrong.
> Thanks again.
>
> Karl
> "Christopher Conner" wrote:
> > Karl - did you set the prompt to blank via the report manager or the
> > designer? You have to do it via the designer. I don't trust using the report
> > manager to set properties.
> >
> > If you do it via the report designer - just leave the prompt blank. I have
> > had great success using this method.
> >
> > =-Chris
> >
> > "karl" <karl@.discussions.microsoft.com> wrote in message
> > news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> > >I have a report that has to show values in the Report Header section. This
> > >is
> > > solved by creating parameters that gets the values from a dataset.
> > >
> > > But I can't hide these parameters from the user. If I leave the promt
> > > field
> > > empty it will become read only, but not hidden.
> > >
> > > Is there a way of hiding these parameters?
> >
> >
> >|||The Report Server says Version 8.00.878.00.
And if I'm not wrong this is the correct number for SP1.
"karl" wrote:
> By the way...
> I have the Report Server and SQL Server on two different servers.
> Currently the SP1 is only installed on the Report Server (server).
> Do I also need to install the SP1 on the server where SQL Server is located?
>
> Karl
>
> "karl" wrote:
> > Thanks.
> >
> > This is done in the Report Designer.
> > But since I now know that this should work, I'll just look around in my
> > solution to see if something is done wrong.
> >
> > Thanks again.
> >
> >
> > Karl
> >
> > "Christopher Conner" wrote:
> >
> > > Karl - did you set the prompt to blank via the report manager or the
> > > designer? You have to do it via the designer. I don't trust using the report
> > > manager to set properties.
> > >
> > > If you do it via the report designer - just leave the prompt blank. I have
> > > had great success using this method.
> > >
> > > =-Chris
> > >
> > > "karl" <karl@.discussions.microsoft.com> wrote in message
> > > news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> > > >I have a report that has to show values in the Report Header section. This
> > > >is
> > > > solved by creating parameters that gets the values from a dataset.
> > > >
> > > > But I can't hide these parameters from the user. If I leave the promt
> > > > field
> > > > empty it will become read only, but not hidden.
> > > >
> > > > Is there a way of hiding these parameters?
> > >
> > >
> > >