EASY! Trim string?

I have values in a matrix takin too much space. Since they are just used as the matrix column header, cant i trim it or something. To display just the first 3 letters of the the attribute, and not the whole string? Whats the code for that?

=Fields!Collision_Type.Value thats my field right now.

Please help! thanks!

=LEFT(Fields!Collision_Type.Value,1,3) I believe. Or some variant of that syntax.|||

I believe it should be Mid(Fields!Collision_Type.Value,1,3)

|||

Yes, you can change it to this to always show the first 3 characters:

=Left(Fields!Collision_Type.Value, 3)

Jarret

|||Thanks for the quick response, this worked great!|||This one worked as well, hum i wonder what the difference is? But they both seem to display the same. Thanks!|||

There is no difference really, the Mid function allows you to give it a starting position and how many characters to return.

Jarret

Dynamicly displaying Page Header and Page Footer

I need to show or hide Page Header and Footer on the last page of a report
based on a parameter. Is there a way of doing this?
Thanks in advanceIt seems that you can't dynamically choose visibility for the header or
footer. It's either on or off. But you can control the visibility of
elements on the header and footer.
Create a footer. Set DisplayOnFirstPage and DisplayOnLastPage = Yes
Add a rectangle. Add controls to the footer inside the rectangle.
On the Visibility parameter of the rectangle, type
=IIF(Globals!PageNumber>1, False, True)
If your report stretches over 2 or more pages, you will see the content of
the rectangle on page 2 and out. You can change the expression according to
your needs, this was just a quick example.
Kaisa M. Lindahl Lervik
"Wendy" <Wendy@.discussions.microsoft.com> wrote in message
news:A80B4773-F77A-43B5-BA3C-C2662073B2FD@.microsoft.com...
>I need to show or hide Page Header and Footer on the last page of a report
> based on a parameter. Is there a way of doing this?
> Thanks in advance
>|||the same way :
From http://www.developmentnow.com
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

dynamically sort columns?

Hi,
Can you set up a report so that you can dynamically sort columns.
ie.
When viewing a report you click on a header of a column and sort by
this column.
If so can you point me to an example
Thanks in AdvanceHi Paul,
You can rightclick on the columnheaders textbox to display the
properties of this, select the tab "Interactive Sort", and select "Add
an interactive sort action to this textbox".
Below you can specify how you want the data to be sorted, ie.
selecting a field from your dataset.
Regards,
Rune Brahe Bjerregaard
On 30 Jul., 06:03, paulhux...@.hotmail.com wrote:
> Hi,
> Can you set up a report so that you can dynamically sort columns.
> ie.
> When viewing a report you click on a header of a column and sort by
> this column.
> If so can you point me to an example
> Thanks in Advance|||On Jul 30, 12:03 am, paulhux...@.hotmail.com wrote:
> Hi,
> Can you set up a report so that you can dynamically sort columns.
> ie.
> When viewing a report you click on a header of a column and sort by
> this column.
> If so can you point me to an example
> Thanks in Advance
Right Click on the title of the column which you wish to use an
Interactive sort with. On the drop down menu select properties. When
the properties widow pops up go to the tab labeled "Interactive
Sort". Click the check box at the top and under the drop down
selection box pick the column that you are trying to sort by. For
example, you selected the column with the datafield "Order Number" so
select that in your interactive sort drop down... otherwise it will
sort according to another column when you click on it. Preview the
report to make sure it works.|||Thanks

Dynamic Text in Group Headers

I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
a group header when the group spans multiple pages. When I used to use
Crystal Reports 8.5 this was very simple to do uising the
"InRepeatedGroupHeader" built in function. I have not been able to find
anything like this in SSRS. I've seen several people asking for the same
thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?tachtenberg wrote:
> I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
> a group header when the group spans multiple pages. When I used to use
> Crystal Reports 8.5 this was very simple to do uising the
> "InRepeatedGroupHeader" built in function. I have not been able to find
> anything like this in SSRS. I've seen several people asking for the same
> thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
Try Something like this:
=IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
,Globals!ReportName)
-MM|||That will not work because some groups span more than one page and others do
not. Page numbering does not reset with each group.
"Michael" wrote:
> tachtenberg wrote:
> > I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
> > a group header when the group spans multiple pages. When I used to use
> > Crystal Reports 8.5 this was very simple to do uising the
> > "InRepeatedGroupHeader" built in function. I have not been able to find
> > anything like this in SSRS. I've seen several people asking for the same
> > thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
> Try Something like this:
> =IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
> ,Globals!ReportName)
>
> -MM
>|||My bad. I didn't read the question slow enough. I thought it seemed a
little too easy.
Anyway, I did find this that might be what you need.
http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx
tachtenberg wrote:
> That will not work because some groups span more than one page and others do
> not. Page numbering does not reset with each group.
> "Michael" wrote:
>> tachtenberg wrote:
>> I'm woirking in SSRS 2005. I'm looking for a way to add "(Continued...)" to
>> a group header when the group spans multiple pages. When I used to use
>> Crystal Reports 8.5 this was very simple to do uising the
>> "InRepeatedGroupHeader" built in function. I have not been able to find
>> anything like this in SSRS. I've seen several people asking for the same
>> thing on MSDN but no solutions. Any ideas on how this can be done in SSRS?
>> Try Something like this:
>> =IIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
>> ,Globals!ReportName)
>>
>> -MM|||On Jan 18, 2:25=A0pm, Michael <Mich...@.discussions.microsoft.com> wrote:
> My bad. I didn't read the question slow enough. I thought it seemed a
> little too easy.
> Anyway, I did find this that might be what you need.http://blogs.msdn.com/=
chrishays/archive/2006/09/27/ContinuedHeader.aspx
>
> tachtenberg wrote:
> > That will not work because some groups span more than one page and other=s do
> > not. =A0Page numbering does not reset with each group.
> > "Michael" wrote:
> >> tachtenberg wrote:
> >> I'm woirking in SSRS 2005. =A0I'm looking for a way to add "(Continued=...)" to
> >> a group header when the group spans multiple pages. =A0When I used to =use
> >> Crystal Reports 8.5 this was very simple to do uising the
> >> "InRepeatedGroupHeader" built in function. =A0I have not been able to =find
> >> anything like this in SSRS. =A0I've seen several people asking for the= same
> >> thing on MSDN but no solutions. =A0Any ideas on how this can be done i=n SSRS?
> >> Try Something like this:
> >> =3DIIF(Globals!PageNumber > 1,Globals!ReportName &" (Continued)"
> >> ,Globals!ReportName)
> >> -MM- Hide quoted text -
> - Show quoted text -
Also, here's white paper that shows (among other things) how to reset
page numbers when groups change.
http://msdn2.microsoft.com/en-us/library/bb395166.aspx|||I've looked at Chris's work around. Unfortunately, there are other items
above the table I need the repeated group headers in so it will not work.
"Michael" wrote:
> My bad. I didn't read the question slow enough. I thought it seemed a
> little too easy.
> Anyway, I did find this that might be what you need.
> http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx
>