.rdlc table use of SUM and SWITCH together?

Hello everyone, thanks in advance for reading. I'm new to reports and have tried searching for my answer with no luck. Any direction would be great.

Here is the issue, I have 3 colums in the dataset which display String data ("High", "Medium", or "Low")

I've added a column to the table on the report where I would like to convert the value of "High", "Medium" and "Low" to 3,2,1 respectively then SUM these numbers.

Is this possible? I've tried several variations of the code below--maybe it's not possible to do what I want? Thanks again for your time and help.

Fields!PP.Value is set to:

=Switch(Fields!Avail_Rank.Value = "High", 3, Fields!Avail_Rank.Value = "Medium", 2, Fields!Avail_Rank.Value = "Low", 1)

=Switch(Fields!Volume.Value = "High", 3, Fields!Volume.Value = "Medium", 2, Fields!Volume.Value = "Low", 1)

=Switch(Fields!Integ_Rank.Value = "High", 3, Fields!Integ_Rank.Value = "Medium", 2, Fields!Integ_Rank.Value = "Low", 1)

=Sum(Fields!Avail_Rank.Value + Fields!Volume.Value + Fields!Integ_Rank)

One way of doing this is to define calculated fields on your dataset.

For example, define a calculated field called Avail_Rank_Numeric with the value expression: =Switch(Fields!Avail_Rank.Value = "High", 3, Fields!Avail_Rank.Value = "Medium", 2, Fields!Avail_Rank.Value = "Low", 1)

Then, in the Sum aggregate function in the report body use it as follows:
=Sum(Fields!Avail_Rank_Numeric.Value + ...)

-- Robert

|||Thank you very much! Your idea worked perfectly!

.doc iFilter not working for Mobile docs

Hi,
I have implemented full text searching over files stored in a varbinary(max)
field and this works great
The only issue i am now having is that users creating office documents
created on a Windows Mobile device such as word docs are not being searched.
The extension is .doc but the files look cut down in size.
Does anyone know of a filter or filter update that will also search office
type files created on a Windows Mobile device?
Thanks,
Jeff
The iFilters are specific for document type. The PocketWord application does
not save it in a format that the Office iFilter can understand. You would be
better off to convert them to Word.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:87EE86C3-0B73-4F23-B1C2-FCB85A15DF5B@.microsoft.com...
> Hi,
> I have implemented full text searching over files stored in a
> varbinary(max)
> field and this works great
> The only issue i am now having is that users creating office documents
> created on a Windows Mobile device such as word docs are not being
> searched.
> The extension is .doc but the files look cut down in size.
> Does anyone know of a filter or filter update that will also search office
> type files created on a Windows Mobile device?
> Thanks,
> Jeff
|||Hi Hilary,
Thanks for your answer.
What I find strange is that the device saves the document with the extension
..doc, but is not a true word document format. So when I check the file
extension with the supported SQL iFilter extensions I get a match and save it
in the db for indexing and searching.
How would I go about programaticaly converting the uploaded docs from the
mobile devices to the full Office document standard supported by the Office
iFilter?
Thanks for your help,
Jeff
"Hilary Cotter" wrote:

> The iFilters are specific for document type. The PocketWord application does
> not save it in a format that the Office iFilter can understand. You would be
> better off to convert them to Word.
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:87EE86C3-0B73-4F23-B1C2-FCB85A15DF5B@.microsoft.com...
>
>
|||You would have to use Word to convert the files to the Office Word document
format as opposed to the Pocket Word format.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:20A3F7E8-C0C6-490A-B555-EAD7931C62E0@.microsoft.com...[vbcol=seagreen]
> Hi Hilary,
> Thanks for your answer.
> What I find strange is that the device saves the document with the
> extension
> .doc, but is not a true word document format. So when I check the file
> extension with the supported SQL iFilter extensions I get a match and save
> it
> in the db for indexing and searching.
> How would I go about programaticaly converting the uploaded docs from the
> mobile devices to the full Office document standard supported by the
> Office
> iFilter?
> Thanks for your help,
> Jeff
> "Hilary Cotter" wrote: