Hi Ven,

Were you able to solve your issue? I am not able to understand clearly what exactly your issue was?

Is it that if you enter - 'Ind' in your parameter...

Hi Mohammed,

Thanks for your input. I was planning to check this today once I get hold of those credentials which is running Reporting Services and I am sure it would...

CEILING(RND()*1000)

Might help someone.

John,

Any specific reason why you want to do that ?

Hi Jules,

If the question posted by you is still unanswered, below is what you can do for cell background color.

=SWITCH(

DATEDIFF("m",Fields!Date.Value,Now)=0,"Green",

DATEDIFF("m",Fields!Date.Value,Now)=1,"Orange",

DATEDIFF("m",Fields!Date.Value,Now)=2,"Red")

Though above is self explanatory, adding below note would do no...

Too little info to help.

Put values 1,2 in your IIF statement to see which part is getting evaluated.

=IIF(

Month(Parameters!EndDate.Value) > MAX(Fields!MonthNmbr.Value),

10,20)

)

Would you have shared some screenshots, it would have been easier to comment.

Would I have been in your situation, I would have simply recreated the matrix. There have been many...

Shouldn't second "Count" be "CountRows" ?

try something like below

=IIF(Parameters!YourParameter.Count=CountRows(Fields!DataSetFieldName.Value, "Name OF Your DataSet"),"ALL",Join(Parameters! YourParameter.Value,","))

<I haven't tested above, kindly give it a try>

Struggling to achieve this, I got my Job done by providing a Drill Through, creating two RDLs each with the two different texts...

I am using SQL Server 2008R2, if that is of any help.

Your Parameter should be of Date Type, the below would help.

=DATEADD (DateInterval.Year, -1, Today())

If not, use CDATE and convert it to Date and then Use above.

Hi Pete,

Jut thought to update you on this....

the object types were exactly same - "Line" and not "Smooth Line", still there were Issues.

There could have been issues with scaling,...

Hi Pete,

I just didn't realized I was in 2005 forum. I am, in fact using SQL Server 2008R2.

Athar

Any specific reason you want to use Subreport here ? You can just as well create a single tablix to show the same layout as in screenshot.

I would try to...

I would believe that the solution I mentioned should be fine even if the number of values in column is unknown (as is normally the case, its determined by query...