search reports only dwg file extentions

[Anonymous]

Hi all you experts 🙂

does anybody know how to define the search Conditions in the vault reports.

I use the System File Properties Table Report as test, and only wan't to search for files with the extention dwg?

how do i do this. no matter what i try it to type into the search template it does not work.

please help.

Regards Kent boettger

[wayne.brill · Accepted solution]

Hi Kent,

I am not an expert on RDLC and Vault reports but I did find a way to make the Hidden Visibility expression on the  on TableRow True or False depending on the extension. The "File Table.rdlc file has this function. (I opened it in Notepad)

 <Code>Function GetExtension(st1 As String)     If st1.Contains(".") Then             Return (UCase(Right(st1, Len(st1) - InStrRev(st1, "."))))     End If

    Return "" End Function</Code>

I used this function in the expression for the Table Row:

=IIf(Code.GetExtension(Fields!ClientFileName.Value) <>

"DWG", True, False)

In my tests only the dwg files are listed when I run the report. I attached a screenshot to help explain.

This page has a description of using an expression to hide a row:

http://msdn.microsoft.com/en-us/library/dd354976.aspx

Thanks,

Wayne

[Anonymous]

Thanks looks like this is just what i needed