Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 30, 2012 12:38 PM by ccaron
0 Points
5 Posts
Jul 17, 2012 04:47 PM|LINK
Hello,
I’m using a report viewer (RDLC file) in a web page. In the dataset, some of the properties are lists:
Property lEventDescription As List(Of String) Property lEventLink As List(Of String) Property lDisplayEventLink As List(Of Boolean)
In the report viewer RDLC file, the following expressions are used to get the values from the lists (in these examples, index 0 is used):
=Fields!lEventDescription.Value(0) =iif(Fields!lDisplayEventLink.Value(0),"Blue","Black") =Fields!lEventLink.Value(0)
It works fine on our development PCs (Windows 7). The values in the arrays are correctly accessed. But it doesn’t work on our production servers (Windows Server 2008 R2).
On our production servers, an expression such as
=Fields!lEventDescription.Value(0)
is displayed as #Error.
Any idea?
Thanks,
Charles-Antoine
Contributor
4289 Points
883 Posts
Jul 20, 2012 09:54 AM|LINK
First question, is the data exactly the same in your production database with the staging/development ? Please check with that.
Jul 23, 2012 12:28 PM|LINK
Yes, the data is exactly the same in production and development.
Participant
1528 Points
285 Posts
Jul 27, 2012 08:46 PM|LINK
for multiple valued paramter, try to remove (0) part from the expression.
use only:-
=Fields!lEventDescription.Value
(0) means it will take only the first argument always.
Jul 30, 2012 12:38 PM|LINK
0 is only for the example. In our code we will access the indexes from 0 to X.
Anyway I just gave up. It simply doesn't work on MS Server 2008 R2.
ccaron
0 Points
5 Posts
Multi-value parameters in dataset for RDLC file
Jul 17, 2012 04:47 PM|LINK
Hello,
I’m using a report viewer (RDLC file) in a web page. In the dataset, some of the properties are lists:
In the report viewer RDLC file, the following expressions are used to get the values from the lists (in these examples, index 0 is used):
It works fine on our development PCs (Windows 7). The values in the arrays are correctly accessed. But it doesn’t work on our production servers (Windows Server 2008 R2).
On our production servers, an expression such as
is displayed as #Error.
Any idea?
Thanks,
Charles-Antoine
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: Multi-value parameters in dataset for RDLC file
Jul 20, 2012 09:54 AM|LINK
First question, is the data exactly the same in your production database with the staging/development ? Please check with that.
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.
ccaron
0 Points
5 Posts
Re: Multi-value parameters in dataset for RDLC file
Jul 23, 2012 12:28 PM|LINK
Yes, the data is exactly the same in production and development.
jeeveshfulor...
Participant
1528 Points
285 Posts
Re: Multi-value parameters in dataset for RDLC file
Jul 27, 2012 08:46 PM|LINK
for multiple valued paramter, try to remove (0) part from the expression.
use only:-
ccaron
0 Points
5 Posts
Re: Multi-value parameters in dataset for RDLC file
Jul 30, 2012 12:38 PM|LINK
Hello,
0 is only for the example. In our code we will access the indexes from 0 to X.
Anyway I just gave up. It simply doesn't work on MS Server 2008 R2.