Change value displayed in last row in table?

I have a table which displays years (2007, 2006, 2005, etc.) as one of its fields. I need to have it display Year + " and prior" for the last row. Any thoughts on how I might do this? Thanks!

Hello,

Try this in your expression:

=Iif(CountRows("DataSetName") = RunningValue(1=1, Count, "DataSetName"), cStr(Fields!Year.Value) & " and prior", cStr(Fields!Year.Value))

Hope this helps.

Jarret

|||Great, that did it!

Change Tracking Displayed in Event Log

I have a customer that is complaining of poor performance when doing
searches against the FTS catalog during the day.
I believe what is happening is that the indexing process is taking place at
the same time as their searches.
select @.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
The data is derived from an OCR process on scanned forms.
The data is added to the table throughout the day.
The catalog index is on one column of one table.
I have Change Tracking, Update Index in Background enabled.
Question 1 - When Chg Trk, UIB is enabled, should I see the crawl start and
crawl end events enumerated in the event log?
I thought this operation went on continuously.
I have included an abridged listing from the event log for one day.
You can see that on average, 200-300 items are processed each iteration
during the day.
Is this typical of Change Tracking, UIB?
The following list displays the data for one day,
crawl start time
crawl end time, gatherer count, modified count
7:21 crawl start
8:43 crawl end 2031581 6
9:04 crawl start
10:29 crawl end 2033495 307
11:01 crawl start
12:22 crawl end 2034510 385
12:50 crawl start
14:14 crawl end 2035862 341
14:23 crawl start
15:49 crawl end 2036796 244
16:27 crawl start
17:48 crawl end 2038034 244
19:00 crawl start
20:21 crawl end 2038557 1
Since the crawl process runs for one to one and one-half hours each event, I
am guessing that this is what is affecting their performance.
Question 2 - Would it be better to turn off Change Tracking, UIB during the
day and start an incremental index in the evening?
I thought CT, UIB was designed to allow indexing to take place while normal
database operations are executing.
This depends on your needs. If you need real time indexing updates you will
probably have to use Change tracking with Update Index in Background.
Otherwise, you might want to use Change Tracking and then schedule the index
update to periods when there is low activity on the server.
Note that there are dramatic improvements with SQL Server FTS in SQL Server
2005.
Hilary Cotter
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
"Binder" <rgondzur@.hotmail.com> wrote in message
news:eZPShpwLFHA.2888@.TK2MSFTNGP12.phx.gbl...
> I have a customer that is complaining of poor performance when doing
> searches against the FTS catalog during the day.
> I believe what is happening is that the indexing process is taking place
at
> the same time as their searches.
> select @.@.version
> --
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> The data is derived from an OCR process on scanned forms.
> The data is added to the table throughout the day.
> The catalog index is on one column of one table.
> I have Change Tracking, Update Index in Background enabled.
>
> Question 1 - When Chg Trk, UIB is enabled, should I see the crawl start
and
> crawl end events enumerated in the event log?
> I thought this operation went on continuously.
> I have included an abridged listing from the event log for one day.
> You can see that on average, 200-300 items are processed each iteration
> during the day.
> Is this typical of Change Tracking, UIB?
>
> The following list displays the data for one day,
> crawl start time
> crawl end time, gatherer count, modified count
>
> 7:21 crawl start
> 8:43 crawl end 2031581 6
> 9:04 crawl start
> 10:29 crawl end 2033495 307
> 11:01 crawl start
> 12:22 crawl end 2034510 385
> 12:50 crawl start
> 14:14 crawl end 2035862 341
> 14:23 crawl start
> 15:49 crawl end 2036796 244
> 16:27 crawl start
> 17:48 crawl end 2038034 244
> 19:00 crawl start
> 20:21 crawl end 2038557 1
>
> Since the crawl process runs for one to one and one-half hours each event,
I
> am guessing that this is what is affecting their performance.
> Question 2 - Would it be better to turn off Change Tracking, UIB during
the
> day and start an incremental index in the evening?
> I thought CT, UIB was designed to allow indexing to take place while
normal
> database operations are executing.
>
>

Change the displayed name in the Series Group for a chart

