Edit expression In Charts

Question

User-833248386 posted

 Hi Everyone,

                     I am using Stored Procedure and i want to get rid of some of the Fields returned by using Filter Expression in Charts.

In the Stored procedure I am acquiring data from 4 tables according to certain Criterias.When i run the Stored Procedure in Query Analyzer  then i get the desired Output.But when i call that Stored Procedure in Charts and use the Filter Expression then the expression is not working. My Filter Expression is:

 

=Iif(Parameters!view.Value=1,Fields!RepDate1.Value,Iif(Parameters!view.Value=2,Fields!RepDate2.Value,Iif(Parameters!view.Value=3,

Fields!RepDate3.Value,Iif(Parameters!view.Value=4,Fields!RepDate4.Value,nothing))))

                                                                                         In Charts is it possible to generate Reports for the Fields that are of data type nvarchar? Please Clarify.

Thanks

Regards 

Navdeep 

<o:p> </o:p>

Answer 1

User-1136466523 posted

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>

I’m not sure how do you handle with your chart control. Generally, you can filter your data by setting functions in filter tab.  Besides, you mentioned that if it is possible to generate Reports for the Fields those are of data type nvarchar. You can load the nvarchar typed data filed to the CategoryGroups expression or SeriesGroups expression, but it can’t be added to the value expression.

<o:p> </o:p>

Thanks.

 

Answer 2

User-833248386 posted

Hi Nai-Dong Jin.

Thanks for your valuable time.Please let me know that the Filter expression that i am using is valid?

Regards

Navdeep 

Answer 3

User-1136466523 posted

Hi,

I think you can try the following post:

http://forums.asp.net/p/1266282/2380184.aspx#2380184

Thanks.

Answer 4

User-833248386 posted

Hi Nai Dong Jin, Thanks for Responding. I have tried the expression with Switch statement. When I insert static values in the CategoryGroup e:g Repdate1.value then it works.But when i use simple expression like =Switch(Parameters!view.Value=1,Fields!RepDate1.Value,Parameters!view.Value=2,Fields!RepDate2.Value) How to get the multiple values of date in the above expression?   Regards Navdeep

<input name="ctl00$ctl00$bcr$bcr$ctl00$PostList$ctl04$ctl07$ctl01" id="ctl00_ctl00_bcr_bcr_ctl00_PostList_ctl04_ctl07_ctl01_State" value="value:" type="hidden">