Ho do I embed a word document into a rdl or rdlc?

Hello,
I'm trying embed some text from a msword document into my sql reporting
services report. This is actually working with a report that I had
converted from acesss. Within access the msword portion is referred to as
an ole object.
ThanksYou are going to need to create an assembly to get this information and
return it into the "Code.<Function>" call.
=-Chris
"Rob Dob" <robdob20012002@.yahoo.com> wrote in message
news:eEQFxLr$GHA.3396@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I'm trying embed some text from a msword document into my sql reporting
> services report. This is actually working with a report that I had
> converted from acesss. Within access the msword portion is referred to as
> an ole object.
> Thanks
>|||Hi,
> You are going to need to create an assembly to get this information and
> return it into the "Code.<Function>" call.
>
you mean I can't just drag and drop..? wow, very aggravating.. do you
have an example of how I would do this? All I am trying to do is embed the
terms and conditions of a contract that was prepared within MSWord within
the body of my reporting services report.
thanks,

HLP! PDF headings suddenly squished

I had a report that was working fine ... and now suddenly when it renders it
looks fine but if I export to pdf it squishes up the headings on the table.
All I can think of that changed is that I am showing or hiding table based on
the value of a field (this expression on the visibility for table =IIF(SUM(
Fields!Downtime.Value) > 0, False, True). AND I am showing or hiding a doc
map based on that same expression. This is very odd If the report werent so
complex I would just delete and re-create again. Any suggestions
appreciated!!This was fixed with SP2 which I now have
"MJT" wrote:
> I had a report that was working fine ... and now suddenly when it renders it
> looks fine but if I export to pdf it squishes up the headings on the table.
> All I can think of that changed is that I am showing or hiding table based on
> the value of a field (this expression on the visibility for table =IIF(SUM(
> Fields!Downtime.Value) > 0, False, True). AND I am showing or hiding a doc
> map based on that same expression. This is very odd If the report werent so
> complex I would just delete and re-create again. Any suggestions
> appreciated!!sql

hit locations in full text

I'm working on an aplication that could benefit from having the hit
location inside of a column. For example
A Column has
"United Stated Education System : Educational Stuff"
The full text search might match Education and Edicational from the
word eudcation. But I can not see any clear way to determine what
word(s) were matches and how they were used in the ranking. Is there
any known way to do this?
Thanks,
madmike
No, you have to implement a version of Porter Stemming algorithm to do
something like this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<madmik3@.gmail.com> wrote in message
news:1159463316.911169.56710@.e3g2000cwe.googlegrou ps.com...
> I'm working on an aplication that could benefit from having the hit
> location inside of a column. For example
> A Column has
> "United Stated Education System : Educational Stuff"
>
> The full text search might match Education and Edicational from the
> word eudcation. But I can not see any clear way to determine what
> word(s) were matches and how they were used in the ranking. Is there
> any known way to do this?
> Thanks,
> madmike
>

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
>

Highest week of sales/usage

I'm working with Crystal Reports 10 with a Sql Server 2000 database. I've got a table which stores the details of items including the saletimes (a date/time field). I need to calculate the sales figure for the highest week of sales. In other words I need to find out what the highest amount of sales recorded in any given week. How can I do this?Quickest way would be to create a group based on date, and in the group options select "for each week" as the required grouping.
Create Sum(sigma sysmbol) fields for the data.
Suppress your details section.
In the group footer you will have Totals based on weekly aggregates.
In the Report menu, select TopN/Sort Group Expert.
Select the Tab for your weekly group (if you have more than one group that is).
In"for This Group Sort" change All to TopN.
Enter 1 in the "Where N is" field.
Remove the tick from the "Show others" checkbox.
OK that dialog.
Run you report. Should see only highest weeks.
May want to format the Date Field in your group to show start end end date of the week that finished top........

Hope this helps

dave|||re above - this is all client-side in Crystal.
would be quicker if could achieve it in SQL on server-side, but above solution is quick-ish, because Crystal's query to SQL Server will include an SQL-compliant "TopN" modifier.

dave

High performance system and table and index structure

Hi Folks,
I'm working on something a little different at present. Given it's a bit out
of the ordinary, and it relates to some of our indexing discussions lately,
I'd appreciate any thoughts/feedback.
It's a SQL Server box that's receiving a stream of real-time data from oil
drilling rigs all over the world. It needs to perform both fast inserts (ie
10,000 per second) and also have good performance on a fixed list of query
types. The essential part of the table data that has me most intrigued looks
like this:
Well (ID of the well involved - varchar(60))
Wellbore (ID of a specific bore at a wellsite - varchar(60))
Curve (ID of a specific set of measures eg: pressures, gas levels, etc.)
Depth (float)
Time (datetime)
DataValue (float)
This data is defined in an external xsd. The hardware/operating system
requirements are basically a non-issue ie: whatever is needed can be
obtained.
The key thing is that about 100 wellbores with up to 100 curves (of sets of
data) can be active each second, so fast insert performance is critical.
Once inserted, the messiest queries involve:
1. All values for a specific curve within a range of depths
2. All values for a specific curve within a range of times
The things I'm pondering are:
1. Whether to have this in one database or to have a database per well.
There are about 1200 wells, but about 100 active concurrently.
2. Whether to store the data in a heap or a clustered index on either depth
or time.
3. Whether to use a non-clustered index for whichever of depth or time
wasn't the clustered one OR whether to store the data twice ie: once by date
and once by time.
4. Whether to find a way to limit the range of depth values (currently
float) to store them instead as a bigint, if the performance of bigint's in
indexes and range queries, etc. is better than floats.
I'd love to hear anyone's thoughts on this. We're about to start
experimenting to see what works.
Regards,
GregGreg
Is it SQL Server 2005?
Well , if it needs perfom fast inserts I think to store the data in a
heap you can get better performance for inserting , however as you said
you need to have good performance on lits of query , so CI will be a good
candidate for range queries
Actually it is really hard to suggest something , you need to test it and
get a decision
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:udZGEsj9GHA.3264@.TK2MSFTNGP04.phx.gbl...
> Hi Folks,
> I'm working on something a little different at present. Given it's a bit
> out of the ordinary, and it relates to some of our indexing discussions
> lately, I'd appreciate any thoughts/feedback.
> It's a SQL Server box that's receiving a stream of real-time data from oil
> drilling rigs all over the world. It needs to perform both fast inserts
> (ie 10,000 per second) and also have good performance on a fixed list of
> query types. The essential part of the table data that has me most
> intrigued looks like this:
> Well (ID of the well involved - varchar(60))
> Wellbore (ID of a specific bore at a wellsite - varchar(60))
> Curve (ID of a specific set of measures eg: pressures, gas levels, etc.)
> Depth (float)
> Time (datetime)
> DataValue (float)
> This data is defined in an external xsd. The hardware/operating system
> requirements are basically a non-issue ie: whatever is needed can be
> obtained.
> The key thing is that about 100 wellbores with up to 100 curves (of sets
> of data) can be active each second, so fast insert performance is
> critical. Once inserted, the messiest queries involve:
> 1. All values for a specific curve within a range of depths
> 2. All values for a specific curve within a range of times
> The things I'm pondering are:
> 1. Whether to have this in one database or to have a database per well.
> There are about 1200 wells, but about 100 active concurrently.
> 2. Whether to store the data in a heap or a clustered index on either
> depth or time.
> 3. Whether to use a non-clustered index for whichever of depth or time
> wasn't the clustered one OR whether to store the data twice ie: once by
> date and once by time.
> 4. Whether to find a way to limit the range of depth values (currently
> float) to store them instead as a bigint, if the performance of bigint's
> in indexes and range queries, etc. is better than floats.
> I'd love to hear anyone's thoughts on this. We're about to start
> experimenting to see what works.
> Regards,
> Greg
>|||Hi...
We had a simmilar problem just alitle bit scaled down.
We implemented like:
- use an autoid for PK -> heap, rows are appended in the pages, no other
indexes, no constrains, all collumns allows null.
- use EE version (sql2005) :)
- use snapshot isolation mode for querying the data. (decrease lockings)
- use for querying a second maschine wich is sync-ing the data each n
sec/min. (you can try a log shipping but we've got no time to checkit)
(decreasing lockings, free cpu).
Have phun,
Radu
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:udZGEsj9GHA.3264@.TK2MSFTNGP04.phx.gbl...
> Hi Folks,
> I'm working on something a little different at present. Given it's a bit
> out of the ordinary, and it relates to some of our indexing discussions
> lately, I'd appreciate any thoughts/feedback.
> It's a SQL Server box that's receiving a stream of real-time data from oil
> drilling rigs all over the world. It needs to perform both fast inserts
> (ie 10,000 per second) and also have good performance on a fixed list of
> query types. The essential part of the table data that has me most
> intrigued looks like this:
> Well (ID of the well involved - varchar(60))
> Wellbore (ID of a specific bore at a wellsite - varchar(60))
> Curve (ID of a specific set of measures eg: pressures, gas levels, etc.)
> Depth (float)
> Time (datetime)
> DataValue (float)
> This data is defined in an external xsd. The hardware/operating system
> requirements are basically a non-issue ie: whatever is needed can be
> obtained.
> The key thing is that about 100 wellbores with up to 100 curves (of sets
> of data) can be active each second, so fast insert performance is
> critical. Once inserted, the messiest queries involve:
> 1. All values for a specific curve within a range of depths
> 2. All values for a specific curve within a range of times
> The things I'm pondering are:
> 1. Whether to have this in one database or to have a database per well.
> There are about 1200 wells, but about 100 active concurrently.
> 2. Whether to store the data in a heap or a clustered index on either
> depth or time.
> 3. Whether to use a non-clustered index for whichever of depth or time
> wasn't the clustered one OR whether to store the data twice ie: once by
> date and once by time.
> 4. Whether to find a way to limit the range of depth values (currently
> float) to store them instead as a bigint, if the performance of bigint's
> in indexes and range queries, etc. is better than floats.
> I'd love to hear anyone's thoughts on this. We're about to start
> experimenting to see what works.
> Regards,
> Greg
>|||On 23.10.2006 02:34, Greg Low [MVP] wrote:
> Hi Folks,
> I'm working on something a little different at present. Given it's a bit out
> of the ordinary, and it relates to some of our indexing discussions lately,
> I'd appreciate any thoughts/feedback.
> It's a SQL Server box that's receiving a stream of real-time data from oil
> drilling rigs all over the world. It needs to perform both fast inserts (ie
> 10,000 per second) and also have good performance on a fixed list of query
> types. The essential part of the table data that has me most intrigued looks
> like this:
> Well (ID of the well involved - varchar(60))
> Wellbore (ID of a specific bore at a wellsite - varchar(60))
> Curve (ID of a specific set of measures eg: pressures, gas levels, etc.)
> Depth (float)
> Time (datetime)
> DataValue (float)
> This data is defined in an external xsd. The hardware/operating system
> requirements are basically a non-issue ie: whatever is needed can be
> obtained.
> The key thing is that about 100 wellbores with up to 100 curves (of sets of
> data) can be active each second, so fast insert performance is critical.
> Once inserted, the messiest queries involve:
> 1. All values for a specific curve within a range of depths
> 2. All values for a specific curve within a range of times
> The things I'm pondering are:
> 1. Whether to have this in one database or to have a database per well.
> There are about 1200 wells, but about 100 active concurrently.
What about partitioning by wellid? You should at least create a setup
with allows for as much concurrent processing as possible (i.e.
separating data physically on different disks or at least file groups
etc.) to be able to stream your data into the DB as independently as
possible.
> 2. Whether to store the data in a heap or a clustered index on either depth
> or time.
> 3. Whether to use a non-clustered index for whichever of depth or time
> wasn't the clustered one OR whether to store the data twice ie: once by date
> and once by time.
If you need purging of old data and query according to time range then a
CI with timestamp as leading column is certainly a good idea.
> 4. Whether to find a way to limit the range of depth values (currently
> float) to store them instead as a bigint, if the performance of bigint's in
> indexes and range queries, etc. is better than floats.
I would start out with floats if the data is actually float. Only go
for this type of optimization if you actually need it and it is proved
that bigint is faster.
> I'd love to hear anyone's thoughts on this. We're about to start
> experimenting to see what works.
On a more general level I am thinking that Oracle might be more suited
for this scenario because it offers several features that give you
better control. For example, you do not have a single CI on a table -
basically all indexes are ordered (but you can mimic SQL Server's CI
with an IOT). Another point is partitioning of tables, Oracle is much
more flexible there (IIRC you can do only hash partitioning on SQL 2005).
Just my 0.02EUR...
Kind regards
robert

High Availability with Log Shipping

I have implemented log shipping between 2 databases, the transaction log size normally between 10mb - 50mb every 15 minutes during normal working hours, but it grows to 9GB when we run database optimization job and that makes it hard and long to transfer and apply the transaction log on the other database. Does anybody encountered a situation like this and is there a way to minimize the size of the Trans log after the optimization job?

ThanxUse the shrink command: You can look it up. It allow for a backup of the log then it's shrunk to the specified size. Please look up on Book on line or ms sql server support. I suggest shrinking before the other processes.

BACKUP LOG wslogdb62 WITH TRUNCATE_ONLY
DBCC SHRINKFILE('wslogdb62_log.ldf', 1)

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
>

Hiding the report parameters when i click on the View report button

hi All,
i am working in SQL reporting services 2005, i have requirement that i
need to show all the report parameters in the report layout and user
can enter or select the values when i click on the view report button,
the report parameters should be hided. i am not sure that we could hide
the report parameters when i click on the view report button.
anyone knows how to implement this. please let me know.
Thank you in advance.
VinodAny idea on the below issue!!!!
thanks
Vinod
Vinod wrote:
> hi All,
>
> i am working in SQL reporting services 2005, i have requirement that i
> need to show all the report parameters in the report layout and user
> can enter or select the values when i click on the view report button,
> the report parameters should be hided. i am not sure that we could hide
> the report parameters when i click on the view report button.
> anyone knows how to implement this. please let me know.
> Thank you in advance.
> Vinod

Hiding Point Labels

Hi all,
I have been working with a pie chart and have had some issues with data
overlapping due to the small size of the pie slice. Robert Bruckner has
graciously helped me with the expression below to hide the data points that
are smaller than X% but now the lines are still showing.
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , " ",
Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
I would assume that I can hide the line by going into the Label Style and
adding an expression that changes the Color to the same as the backgroud
color if the pie slice is smaller than X%. However, I can't figure out the
syntax for the expression...see below what I have and please let me know how
I should change.
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
"#FFFFFF", "#000000"))
This is the error I get:
The color expression for the chart â'chart2â' contains an error: [BC30205] End
of statement expected.
Build complete -- 1 errors, 0 warningsYou only need one closing parenthesis at the end of the expression. Try
this:
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
"#FFFFFF", "#000000")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
> Hi all,
> I have been working with a pie chart and have had some issues with data
> overlapping due to the small size of the pie slice. Robert Bruckner has
> graciously helped me with the expression below to hide the data points
> that
> are smaller than X% but now the lines are still showing.
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , " ",
> Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
> I would assume that I can hide the line by going into the Label Style and
> adding an expression that changes the Color to the same as the backgroud
> color if the pie slice is smaller than X%. However, I can't figure out
> the
> syntax for the expression...see below what I have and please let me know
> how
> I should change.
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> "#FFFFFF", "#000000"))
> This is the error I get:
> The color expression for the chart 'chart2' contains an error: [BC30205]
> End
> of statement expected.
> Build complete -- 1 errors, 0 warnings
>|||Well that was easy!! The only problem is...it changed the text of the label.
I need to make the line and the label disappear. Can I do this? If so
where does the expression need to go?
Thanks again for all the help!!
"Robert Bruckner [MSFT]" wrote:
> You only need one closing parenthesis at the end of the expression. Try
> this:
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> "#FFFFFF", "#000000")
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
> > Hi all,
> >
> > I have been working with a pie chart and have had some issues with data
> > overlapping due to the small size of the pie slice. Robert Bruckner has
> > graciously helped me with the expression below to hide the data points
> > that
> > are smaller than X% but now the lines are still showing.
> >
> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , " ",
> > Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
> >
> > I would assume that I can hide the line by going into the Label Style and
> > adding an expression that changes the Color to the same as the backgroud
> > color if the pie slice is smaller than X%. However, I can't figure out
> > the
> > syntax for the expression...see below what I have and please let me know
> > how
> > I should change.
> >
> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> > "#FFFFFF", "#000000"))
> >
> > This is the error I get:
> >
> > The color expression for the chart 'chart2' contains an error: [BC30205]
> > End
> > of statement expected.
> > Build complete -- 1 errors, 0 warnings
> >
> >
>
>|||If this is RS 2000 SP1/SP2:
Go to the Appearance tab of the data value. Click on the "series style"
button and modify the border line width property: =iif(
Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "0.5 pt", "1
pt")
If this is RS 2005, you should modify the border style expression:
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "None",
"Solid")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:1193D40C-9712-41E4-96EF-D018C7C017D2@.microsoft.com...
> Well that was easy!! The only problem is...it changed the text of the
> label.
> I need to make the line and the label disappear. Can I do this? If so
> where does the expression need to go?
> Thanks again for all the help!!
> "Robert Bruckner [MSFT]" wrote:
>> You only need one closing parenthesis at the end of the expression. Try
>> this:
>> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
>> "#FFFFFF", "#000000")
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
>> news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
>> > Hi all,
>> >
>> > I have been working with a pie chart and have had some issues with data
>> > overlapping due to the small size of the pie slice. Robert Bruckner
>> > has
>> > graciously helped me with the expression below to hide the data points
>> > that
>> > are smaller than X% but now the lines are still showing.
>> >
>> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , "
>> > ",
>> > Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
>> >
>> > I would assume that I can hide the line by going into the Label Style
>> > and
>> > adding an expression that changes the Color to the same as the
>> > backgroud
>> > color if the pie slice is smaller than X%. However, I can't figure out
>> > the
>> > syntax for the expression...see below what I have and please let me
>> > know
>> > how
>> > I should change.
>> >
>> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
>> > "#FFFFFF", "#000000"))
>> >
>> > This is the error I get:
>> >
>> > The color expression for the chart 'chart2' contains an error:
>> > [BC30205]
>> > End
>> > of statement expected.
>> > Build complete -- 1 errors, 0 warnings
>> >
>> >
>>|||That did the trick!!
Thanks alot!!
Anthony
"Robert Bruckner [MSFT]" wrote:
> If this is RS 2000 SP1/SP2:
> Go to the Appearance tab of the data value. Click on the "series style"
> button and modify the border line width property: =iif(
> Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "0.5 pt", "1
> pt")
> If this is RS 2005, you should modify the border style expression:
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "None",
> "Solid")
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:1193D40C-9712-41E4-96EF-D018C7C017D2@.microsoft.com...
> > Well that was easy!! The only problem is...it changed the text of the
> > label.
> > I need to make the line and the label disappear. Can I do this? If so
> > where does the expression need to go?
> >
> > Thanks again for all the help!!
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> You only need one closing parenthesis at the end of the expression. Try
> >> this:
> >> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> >> "#FFFFFF", "#000000")
> >>
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> >> news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
> >> > Hi all,
> >> >
> >> > I have been working with a pie chart and have had some issues with data
> >> > overlapping due to the small size of the pie slice. Robert Bruckner
> >> > has
> >> > graciously helped me with the expression below to hide the data points
> >> > that
> >> > are smaller than X% but now the lines are still showing.
> >> >
> >> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , "
> >> > ",
> >> > Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
> >> >
> >> > I would assume that I can hide the line by going into the Label Style
> >> > and
> >> > adding an expression that changes the Color to the same as the
> >> > backgroud
> >> > color if the pie slice is smaller than X%. However, I can't figure out
> >> > the
> >> > syntax for the expression...see below what I have and please let me
> >> > know
> >> > how
> >> > I should change.
> >> >
> >> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> >> > "#FFFFFF", "#000000"))
> >> >
> >> > This is the error I get:
> >> >
> >> > The color expression for the chart 'chart2' contains an error:
> >> > [BC30205]
> >> > End
> >> > of statement expected.
> >> > Build complete -- 1 errors, 0 warnings
> >> >
> >> >
> >>
> >>
> >>
>
>

Hiding Matrix column data but still have totals displaying.

Hi,
I'm working on a matrix report with salary information. One of my
requirements is to have the sub total display but not the detail
within the report. Is this possible? "Here is an example: This "-"
is showing hidden salary information.
December January
HOURS TOTAL HOURS TOTAL
Employee A 5 - 4 -
Employee B 5 - 4 -
TOTAL $500 $450On Dec 18, 1:45 pm, michael h <mikej...@.gmail.com> wrote:
> Hi,
> I'm working on a matrix report with salary information. One of my
> requirements is to have the sub total display but not the detail
> within the report. Is this possible? "Here is an example: This "-"
> is showing hidden salary information.
> December January
> HOURS TOTAL HOURS TOTAL
> Employee A 5 - 4 -
> Employee B 5 - 4 -
> TOTAL $500 $450
Use the InScope() function in your Details Expression. Basically, the
InScope("groupName") returns True when the Details section is
contained in the named group. If your use the name of the Row Group,
then you will be InScope = True when the report is rendering the rows,
and InScope = False when the report is rendering the totals.
Use an Expression like:
= IIF( InScope( "matrix1_Employees"), "-", Sum( Fields!
Salary.Value ) )
-- Scott