Hi,
I created a chart in sql reporting services. I added a series group to it.
Now what i want to do is to dispaly different series names when the chart is
viewed . For example, in my database, I have Region code as numbers. I have
used this Region Code as the Series group. What i want to do is, ...
if (RegionCode ==01
{
//the series group should display North
}
Similarly for other region codes. Is it possible? & how?
Thanks
pmudYes this is possible through the Label expression of a chart series
grouping.
* right-click on the chart and open the chart properties dialog
* go to the Data tab and edit the series grouping
* the grouping dialog has a grouping expression and a label expression
below. If no label expression is set, it will take the group expression
value as label by default.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:13D0A129-DEAA-4C05-9736-04E3104A9935@.microsoft.com...
> Hi,
> I created a chart in sql reporting services. I added a series group to it.
> Now what i want to do is to dispaly different series names when the chart
> is
> viewed . For example, in my database, I have Region code as numbers. I
> have
> used this Region Code as the Series group. What i want to do is, ...
> if (RegionCode ==01
> {
> //the series group should display North
> }
> Similarly for other region codes. Is it possible? & how?
> Thanks
> pmud

Change the date format in a report

HI,
1. I have a date displayed in a report 1040801 and would like it to display
8/1/04. How and where do I do this? I have tried the expression builder,
but it does not like what I am entering.
2. What is the expression to do this?
Thanks for your helpYou can format this in multiple ways. The following is a couple of
suggestions: 1) In the format property of the textbox you can enter the
format string like MM/dd/yy, or 2) using the expression builder you can do
something like this =Fields!YourDate.Value.ToShortDateString()
"Susan R" wrote:
> HI,
> 1. I have a date displayed in a report 1040801 and would like it to display
> 8/1/04. How and where do I do this? I have tried the expression builder,
> but it does not like what I am entering.
> 2. What is the expression to do this?
> Thanks for your help

change Parameter order

Hello,

I'd like to change the order in which Parameters are displayed. When I go to the menu Report - Report Parameters and change the order with the arrows displayed - I'll get the following error msg.:The value expression for the report parameter contains an error:The expression contains a non existing parameter in the report parameter collection.

Any ideas to change the order? Edit the XML File?

Thanks!You're doing it the right way. It sounds like you have dependent parametrs in which case they have to appear in order of dependency.|||Thats right they depent on each other but this was automatically. How can I turn that on or off? And if I turn that off - will my procedure to switch the position of the Parameter fields work?

Thanks!|||

Parameters become dependent when you use parameter A in the query that populates paramter B. This usually happens in the WHERE clause e.g.

SELECT *
FROM param_b_table
where some_column = @.param_a

Removing the WHERE clause should remove the dependency between the parameter and and allow you to reorder them.

But are you sure that removing the dependency is really what you want to do for the sake of ordering?

Obviously you won't be able to put the WHERE clause back in and expect to retain the ordering.

|||I'm not using any SQL Query. I use MS Reporting Services - Design Mode and click my Measures and Dimensions together.|||right so you're querying an Analysis Services 2005 cube using MDX. Fine so in the query design mode for your parameter query, remove the dependency to the other parameters.|||Here is my query. How can I switch the dependencies off. After doing this it is possible to change the order and switching the dependencies back on again?

SELECT NON EMPTY { } ON COLUMNS, NON EMPTY { ([Organisation].[Business Unit Description].[Business Unit Description].ALLMEMBERS * [Organisation].[Room Local Code].[Room Local Code].ALLMEMBERS * [Organisation].[Business Area Description].[Business Area Description].ALLMEMBERS * [Time].[Hour Description].[Hour Description].ALLMEMBERS * [Date].[Date].[Date].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@.OrganisationRoomLocalCode, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@.DateDate, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@.OrganisationBusinessAreaDescription, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Organisation].[Room Type Description].&[Recovery room] } ) ON COLUMNS FROM [Clinical Performance]))))) WHERE ( [Organisation].[Room Type Description].&[Recovery room], IIF( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED).Count = 1, STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED), [Organisation].[Main Unit Description].currentmember ) ) CELL PROPERTIES VALUE|||

I'll refer you to my previous answer in which I stated that you can't expect to put the WHERE clause back in and expect to retain the order. This is equivalent to putting back the dependency, you can'y do it and expect to retain ordering.

Once again, parameters with dependency must appear in order of dependency otherwise you'll get an error.

FYI, the dependencies in this query are highlighted. However, this looks like the main dataset query rather than a parameter dataset query and if so this is not the one you want to remove the dependencies from. Paramter order will need to be enforced if the parameters are dependet on each other, so it's the queries that feed the parameters you want to be looking at and not the main dataset query.

SELECT
NON EMPTY { } ON COLUMNS,
NON EMPTY { ([Organisation].[Business Unit Description].[Business Unit Description].ALLMEMBERS * [Organisation].[Room Local Code].[Room Local Code].ALLMEMBERS * [Organisation].[Business Area Description].[Business Area Description].ALLMEMBERS * [Time].[Hour Description].[Hour Description].ALLMEMBERS * [Date].[Date].[Date].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM (
SELECT ( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( STRTOSET(@.OrganisationRoomLocalCode, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( STRTOSET(@.DateDate, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( STRTOSET(@.OrganisationBusinessAreaDescription, CONSTRAINED) ) ON COLUMNS
FROM (
SELECT ( { [Organisation].[Room Type Description].&[Recovery room] } ) ON COLUMNS
FROM [Clinical Performance])))))
WHERE ( [Organisation].[Room Type Description].&[Recovery room], IIF( STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED).Count = 1, STRTOSET(@.OrganisationMainUnitDescription, CONSTRAINED), [Organisation].[Main Unit Description].currentmember ) )
CELL PROPERTIES VALUE