May 19, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Multiple Values and Defaul Value ParameterMultiple Values and Defaul Value Parameter
Previous Previous
 
Next Next
New Post
 4/1/2008 2:00 PM
 

Hi Enesys Experts,

Will need your suggestion on below case:

Column: "CF_HWSW" contains data: Software, Hardware, Both

Parameter: "AssociatedFunctions" contains Software, Hardware (Not allow blank)

I add below filter on dataset

=Fields!CF_HWSW.Value Operator:In =Parameters!AssociatedFunctions.Value And

It works, but then I need a default filter to show the data contains "Both" everytime.

I add another filter like below, but I cannot change the clause "And" to be "Or". Do you have any suggestion to fulfill this request?

=Fields!CF_HWSW.Value Operator:= ="Both"

New Post
 4/1/2008 3:34 PM
 

Hi,

You can use the following alternative :

You create an Internal parameter (say InAssociatedFunctions) which value is derived from your AssociatedFunctions parameter using the following expression:

="('" & Join(Parameters!AssociatedFunctions.Value, "','") & "')"

You could then use the following query:

<?xml version="1.0" encoding="utf-8" ?>

<root xmlns="http://enesyssoftware.com/schemas">

  <list title="Products" relativeSiteUrl="/sites/demo/"  tableName="Products">

    <fields>Title,CF_HWSW</fields>

    <query></query>

  </list>

  <sqlOp op="select">

    <dstTableName>filteredProducts</dstTableName>

    <sourceTableName>Products</sourceTableName>

    <selectExpression>CF_HWSW IN @InAssociatedFunctions! OR CF_HWSW='Both'</selectExpression>

  </sqlOp>

  <resultSet>filteredProducts</resultSet>

</root>

Let me know if it helps,


Frederic LATOUR
ENESYS
New Post
 4/2/2008 12:09 PM
 

Hi Frédéric,

Thanks for your solution, it's a useful tip and I might need it, too.

But in my case, I couldn't do it. Because CF_HWSW is a caculated field rather than a sharepoint field.

It would be much appreciated if any other soultion to it.

Thanks,

Steve Wang

New Post
 4/2/2008 1:23 PM
 

Hi,

I suppose you mean a calculated field that you created at the dataset level within the report designer.

In order to see if I can come up with an alternative solution, I would like to know the expression you are using for this calculated field?

Regards,


Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Multiple Values and Defaul Value ParameterMultiple Values and Defaul Value Parameter

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement