February 3, 2013 at 11:40 pm
Hi all,
In my report i need to hide a header part based on the dataset value.Please help me how to link the dataset to report header to get value?
Regards,
Abdul
February 4, 2013 at 1:35 am
Use an expression on the visable property of the header part.
If the data in the data set is right set it to True, if not set it to false
=IIF(Fields!Column.Value "DATASETNAME" = 1, "True", "False")
February 4, 2013 at 1:42 am
This is showing error, It is taking in aggrecated like First(Fields!Control.Value,CallSummaryGeneral")="G1".
February 4, 2013 at 1:43 am
Post the full expression
February 4, 2013 at 1:46 am
=iif(Parameters!Additional_Info.Value="Show",True,
iif(First(Fields!Control.Value, "CallSummaryGeneral")="G1",True,False))
February 4, 2013 at 1:57 am
Well I can't see nothing wrong with the expression.
Can you zip up the solution and the report so I can take a look?
February 4, 2013 at 2:00 am
Mr. Green,The problem is it not showing the fields values in the header, Is coming under dataset,If i take from dataset it give the values with aggricate functions.
February 4, 2013 at 2:05 am
Well your expression is incorrect then
If you want the data set value to appear in the header then that needs to go as part of your header part or as part of the expressions
=iif
(
Parameters!Additional_Info.Value="Show", -- Condition to check
First(Fields!Control.Value, "CallSummaryGeneral"), --What to do when it is true
"" --What to do when it is False
)
So if Additional_Info.Value = Show, then get the first Control.Value record from the CallSummaryGeneral dataset, otherwise just bring back an empty string.
Or am I missing the point on this one?
February 4, 2013 at 2:09 am
can i use this with out using the first function? or This first function will take values for each group?
because on each group the value is displaying.
February 4, 2013 at 2:18 am
Not that I am aware of, otherwise you will get the whole list of Control.Value in your header if you remove the first clause.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply